0630p
Tables (13)
comments
- id — BIGINT
- post_id — BIGINT
- user_id — BIGINT
- parent_id — BIGINT
- content — TEXT
- created_at — DATETIME
login_logs
- id — BIGINT
- user_id — BIGINT
- ip_address — VARCHAR(45)
- user_agent — TEXT
- login_at — DATETIME
messages
- id — BIGINT
- sender_id — BIGINT
- receiver_id — BIGINT
- content — TEXT
- sent_at — DATETIME
policies
- id — BIGINT
- title — VARCHAR(200)
- summary — TEXT
- category — VARCHAR(50)
- region_id — BIGINT
- support_amount — INT
- deadline — DATE
- external_url — TEXT
- created_at — DATETIME
policy_alerts
- id — BIGINT
- user_id — BIGINT
- policy_id — BIGINT
- is_enabled — BOOLEAN
policy_favorites
- id — BIGINT
- user_id — BIGINT
- policy_id — BIGINT
- created_at — DATETIME
posts
- id — BIGINT
- user_id — BIGINT
- title — VARCHAR(200)
- content — TEXT
- region_id — BIGINT
- tag — VARCHAR(50)
- likes — INT
- views — INT
- is_notice — BOOLEAN
- is_mentor_only — BOOLEAN
- created_at — DATETIME
recommendations
- id — BIGINT
- user_id — BIGINT
- region_id — BIGINT
- score — INT
- reasons — TEXT
- created_at — DATETIME
regions
- id — BIGINT
- name — VARCHAR(100)
- level — INT
- parent_id — BIGINT
reports
- id — BIGINT
- target_type — ENUM('POST', 'COMMENT')
- target_id — BIGINT
- user_id — BIGINT
- reason — TEXT
- created_at — DATETIME
surveys
- id — BIGINT
- user_id — BIGINT
- housing — VARCHAR(10)
- transport — VARCHAR(10)
- other_answers — TEXT
- created_at — DATETIME
user_regions
- id — BIGINT
- user_id — BIGINT
- region_id — BIGINT
- created_at — DATETIME
users
- id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- age_group — VARCHAR(20)
- role — ENUM('USER', 'MENTOR', 'ADMIN')
- created_at — DATETIME
- is_social — BOOLEAN