1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
| /*table article*/
CREATE TABLE [dbo].[bouteuil](
[refbtl] [nvarchar](255) NOT NULL,
[prixbtl] [int] NULL,
[txtonag] [float] NULL,
[stkin] [int] NULL,
[ordern] [int] NULL)
/*table Lign commande*/
CREATE TABLE [dbo].[COMMD](
[refcom] [int] NOT NULL,
[date] [date] NULL,
[refclicm] [nvarchar](255) NULL,
FOREIGN KEY([refclicm])REFERENCES [dbo].[Client] ([refcli]))
/*table commande*/
CREATE TABLE [dbo].[Comde](
[refcmd] [int] NOT NULL,
[refclicmdd] [nvarchar](255) NULL,
[qtecmd] [int] NULL,
[tonagecmd] [int] NULL,
[montcmd] [int] NULL,
[margecmd] [int] NULL,
[gabaritcmd] [nvarchar](255) NULL,
[zonnecmd] [nvarchar](255) NULL,
[reliq] [int] NULL,
[cummul] [int] NULL
FOREIGN KEY([gabaritcmd])REFERENCES [dbo].[bouteuil] ([refbtl])
FOREIGN KEY([refclicmdd])REFERENCES [dbo].[Client] ([refcli])
FOREIGN KEY([refcmd])REFERENCES [dbo].[COMMD] ([refcom])
FOREIGN KEY([zonnecmd])REFERENCES [dbo].[zonne] ([refzone]))
/*table reliquat*/
CREATE TABLE [dbo].[Reliquats](
[refcomrlq] [int] NOT NULL,
[reflivrerlq] [int] NOT NULL,
[qtecomrlq] [int] NULL,
[qtelivrlq] [int] NULL,
[restrlq] [int] NULL,
[gabaritrlq] [nvarchar](255) NULL,
[zonnerlq] [nvarchar](255) NULL,
[Clirlq] [nvarchar](255) NULL
FOREIGN KEY([Clirlq])REFERENCES [dbo].[Client] ([refcli])
FOREIGN KEY([gabaritrlq])REFERENCES [dbo].[bouteuil] ([refbtl])
FOREIGN KEY([refcomrlq])REFERENCES [dbo].[COMMD] ([refcom])
FOREIGN KEY([reflivrerlq])REFERENCES [dbo].[livr] ([reflivr])
FOREIGN KEY([zonnerlq])REFERENCES [dbo].[zonne] ([refzone]))
GO
/*table ligne livr*/
CREATE TABLE [dbo].[livr](
[reflivr] [int] NOT NULL,
[datelivr] [date] NULL,
[refcomlivr] [int] NULL,
FOREIGN KEY([refcomlivr])REFERENCES [dbo].[COMMD] ([refcom]))
GO
/*table livraison*/
CREATE TABLE [dbo].[livraisons](
[reflivre] [int] NOT NULL,
[refcomlivr] [int] NOT NULL,
[qtelivr] [int] NULL,
[tonagelivr] [int] NULL,
[montlivr] [int] NULL,
[margelivr] [int] NULL,
[gabaritlivr] [nvarchar](255) NULL,
[zonnelivr] [nvarchar](255) NULL,
[restlivr] [int] NULL,
[qtecomm] [int] NULL
FOREIGN KEY([gabaritlivr])REFERENCES [dbo].[bouteuil] ([refbtl])
FOREIGN KEY([refcomlivr])REFERENCES [dbo].[COMMD] ([refcom])
FOREIGN KEY([reflivre])REFERENCES [dbo].[livr] ([reflivr])
FOREIGN KEY([zonnelivr])REFERENCES [dbo].[zonne] ([refzone]))
GO |
Partager