1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE TABLE Groupe
([IDGROUP] INT PRIMARY KEY NOT NULL IDENTITY,
Name VARCHAR(255) NOT NULL,
GroupLevel HIERARCHYID)
CREATE TABLE Panier
([IDPANIER] INT PRIMARY KEY NOT NULL IDENTITY,
Name VARCHAR(255) NOT NULL,
[IDGroup] int NOT NULL,
constraint FK_GROUP_PANIER foreign key (IDGROUP) references Groupe (IDGROUP) )
CREATE TABLE Ligne
([IDLigne] INT PRIMARY KEY NOT NULL IDENTITY,
Name VARCHAR(255) NOT NULL,
[IDGroup] int NOT NULL,
constraint FK_GROUP_LIGNE foreign key (IDGroup) references Groupe (IDGROUP) ) |
Partager