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