DMS
Tables (6)
extension_apply
- time — int — Primary key — NOT NULL
- id (student_id) — varchar(20) — Foreign key → student.id — NOT NULL
- class_ — int
- seat — int
point_history
- id — int — Primary key
- point_date — date
- id (student_id) — varchar(20) — Foreign key → student.id — NOT NULL
- id (point_id) — int — Foreign key → point_item.id
point_item
- id — int — Primary key
- reason — varchar(100)
- point — int
- type — tinyint(1)
point_status
- id (student_id) — varchar(20) — Foreign key → student.id — NOT NULL
- good_point — int
- bad_point — int
- penalty_level — int
- penalty_status — tinyint(1)
stay
- id (student_id) — varchar(20) — Foreign key → student.id — NOT NULL
- value — int
student
- id — varchar(20) — Primary key — NOT NULL
- pw — varchar(100)
- name — varchar(20)
- number — int
- email — varchar(50)