test
Tables (6)
article
- article_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → user.user_id
- local — VARCHAR(10) — 지역별
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
comment
- comment_id — BIGINT — Primary key
- article_id — BIGINT — Foreign key → article.article_id
- user_id — BIGINT — Foreign key → article.user_id
- content — TEXT — NOT NULL
- created_at — DATETIME
notification
- id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → user.user_id
- local — VARCHAR(10) — 지역
- type — ENUM — NOT NULL — notice,event
- title — VARCHAR(200) — NOT NULL
- img — VARCHAR(100)
- content — TEXT
- event_date — DATE
- created_by — BIGINT
policy
- policy_id — BIGINT — Primary key
- local — VARCHAR(10) — 지역
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- category — VARCHAR(100)
- link — VARCHAR(255)
report
- report_id — BIGINT — Primary key
- article_id — BIGINT — Foreign key → article.article_id
- reason — TEXT
- created_at — DATETIME
- status (statusb) — Boolean — 신고 처리 상태
user
- user_id — BIGINT — Primary key
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- local — VARCHAR(10) — 지역
- role — ENUM — user, admin, head
- nickname — VARCHAR(50)
- font_size — VARCHAR(10)
- theme — ENUM('light', 'dark')