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)