GcCoffee
Tables (3)
order_item (Untitled3)
- seq (Key) — BIGINT — Primary key — NOT NULL
- product_id (productId2) — BIGINT — Foreign key → product.product_id — NOT NULL
- order_id (orderId2) — BINARY(16) — Foreign key → orders.order_id — NOT NULL
- category (Field) — VARCHAR(50) — NOT NULL
- price (Field2) — BIGINT — NOT NULL
- quantity (Field3) — INT — NOT NULL
- created_at (createdAt) — datetime(6)
orders (Untitled2)
- order_id (orderId) — BINARY(16) — Primary key — NOT NULL
- email (Field) — VARCHAR(50) — NOT NULL
- address (Field2) — VARCHAR(200) — NOT NULL
- postcode (Field3) — VARCHAR(200) — NOT NULL
- order_status (orderStatus) — VARCHAR(50) — NOT NULL
- created_at (createdAt) — datetime(6) — NOT NULL
product (Untitled)
- product_id (productId) — BIGINT — Primary key — NOT NULL
- product_status (productStatus) — VARCHAR(50) — NOT NULL
- stock (Field) — BIGINT — NOT NULL
- product_name (productName) — VARCHAR(20) — NOT NULL
- category (Field2) — VARCHAR(50) — NOT NULL
- price (Field3) — BIGINT — NOT NULL
- created_at (createdAt) — datetime(6)
- updated_at (updatedAt) — datetime(6) — NOT NULL
- discriptioin (Field4) — VARCHAR(255)