부름
테이블 (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