final
Tables (9)
expiration
- category_no — INT(10) — NOT NULL
- category — varchar(100)
- expire_date — DATE
food_list
- food_no — INT(10) — NOT NULL
- refrig_no — INT(10) — Foreign key → refrig_regist.refrig_no — NOT NULL
- category_no — INT(10) — Foreign key → expiration.category_no — NOT NULL
- name — varchar(100)
- status — varchar(100)
- stock — int
- price — int
- regist_date — datetime
payment_list
- tid — INT(10) — NOT NULL
- user_id — varchar(100) — Foreign key → user.user_id — NOT NULL
- product_no — int(10) — Foreign key → product.product_no — NOT NULL
- quantity — int(10)
- total_amount — int(10)
product
- product_no — INT(10) — NOT NULL
- category_no — INT(10) — Foreign key → expiration.category_no — NOT NULL
- product_name — varchar(50) — NOT NULL
- product_price — int(10)
- stock — int
- description — varchar(100)
- img_url — varchar(100)
- regist_date — datetime
- avg_rate — int(10)
- detail_imgs — varchar(500)
product_comment
- pcomment_no — INT(10) — NOT NULL
- user_id — varchar(100) — Foreign key → user.user_id — NOT NULL
- product_no — INT(10) — Foreign key → product.product_no — NOT NULL
- user_rate — int(10)
- comment_detail — varchar(500)
- regist_date — datetime — NOT NULL
refrig_regist
- refrig_no — INT(10) — NOT NULL
- user_id — varchar(100) — Foreign key → user.user_id — NOT NULL
regist_share
- refrig_no — INT(10) — Primary key — Foreign key → refrig_regist.refrig_no — NOT NULL
- shared_id — varchar(100) — Foreign key → user.user_id — NOT NULL
- accept — int
shopping_list
- shoplist_no — INT(10) — NOT NULL
- user_id — varchar(100) — Foreign key → user.user_id — NOT NULL
- product_no — int(10) — Foreign key → product.product_no — NOT NULL
user
- user_id — varchar(100) — NOT NULL
- password — varchar(100) — NOT NULL
- nick_name — varchar(100) — NOT NULL
- phone — varchar(20)
- addr1 — varchar(50)
- addr1 — varchar(50)
- addr1 — varchar(50)