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
| CREATE TABLE dbo.F_TIERS_ADRESSE (
TAD_ID bigint NOT NULL,
TIE_ID bigint,
TAD_Adresse nvarchar(500),
TAD_CodePostal nvarchar(50),
TAD_Ville nvarchar(500),
RGN_ID bigint,
PAY_ID bigint,
TAD_CodePorte nvarchar(50),
TAD_Etage nvarchar(50),
TAD_Ascenceur bit CONSTRAINT DF_F_TIERS_ADRESSE_TAD_Ascenceur DEFAULT 0,
TAD_Telephone nvarchar(50),
TAD_Fax nvarchar(50),
TAD_Portable nvarchar(50),
TAD_Principal bit CONSTRAINT DF_F_TIERS_ADRESSE_TAD_Principal DEFAULT 0,
USR_DateCreation datetime NOT NULL CONSTRAINT DF_F_TIERS_ADRESSE_USR_DateCreation DEFAULT getdate(),
USR_CreePar nvarchar(50) NOT NULL,
USR_DateModif datetime NOT NULL CONSTRAINT DF_F_TIERS_ADRESSE_USR_DateModif DEFAULT getdate(),
USR_ModifiePar nvarchar(50) NOT NULL,
USR_DateEfface datetime,
USR_EffacePar nvarchar(50),
USR_Efface bit NOT NULL CONSTRAINT DF_F_TIERS_ADRESSE_USR_Efface DEFAULT 0,
/* Keys */
CONSTRAINT PK_F_TIERS_ADRESSE PRIMARY KEY (TAD_ID),
/* Foreign keys */
CONSTRAINT FK_F_TIERS_ADRESSE_F_TIERS
FOREIGN KEY (TIE_ID)
REFERENCES dbo.F_TIERS(TIE_ID)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT FK_F_TIERS_ADRESSE_P_PAYS
FOREIGN KEY (PAY_ID)
REFERENCES dbo.P_PAYS(PAY_ID)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT FK_F_TIERS_ADRESSE_P_REGION
FOREIGN KEY (RGN_ID)
REFERENCES dbo.P_REGION(RGN_ID)
ON DELETE NO ACTION
ON UPDATE NO ACTION
)
GO |
