cum 4

mail@pastecode.io avatar
unknown
plain_text
2 years ago
771 B
6
Indexable
Never
create table IDThiSinhDaDuThi (
  IdKyThi varchar(255), 
  IdThiSinhDaDuThi varchar(255),  
  PRIMARY KEY (IdKyThi, IdThiSinhDaDuThi));
create table BangTraLoiCuaThiSinh (
  IdBangTraLoi varchar(255), 
  IdBaiThi varchar(255), 
  HoVaTenThiSinhTraLoi varchar(255),
  NgayGioThucHien DATE,
  ThoiLuongThucHien interval,
  TongDiemBaiThi real, 
  IdThisinh varchar(255),
  PRIMARY KEY (IdBangTraLoi));
create table LuaChon (
  SoThuTuLuaChon varchar(255), 
  IdCauHoi varchar(255), 
  LuaChonDung varchar(255), 
  Diem real , 
  VanBanLuaChon TEXT, 
  PRIMARY KEY (SoThuTuLuaChon, IdCauHoi));
create table CauTraLoi (
  SoThuTuDaLuaChon varchar(255), 
  IdCauHoi varchar(255), 
  IdBangTraLoi varchar(255),  
  PRIMARY KEY (IdCauHoi, IdBangTraLoi));