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