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