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