cafeWeb

Tables (11)

Untitled (User)

  • Key (user_id) — int(8) — Primary key — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field (date_created) — datetime — NOT NULL
  • Field (date_expired) — datetime
  • Field (authority) — boolean — NOT NULL

Untitled (Product)

  • Key (product_id) — int(5) — Primary key — NOT NULL — auto increment
  • Field (name) — varchar(10) — NOT NULL
  • Field (avail) — boolean — NOT NULL
  • Field (price) — int(5) — NOT NULL
  • Field (takingtime) — time
  • Key (category_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Order)

  • Key (order_id) — bigint(20) — Primary key — NOT NULL — auto increment
  • Field (begin) — time — NOT NULL
  • Field (end) — time
  • Key (user_id) — int(8) — Foreign key → Untitled.Key — NOT NULL

Untitled (OrderDetail)

  • Key (num) — bigint(20) — Primary key — NOT NULL — auto increment
  • Field (whip) — boolean — NOT NULL
  • Field (shot) — boolean — NOT NULL
  • Field (quantity) — int(5) — NOT NULL
  • Field (price) — bigint(20) — NOT NULL
  • Key (order_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — int(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (Category)

  • Key (category_id) — int — Primary key — NOT NULL — auto increment
  • Field (name) — varchar(10) — NOT NULL

Untitled (type)

  • Key (id) — int — Primary key — NOT NULL — auto increment
  • Field2 (name) — varchar(10) — NOT NULL

Untitled (option)

  • Key (id) — int — Primary key — NOT NULL — auto increment
  • Field (name) — varchar(10) — NOT NULL

Untitled (producttype)

  • Key (id) — int — Primary key — NOT NULL — auto increment
  • Key (productId) — int(5) — Foreign key → Untitled.Key — NOT NULL — auto increment
  • Key (typeId) — int — Foreign key → Untitled.Key — NOT NULL — auto increment

Untitled (productoption)

  • Key (id) — int — Primary key — NOT NULL — auto increment
  • Key (productId) — int(5) — Foreign key → Untitled.Key — NOT NULL — auto increment
  • Key (optionId) — int — Foreign key → Untitled.Key — NOT NULL — auto increment

Untitled (detailtype)

  • Key (id) — int — Primary key — NOT NULL — auto increment
  • Key (detailId) — bigint(20) — Foreign key → Untitled.Key — NOT NULL — auto increment
  • Key (typeId) — int — Foreign key → Untitled.Key — NOT NULL — auto increment

Untitled (detailoption)

  • Key (id) — int — Primary key — NOT NULL — auto increment
  • Key (detailId) — bigint(20) — Foreign key → Untitled.Key — NOT NULL — auto increment
  • Key (optionId) — int — Foreign key → Untitled.Key — NOT NULL — auto increment