CREATE TABLE asurnet.dbo.DEPARTAMENTOS (
	DPT_Id int NOT NULL,
	DPT_Nombre varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	DPT_FC datetime NULL,
	USR_ID_FC int NULL,
	DPT_FM datetime NULL,
	USR_ID_FM int NULL,
	USR_ID int NULL,
	CONSTRAINT PK_DEPART PRIMARY KEY (DPT_Id)
);

CREATE TABLE asurnet.dbo.usrdpt (
		USR_Id int NOT NULL,
		DPT_Id int NOT NULL,
		CONSTRAINT PK_usrdpt PRIMARY KEY (USR_Id, DPT_Id)
	);
ALTER TABLE asurnet.dbo.usrdpt
ADD CONSTRAINT FK_DEPARTAMENTOS FOREIGN KEY (DPT_Id) REFERENCES asurnet.dbo.DEPARTAMENTOS(DPT_Id);
