mindary
Tables (3)
chat (chats)
- id — INTEGER — Primary key
- writer (user_id) — INTEGER — Foreign key → user.id
- content — TEXT
- created_at — DATETIME
record (records)
- id — INTEGER — Primary key
- writer (user_id) — INTEGER — Foreign key → user.id
- category — VARCHAR(30)
- title — TEXT
- content — TEXT
- created_at — DATETIME
- edited_at — DATETIME
- liked — BOOLEAN
user (users)
- id — INTEGER — Primary key
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- password — VARCHAR(128)