BASIC_BOARD_230622
Tables (6)
Untitled (user)
- Key (id) — int — Primary key — NOT NULL
- Field (identifier) — varchar(255) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (nickname) — varchar(255) — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (created_date) — datetime — NOT NULL
- Field (update_date) — datetime — NOT NULL
- Field (email_auth) — tinyint(1) — NOT NULL
- Field (email_received) — tinyint(1) — NOT NULL
Untitled (auth_email)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (token) — varchar(255) — NOT NULL
- Field (created_date) — datetime — NOT NULL
Untitled (article)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (type) — varchar(255) — NOT NULL
- Field (nickname) — varchar(255) — NOT NULL
- Field (title) — varchar(255) — NOT NULL
- Field (content) — text — NOT NULL
- Field (created_date) — datetime — NOT NULL
- Field (update_date) — datetime — NOT NULL
- Field (view_count) — int — NOT NULL
- Field (like_count) — int — NOT NULL
Untitled (like)
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (article_id) — int — Foreign key → Untitled.Key — NOT NULL