Cafe
Tables (7)
account
- account_id — varchar(30) — Primary key — NOT NULL
- account_name — varchar(45) — NOT NULL
- phone_number — varchar(45) — NOT NULL
- parttime — int(11) — NOT NULL
- money — int(11) — NOT NULL
- total_money — int(11) — NOT NULL
- chain_id — int(11) — Foreign key → chain.chain_id — NOT NULL
cart
- cartid — int(11) — Primary key — NOT NULL
- user_id (user_id2) — varchar(20) — Foreign key → user.user_id — NOT NULL
- product_num (product_num2) — int(11) — Foreign key → product.product_num — NOT NULL
- chain_id (chain_id2) — int(11) — Foreign key → chain.chain_id — NOT NULL
- user_id — varchar(20) — NOT NULL
- product_num — int(11) — NOT NULL
category
- category_num — int(11) — Primary key — NOT NULL
- category_name — varchar(45) — NOT NULL
chain
- chain_id — int(11) — Primary key — NOT NULL
- chain_name — varchar(45) — NOT NULL
- chain_phone — varchar(45) — NOT NULL
- chain_addr — varchar(45) — NOT NULL
product
- product_num — int(11) — Primary key — NOT NULL
- category_num — int(11) — NOT NULL
- product_price — int(11) — NOT NULL
- product_name — varchar(45) — NOT NULL
- description — varchar(300) — NOT NULL
- img_path — varchar(45)
- category_num (category_num2) — int(11) — Foreign key → category.category_num — NOT NULL
sale
- sale_num — int(11) — Primary key — NOT NULL
- product_num — int(11) — Primary key — NOT NULL
- user_id — varchar(30) — Primary key — NOT NULL
- chain_id — int(11) — Foreign key → chain.chain_id — NOT NULL
- sale_date — varchar(45) — NOT NULL
- number — int(11) — NOT NULL
- total — int(11) — NOT NULL
- calc — tinyint(4) — NOT NULL
- user_id (user_id2) — varchar(20) — Foreign key → user.user_id — NOT NULL
user
- user_id — varchar(20) — Primary key — NOT NULL
- user_pw — varchar(45) — NOT NULL
- user_gender — tinyint(4) — NOT NULL
- user_name — varchar(30) — NOT NULL
- adminChecked — tinyint(4) — NOT NULL
- point — int(11) — NOT NULL