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