ERD
Tables (8)
algorithm (Untitled5)
- id (Key) — varchar(20) — Primary key — NOT NULL
- grade (Field) — varchar(20)
- acquisition_date (Field2) — datetime
attendance (Untitled6)
- id (Key) — varchar(20) — Primary key — NOT NULL
- attendance (Field) — tinyint(1)
- sign_in (Field2) — datetime
- sign_out (Field3) — datetime
grade (Untitled4)
- id (Key) — varchar(20) — Primary key — NOT NULL
- first_exam (Field) — varchar(3)
- second_exam (Field2) — varchar(3)
- third_exam (Field3) — varchar(3)
group (Untitled)
- id (Key) — varchar(20) — Primary key — NOT NULL
- group (Field4) — varchar(20) — NOT NULL
log (Untitled7)
- id (Key) — varchar(20) — Primary key — NOT NULL
- reg_user (Field) — varchar(20)
- reg_dt (Field2) — datetime
- last_user (Field3) — varchar(20)
- last_dt (Field4) — datetime
region (Untitled2)
- id (Key) — varchar(20) — Primary key — NOT NULL
- name (Field) — varchar(20) — NOT NULL
student
- id — varchar(20) — Primary key — NOT NULL
- grade_id (Key2) — varchar(20) — Foreign key → grade.id — NOT NULL
- log_id (Key4) — varchar(20) — Foreign key → log.id — NOT NULL
- algorithm_id (Key6) — varchar(20) — Foreign key → algorithm.id — NOT NULL
- teacher_id (Key7) — varchar(20) — Foreign key → teacher.id — NOT NULL
- region_id (Key) — varchar(20) — Foreign key → region.id — NOT NULL
- group_id (Key3) — varchar(20) — Foreign key → group.id — NOT NULL
- attendance_id (Key5) — varchar(20) — Foreign key → attendance.id — NOT NULL
- account (Field) — varchar(20) — NOT NULL
- name (Field2) — varchar(100) — NOT NULL
- hp (Field3) — varchar(20)
- age (Field4) — varchar(5)
- gender (Field5) — varchar(20)
- curriculum (Field6) — varchar(20)
teacher (Untitled3)
- id (Key) — varchar(20) — Primary key — NOT NULL
- account (Field) — varchar(20) — NOT NULL
- name (Field2) — varchar(20) — NOT NULL
- hp (Field3) — varchar(20) — NOT NULL