ㅇㅇ
Tables (11)
attendance
- enrollment_id — VARCHAR(36) — Primary key — NOT NULL
- meeting_date — DATE — Primary key — NOT NULL
- status — VARCHAR(15)
- note — VARCHAR(255)
class
- id — VARCHAR(36)
- school_id — VARCHAR(36) — NOT NULL
- grade — INT
- class_name — VARCHAR(50)
- year — INT
- homeroom_teacher_id — VARCHAR(36)
course_section
- id — VARCHAR(36)
- subject_id — VARCHAR(36) — NOT NULL
- teacher_id — VARCHAR(36) — NOT NULL
- room_id — VARCHAR(36)
- term — VARCHAR(50)
- schedule — JSON
education_office
- id — VARCHAR(36)
- name — VARCHAR(255) — NOT NULL
enrollment
- id — VARCHAR(36)
- student_id — VARCHAR(36) — NOT NULL
- section_id — VARCHAR(36) — NOT NULL
- enrolled_at — DATETIME — NOT NULL
- status — VARCHAR(30)
room
- id — VARCHAR(36)
- school_id — VARCHAR(36) — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
- capacity — INT
- building — VARCHAR(100)
- floor — INT
room_reservation
- id — VARCHAR(36)
- room_id — VARCHAR(36) — NOT NULL
- teacher_id — VARCHAR(36)
- class_id — VARCHAR(36)
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- purpose — VARCHAR(255)
- memo — VARCHAR(255)
school
- id — VARCHAR(36)
- education_id — VARCHAR(36) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255)
student
- id — VARCHAR(36)
- class_id — VARCHAR(36) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- birth_date — DATE
- student_no — VARCHAR(50)
- status — VARCHAR(30)
subject
- id — VARCHAR(36)
- subject_name — VARCHAR(100) — NOT NULL
- code — VARCHAR(50)
- credit — INT
teacher
- id — VARCHAR(36)
- school_id — VARCHAR(36) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(50)
- hire_date — DATE
- email — VARCHAR(255)