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)