Yam Code

New Paste Browse

ALTER TABLE GIAOVIEN
ADD CONSTRAINT FK_GV_GV FOREIGN KEY (GVQLCM) REFERENCES GIAOVIEN

ALTER TABLE GIAOVIEN 
ADD CONSTRAINT FK_GV_BM	FOREIGN KEY (MABM) REFERENCES BOMON

--KHOA
ALTER TABLE KHOA
ADD CONSTRAINT FK_K_GV FOREIGN KEY (TRUONGKHOA) REFERENCES GIAOVIEN

--BOMON
ALTER TABLE BOMON
ADD CONSTRAINT FK_BM_GV FOREIGN KEY (TRUONGBM) REFERENCES GIAOVIEN

ALTER TABLE BOMON
ADD	CONSTRAINT FK_BM_K 	FOREIGN KEY (MAKHOA) REFERENCES KHOA

--GV_DT
ALTER TABLE GV_DT
ADD CONSTRAINT FK_GVDT_GV FOREIGN KEY (MAGV) REFERENCES GIAOVIEN

--NGUOITHAN
ALTER TABLE NGUOITHAN
ADD CONSTRAINT FK_NT_GV FOREIGN KEY (MAGV) REFERENCES GIAOVIEN

--THAMGIADT
ALTER TABLE THAMGIADT
ADD CONSTRAINT FK_TGDT_GV FOREIGN KEY (MAGV) REFERENCES GIAOVIEN

ALTER TABLE THAMGIADT
ADD CONSTRAINT FK_TGDT_CV FOREIGN KEY (MADT, STT) REFERENCES CONGVIEC

--CONGVIEC
ALTER TABLE CONGVIEC
ADD CONSTRAINT FK_CV_DT FOREIGN KEY (MADT) REFERENCES DETAI

--DETAI
ALTER TABLE DETAI
ADD CONSTRAINT FK_DT_CD FOREIGN KEY (MACD) REFERENCES CHUDE
ALTER TABLE DETAI
ADD CONSTRAINT FK_DT_GV FOREIGN KEY (GVCNDT) REFERENCES GIAOVIEN

Paste Settings

Paste Title : [Optional]

Paste Folder : [Optional]

Syntax Highlighting : [Optional]

Paste Expiration : [Optional]

Paste Status : [Optional]

Password : [Optional]

Description: [Optional]

Tags: [Optional]

Encrypt Paste (?)

You are currently not logged in, this means you can not edit or delete anything you paste. Sign Up or Login

Paste Settings

Site Languages