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 |
Partager