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)