todoapp
Tables (3)
members
- id — Integer — Primary key — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- role (Field4) — ENUM — NOT NULL
schedules
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- title — VARCHAR(20) — NOT NULL
- description — TEXT
- is_completed — BOOLEAN
- due_date — DATE — NOT NULL
- created_at — TIMESTAMP
users
- id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- avatar — INT — NOT NULL