cụm 3

 avatar
user_8066296
plain_text
2 years ago
718 B
2
Indexable
Never
CREATE TABLE BaiThiKyNang (
IDBaiThi varchar(255) not null,
TenBaiThi varchar(255),
MoTaBaiTHi text,
PasswordBaiThi varchar(255),
LoaiBaiThi varchar(255),
ThoiLuongBaiThi interval,
ThoiGianChoPhepBatDau timestamp with time zone,
ThoiGianDongBaiThi timestamp with time zone,
DiemToiDa real,
CONSTRAINT ID_baithi PRIMARY KEY (IDBaiThi)
);

CREATE TABLE NhomCauHoi (
IDNhomCauHoi varchar(255) not null,
VanBanBoTro text,
Loai varchar(255),
DiemToiDaNhomCauHoi real,
CONSTRAINT ID_nhomcauhoi PRIMARY KEY (IDNhomCauHoi)
);

CREATE TABLE CauHoiTracNghiem (
IDCauHoi varchar(255) not null,
LoiGiaiChiTiet text,
VanBanCauHoi text,
DiemToiDaCauHoi real,
CONSTRAINT ID_cauhoi PRIMARY KEY (IDCauHoi)
);