livecommerce

Tables (8)

broadcast (3)

  • id (pk) — Primary key — NOT NULL
  • manager_id (fk) — Foreign key → manager.id — NOT NULL
  • title (Field)
  • description (Field2)
  • channel_id (Field3)
  • status (Field4)
  • reservation_start_at (Field5)
  • cover_url (Field6)

cart (5)

  • id (pk) — Primary key — NOT NULL
  • member_id (fk) — Foreign key → member.id — NOT NULL
  • sale_item_id (fk2) — Foreign key → sale_item.id — NOT NULL
  • quantity (Field)

delivery (7)

  • id (pk) — Primary key — NOT NULL
  • member_id (fk) — Foreign key → member.id — NOT NULL

manager (2)

  • id (pk) — Primary key — NOT NULL

member (1)

  • id (pk) — Primary key — NOT NULL

order (6)

  • id (pk) — Primary key — NOT NULL
  • member_id (fk) — Foreign key → member.id — NOT NULL
  • delivery_id (fk2) — Foreign key → delivery.id — NOT NULL
  • status (Field)

order_item (8)

  • id (pk) — Primary key — NOT NULL
  • order_id (fk) — Foreign key → order.id — NOT NULL
  • sale_item_id (fk2) — Foreign key → sale_item.id — NOT NULL
  • broadcast_id (Field)
  • quantity (Field2)

sale_item (4)

  • id (pk) — Primary key — NOT NULL
  • broadcast_id (fk) — Foreign key → broadcast.id — NOT NULL
  • name (Field)
  • description (Field2)
  • price (Field3)
  • img_url (Field4)