123
Tables (7)
CustomProduct (예약상품)
- id — pk — Primary key — NOT NULL
- shop_id (가게id) — fk — Foreign key → Shop.id — NOT NULL
- id (id2) — Foreign key → Shop.owner_id — NOT NULL
- Field
Order (주문내역)
- id — pk — Primary key — NOT NULL
- id (id2) — pk — Foreign key → User.id — NOT NULL
- Field
OrderProduct (주문상품)
- id (Key) — pk — Primary key — NOT NULL
- order_id (주문id) — fk — Foreign key → Order.id — NOT NULL
- id (id2) — pk — Foreign key → Order.id — NOT NULL
- product_id (주문상품id)
Owner (비지니스 계정)
- id — Primary key — NOT NULL
Product (일반상품)
- id — pk — Primary key — NOT NULL
- shop_id (가게id) — fk — Foreign key → Shop.id — NOT NULL
- id (id2) — Foreign key → Shop.owner_id — NOT NULL
- Field
Shop (가게)
- id — pk — Primary key — NOT NULL
- owner_id (사장 id) — fk — Foreign key → Owner.id — NOT NULL
- Field
- Field2
User (사용자)
- id — pk — Primary key — NOT NULL
- Field