쓰레기 수거 서비스
테이블 (8)
address
- id — BIGINT
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- zip_code — VARCHAR(10) — NOT NULL
- address_line1 — VARCHAR(255) — NOT NULL
- address_line2 — VARCHAR(255)
- is_default — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
payment
- id — BIGINT
- request_id — BIGINT — 외래 키 → pickup_request.id — NOT NULL
- method — ENUM('KAKAO_PAY', 'TOSS_PAY', 'NAVER_PAY', 'PAYCO', 'CREDIT_CARD', 'POINT_ONLY') — NOT NULL
- point_used — INT — NOT NULL
- payment_price — INT — NOT NULL
- status — ENUM('REQUESTED', 'COMPLETED', 'CANCELED') — NOT NULL
- paid_at — DATETIME
pickup_request
- id — BIGINT
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- address_id — BIGINT — 외래 키 → address.id — NOT NULL
- total_price — INT — NOT NULL
- status — ENUM('REQUESTED', 'ACCEPTED', 'COMPLETED', 'CANCELED') — NOT NULL
- pickup_date — DATE — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
point_history
- id — BIGINT
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- payment_id — BIGINT — 외래 키 → payment.id
- status — ENUM('SAVED', 'USED', 'EXPIRED') — NOT NULL
- amount — INT — NOT NULL
- usable_point — INT
- expired_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
service_region
- id — BIGINT
- serviceable_range — GEOMETRY — NOT NULL
- code — ENUM('') — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
trash_item
- id — BIGINT
- request_id — BIGINT — 외래 키 → pickup_request.id — NOT NULL
- price — BIGINT — NOT NULL
- quantity — BIGINT — NOT NULL
- price_policy_id — BIGINT — 외래 키 → trash_price_policy.id — NOT NULL
- created_at — DATETIME
trash_price_policy
- id — BIGINT
- trash_type — ENUM('GENERAL', 'RECYCLABLE', 'FOOD') — NOT NULL
- sub_type — ENUM( 'BAG_5L', 'BAG_10L', 'BAG_20L', 'BAG_30L', 'BAG_50L', 'PLASTIC', 'GLASS', 'CAN', 'SEPARATION_SERVICE', 'FOOD_1_5L', 'FOOD_10L', 'FOOD_20L' ) — NOT NULL
- price — INT — NOT NULL
- effective_date — DATE — NOT NULL
- expired_date — DATE
- created_at — DATETIME
user
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — ENUM('CUSTOMER', 'COLLECTOR', 'ADMIN') — NOT NULL
- total_point — INT
- created_at — DATETIME
- updated_at — DATETIME