ㅅㄴㄴㅇ
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