쓰레기 수거 서비스

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