ㅅㄴㄴㅇ

Tables (6)

attendances

  • id — INT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • status — ENUM('PRESENT', 'ABSENT', 'LATE') — NOT NULL

branch

  • PK — int — Primary key — NOT NULL
  • user — int — NOT NULL

calendar

  • id — INT — Primary key — NOT NULL
  • grammar_unit — INT — NOT NULL
  • user — INT — NOT NULL
  • afterschool_class — INT — NOT NULL
  • is_homework — BOOLEAN
  • start_date — DATE
  • end_date — DATE
  • subject — ENUM
  • episode — INT — NOT NULL
  • message — TEXT
  • attendance_status — ENUM
  • attendance_reson — CHAR(100)
  • point — INT — NOT NULL
  • pass_rate — TINYINT
  • average — BOOLEAN
  • Field — VARCHAR(255)
  • id (id2) — INT — Foreign key → users.id — NOT NULL
  • id (id3) — INT — Foreign key → attendances.id — NOT NULL

terms

  • PK — int — Primary key — NOT NULL
  • type — varchar
  • expired_at — date
  • version — int
  • PK (PK2) — int — Foreign key → user_agreement_terms.PK — NOT NULL

user_agreement_terms

  • PK — int — Primary key — NOT NULL
  • agreement — boolean
  • term — int — NOT NULL
  • user — int — NOT NULL
  • id — INT — Foreign key → users.id — NOT NULL

users

  • id — INT — Primary key — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • role — ENUM('PUBLIC', 'ADMIN') — NOT NULL
  • PK — int — Foreign key → branch.PK — NOT NULL