NHCafe

Tables (5)

t_order (Untitled4)

  • o_id (Key) — INT — Primary key — NOT NULL
  • user_id (Field) — VARCHAR(100)
  • order_time (Field2) — TIMESTAMP
  • completed (Field3) — CHAR(1)

t_order_detail (Untitled5)

  • d_id (Key) — INT — Primary key — NOT NULL
  • order_id (Field) — INT
  • product_id (Field2) — INT
  • queantity (Field3)

t_product (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • type (Field2) — VARCHAR
  • price (Field3) — INT
  • img (Field4) — VARCHAR
  • product_desc (Field5) — VARCHAR

t_stamp (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (Field) — VARCHAR(30)
  • order_id (Field2) — INT
  • Field3 — INT

t_user (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • number (Field2) — VARCHAR(30)
  • stamp (Field) — INT