Таблица

[ SQL ]

26 Jun 2012

Создание таблицы SQL

 CREATE TABLE abon(
nomer [INT] NOT NULL,
 [Количество оплаченных занятий] [tinyint] NOT NULL,
DATA [DATE] NOT NULL,
IDstudent [INT] NOT NULL REFERENCES students (IDStudent),
IdTrener [tinyint] NOT NULL REFERENCES treners (IDTrener),
CONSTRAINT [PK_abon] PRIMARY KEY (nomer)
 )