gc-coffee

Tables (4)

Order-items (Untitled2)

  • seq (Key) — bigint — Primary key — NOT NULL
  • product_id (Key4) — UUID — Foreign key → Products.Id — NOT NULL
  • order_id (Key5) — UUID — Foreign key → Orders.Id — NOT NULL
  • price (Field4) — long
  • quentity (Field5) — unsinged int
  • create_at (Field) — datetime

Orders (Untitled3)

  • Id (Key) — UUID — Primary key — NOT NULL
  • email (Field) — varchar
  • address (Field2) — varchar
  • order_status (Field3) — varchar
  • create_at (Field4) — datetime
  • update_at (Field5) — datetime

Product_category (Untitled4)

  • code (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar

Products (Untitled)

  • Id (Key) — UUID — Primary key — NOT NULL
  • code (Key2) — int — Foreign key → Product_category.code — NOT NULL
  • name (Field) — varchar
  • price (Field2) — long
  • total_amount (Field3) — unsigend int
  • description (Field6) — varchar