seosan-issue
Tables (10)
bookmark
- user_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
comment
- id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
last_crawled_info
- category_name — VARCHAR(255)
- last_crawled_link — VARCHAR(1024)
- last_crawled_at — DATETIME
nickname_history
- id — BIGINT
- user_id — BIGINT — NOT NULL
- old_nickname — VARCHAR(40) — NOT NULL
- new_nickname — VARCHAR(40) — NOT NULL
- changed_at — DATETIME — NOT NULL
password_reset_log
- id — BIGINT
- user_id — BIGINT — NOT NULL
- requested_at — DATETIME — NOT NULL
- reset_at — DATETIME
- result — VARCHAR(16) — NOT NULL
- ip — VARCHAR(45)
- ua — VARCHAR(255)
post
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- content — MEDIUMTEXT — NOT NULL
- link — VARCHAR(1024) — NOT NULL
- pub_date — VARCHAR(64) — NOT NULL
- region — VARCHAR(255) — NOT NULL
- category — VARCHAR(255) — NOT NULL
- department — VARCHAR(255)
- views — INT
- crawled_at — DATETIME — NOT NULL
post_like
- user_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Primary key — NOT NULL
- liked_at — DATETIME — NOT NULL
post_view
- user_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Primary key — NOT NULL
- viewed_at — DATETIME — Primary key — NOT NULL
user
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(40) — NOT NULL
- status — VARCHAR(16) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- user_id — BIGINT — Foreign key → user_role.user_id — NOT NULL
- role — VARCHAR(32) — Foreign key → user_role.role — NOT NULL
user_role
- user_id — BIGINT — Primary key — NOT NULL
- role — VARCHAR(32) — Primary key — NOT NULL