gplan
Tables (6)
attendances
- id (Key) — BIGINT — Primary key — NOT NULL
- student_id (id) — BIGINT — Foreign key → users.id
- attendance_date (Field) — DATE
- status (Field2) — ENUM
- created_at (Field3) — DATETIME
classgroups (classes)
- id (Field) — BIGINT — Primary key
- name (Field2) — VARCHAR — 반 이름 (충중1학년반, 미덕2학년반 등)
requests
- id (Key) — BIGINT — Primary key — NOT NULL
- student_id (id) — BIGINT — Foreign key → users.id
- teacher_id (id2) — BIGINT — Foreign key → users.id
- type (Field) — ENUM
- content (Field2) — TEXT
- status (Field3) — ENUM
- reply_content (Field4) — TEXT
- schedule_date (Field5) — DATETIME
- created_at (Field6) — DATETIME
settings
- id (Key) — BIGINT — Primary key — NOT NULL
- attendance_start (Field) — TIME
- attendance_end (Field2) — TIME
user_classgroups
- id — BIGINT — Primary key — NOT NULL
- user_id (id2) — BIGINT — Foreign key → users.id
- classgroup_id (Field) — BIGINT — Foreign key → classgroups.id
users
- id — BIGINT — Primary key
- login_id — VARCHAR
- password (Field2) — VARCHAR
- name (Field3) — VARCHAR
- role (Field4) — ENUM
- school — VARCHAR
- grade — VARCHAR
- is_active — BOOLEAN