부름

테이블 (10)

auth_social_accounts

  • social_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

community_posts

  • post_id — BIGINT — 기본 키 — NOT NULL
  • author_user_id — BIGINT — NOT NULL
  • dong_id — BIGINT — NOT NULL
  • title — VARCHAR(120) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(120) — NOT NULL
  • body — VARCHAR(500)
  • link_url — VARCHAR(500)
  • is_read — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

regions_dong

  • dong_id — BIGINT — 기본 키 — NOT NULL
  • sigungu — VARCHAR(50) — NOT NULL
  • dong_name — VARCHAR(50) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • sort_order — INT — NOT NULL

reviews

  • review_id — BIGINT — 기본 키 — NOT NULL
  • task_id — BIGINT — NOT NULL
  • requester_id — BIGINT — NOT NULL
  • rider_id — BIGINT — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL

rider_profiles

  • rider_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • approval_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

task_categories

  • category_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • sort_order — INT — NOT NULL

tasks

  • task_id — BIGINT — 기본 키 — NOT NULL
  • requester_id — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • dong_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • price_amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_neighborhoods

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • dong_id — BIGINT — NOT NULL
  • slot — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255)
  • phone — VARCHAR(30)
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • last_login_at — DATETIME