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