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')