0309
Tables (6)
Untitled (user)
- Key (id) — integer — Primary key — NOT NULL
- Field (reg_user) — varchar(20)
- Field2 (reg_dt) — datetime
- Field3 (last_user) — varchar(20)
- Field (last_dt) — datetime
Untitled (group)
- Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (teacher_id) — varchar(20)
- Field (teacher_name) — varchar(20)
- Field (teacher_hp) — varchar(20)
Untitled (student)
- Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (account) — varchar(20)
- Field2 (name) — varchar(100)
- Field3 (hp) — varchar(20)
- Field4 (age) — varchar(5)
- Field5 (gender) — varchar(20)
- Field6 (curriculum) — varchar(20)
- Field (region) — varchar(20)
- Field2 (group) — varchar(20)
Untitled (algorithm)
- Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (grade) — varchar(20)
- Field2 (acquisition_date) — datetime
Untitled (grade)
- Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (first_exam) — varchar(3)
- Field2 (second_exam) — varchar(3)
- Field3 (third_exam) — varchar(3)
- Field (project1_score) — varchar(3)
- Field2 (project2_score) — varchar(3)
- Field3 (project3_score) — varchar(3)
Untitled (attendance)
- Key (id) — integer — Foreign key → Untitled.Key — NOT NULL
- Field (1/1) — tinyint(1)
- Field2 (1/1_sign_in) — datetime
- Field3 (1/1_sign_out) — datetime
- Field4 (1/2) — tinyint(10)
- Field5 (1/2_sigin_in) — datetime
- Field6 (1/2_sign_out) — datetime
- Field7 (1/3) — tinyint(1)
- Field8 (1/3_sign_in) — datetime
- Field9 (1/3_sign_out) — datetime