0630p2

Tables (11)

comments

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • parent_id — BIGINT
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

messages

  • id — BIGINT
  • sender_id — BIGINT — NOT NULL
  • receiver_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — DATETIME — NOT NULL

policies

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • summary — TEXT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • region_id — BIGINT — NOT NULL
  • support_amount — INT — NOT NULL
  • deadline — DATE
  • external_url — TEXT
  • created_at — DATETIME — NOT NULL

policy_alerts

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • policy_id — BIGINT — NOT NULL
  • is_enabled — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • UNIQUE(user_id, — policy_id)

policy_favorites

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • policy_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • UNIQUE(user_id, — policy_id)

posts

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • region_id — BIGINT — NOT NULL
  • tag — VARCHAR(50)
  • likes — INT — NOT NULL
  • views — INT — NOT NULL
  • is_notice — BOOLEAN — NOT NULL
  • is_mentor_only — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

recommendations

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • region_id — BIGINT — NOT NULL
  • score — INT — NOT NULL
  • reasons — TEXT
  • created_at — DATETIME — NOT NULL

regions

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • level — INT — NOT NULL
  • parent_id — BIGINT

reports

  • id — BIGINT
  • target_type — ENUM('POST','COMMENT') — NOT NULL
  • target_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • reason — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

surveys

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • housing — VARCHAR(10)
  • transport — VARCHAR(10)
  • other_answers — TEXT
  • created_at — DATETIME — NOT NULL

user_regions

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • region_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • UNIQUE(user_id, — region_id)