Untitled

CREATE TABLE BaiThiKyNang (
IDBaiThi varchar(100) not null,
TenBaiThi varchar(100),
MoTaBaiTHi text,
PasswordBaiThi varchar(100),
LoaiBaiThi varchar(100),
ThoiLuongBaiThi interval,
ThoiGianChoPhepBatDau timestamp with time zone,
ThoiGianDongBaiThi timestamp with time zone,
DiemToiDa float,
CONSTRAINT ID_baithi PRIMARY KEY (IDBaiThi)
);

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

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