rdbms

Tables (7)

attendance

  • attendanceid — int — Primary key — NOT NULL
  • account (account2) — varchar(20) — Foreign key → student.account — NOT NULL
  • attendance1/1 — tinyint(1)
  • attendance1/1signin — datetime
  • attendance1/1signout — datetime
  • attendance1/2 — tinyint(1)
  • attendance1/2signin — datetime
  • attendance1/2signout — datetime
  • attendance1/3 — tinyint(1)
  • attendance1/3signin — datetime
  • attendance1/3signout — datetime
  • attendance1/4 — tinyint(1)
  • attendance1/4signin — datetime
  • attendance1/4signout — datetime
  • attendance1/5 — tinyint(1)
  • attendance1/5signin — datetime
  • attendance1/5signout — datetime
  • attendance1/6 — tinyint(1)
  • attendance1/6signin — datetime
  • attendance1/6signout — datetime
  • attendance1/7 — tinyint(1)
  • attendance1/7signin — datetime
  • attendance1/7signout — datetime
  • attendance1/8 — tinyint(1)
  • attendance1/8signin — datetime
  • attendance1/8signout — datetime
  • attendance1/9 — tinyint(1)
  • attendance1/9signin — datetime
  • attendance1/9signout — datetime
  • attendance1/10 — tinyint(1)
  • attendance1/10signin — datetime
  • attendance1/10signout — datetime
  • Field

grade

  • gradeid — int — Primary key — NOT NULL
  • account — varchar(20) — Foreign key → student.account — NOT NULL
  • firstexam — varchar(3)
  • secondexam — varchar(3)
  • thirdexam — varchar(3)
  • Field

group

  • group — varchar(20) — Primary key — NOT NULL
  • groupname — varchar(100)

projectteam

  • teamid — varchar(20) — Primary key — NOT NULL
  • teamname — varchar(20)
  • domain — varchar(20)
  • group (group2) — varchar(20) — Foreign key → group.group — NOT NULL
  • score — int

student

  • account — varchar(20) — Primary key — NOT NULL
  • name — varchar(100)
  • hp — varchar(20)
  • age — varchar(5)
  • gender — varchar(20)
  • curriculum — varchar(20)
  • region — varchar(20)
  • algorithmgrade — varchar(20)
  • algorithmacquisitiondate — datetime
  • group (group2) — varchar(20) — Foreign key → group.group — NOT NULL

teacher

  • id — varchar(20) — Primary key
  • name — varchar(20)
  • hp — varchar(20)
  • group (group2) — varchar(20) — Foreign key → group.group — NOT NULL

team

  • account — varchar(20) — Foreign key → student.account — NOT NULL
  • teamid — varchar(20) — Foreign key → projectteam.teamid — NOT NULL