ERD
Tables (3)
Customer (Untitled)
- Key — Primary key — NOT NULL
- customer_id (PK)
- store_name (Field2)
- customer_name (Field3)
- phone_number (Field4)
Fish (Untitled2)
- fish_id (Key) — Primary key — NOT NULL
- fish_name (Field)
- fish_price (Field2)
Sales (Untitled3)
- sale_id (PK) — Primary key — NOT NULL
- customer_id (FK) — Primary key — NOT NULL
- fish_id (Key) — Primary key — NOT NULL
- order_date (Field)
- time (Field2)
- weight_kg (Field3)
- total_price (Field4)
- order_status (Field5)