School class

Tables (4)

cabinet

  • id_cabinet — Integer — Primary key — NOT NULL
  • Name — Varchar(50)

log

  • id — Integer — Primary key — NOT NULL
  • id_student — Integer — Foreign key → student.id_student — NOT NULL
  • id_place — Integer — Foreign key → place.id_place — NOT NULL
  • id_cabinet — Integer — Foreign key → cabinet.id_cabinet — NOT NULL
  • Date — DataTime
  • StartTime — TimeStamp
  • EndTime — TimeStamp

place

  • id_place — Integer — Primary key — NOT NULL
  • Row — Integer
  • Desk — Integer
  • Variant — Integer

student

  • id_student — Integer — Primary key — NOT NULL
  • First Name — Varchar(50)
  • LastName — Varchar(50)
  • Field