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