2.4 Коды SQL запросов на создание таблиц

Таблица animals:

CREATE TABLE animals

(

id_animals INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,

id_korm INTEGER NOT NULL,

id_strana INTEGER NOT NULL,

name VARCHAR(20) NOT NULL,

age VARCHAR(20) NOT NULL,

ves VARCHAR(20) NOT NULL

)

Таблица strana:

CREATE TABLE strana

(

id_strana INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,

name_s VARCHAR(20) NOT NULL

)

Таблица korm:

CREATE TABLE korm

(

id_korm INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,

name_k VARCHAR(20) NOT NULL

)

Таблица service:

CREATE TABLE service

(

id_ service INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,

id_sotr INTEGER NOT NULL,

id_animals INTEGER NOT NULL

)

Таблица sotr:

CREATE TABLE sotr

(

id_sotr INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,

id_post INTEGER NOT NULL,

surname VARCHAR(20) NOT NULL,

name VARCHAR(20) NOT NULL,

staj VARCHAR(20) NOT NULL

)

Таблица post:

CREATE TABLE post

(

id_post INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,

name VARCHAR(20) NOT NULL

)