Semul ERD

Tables (8)

Address

  • id — string — Primary key — NOT NULL
  • roadAddr — string
  • detailAddr — string
  • jibun — string

Laundry

  • id — string — Primary key — NOT NULL
  • user_id — string — Foreign key → User.id — NOT NULL
  • address_id — string — Foreign key → Address.id — NOT NULL
  • name — string
  • bizNo — string
  • phoneNumber — string

Order

  • id — string — Primary key — NOT NULL
  • user_id — string — Foreign key → User.id — NOT NULL
  • laundry_id — string — Foreign key → Laundry.id — NOT NULL
  • pickUpMethod — string
  • address — json
  • status — string
  • notice — string
  • deniedReason — string
  • pickUpDateTime — datetime
  • wishLaundryDateTime — datetime
  • paymentDateTime — datetime
  • completeDateTime — datetime

Order_Product

  • id — Primary key — NOT NULL
  • order_id — string — Foreign key → Order.id — NOT NULL
  • productName — string
  • price — int
  • quantity — int

Product

  • id — string — Primary key — NOT NULL
  • name — string
  • price — int
  • category — string

Review

  • id — string — Primary key — NOT NULL
  • laundry_id — string — Foreign key → Laundry.id — NOT NULL
  • order_id — string — Foreign key → Order.id — NOT NULL
  • rate — float
  • reviewText — string

User

  • id — string — Primary key — NOT NULL
  • address_id — string — Foreign key → Address.id — NOT NULL
  • email — string
  • password — string
  • name — string
  • phoneNumber — string
  • bizType — string

Wallet

  • id — string — Primary key — NOT NULL
  • user_id — string — Foreign key → User.id — NOT NULL
  • money — int
  • chargeMethod — string