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)