book store
Tables (5)
answer_item_category
- CATE_CODE — int(11) — Primary key — NOT NULL
- CATE_NAME — varchar(50) — NOT NULL
answer_item_img
- IMG_CODE — int(11) — Primary key — NOT NULL
- ITEM_CODE — int(11) — Foreign key → answer_shop_item.ITEM_CODE — NOT NULL
- CATE_CODE (CATE_CODE2) — int(11) — Foreign key → answer_shop_item.CATE_CODE — NOT NULL
- ORIGIN_FILE_NAME — varchar(100) — NOT NULL
- ATTACHED_FILE_NAME — varchar(100) — NOT NULL
- IS_MAIN — varchar(5) — NOT NULL
answer_shop_cart
- CART_CODE — int(11) — Primary key — NOT NULL
- MEM_ID — varchar(50) — Foreign key → answer_shop_member.MEM_ID — NOT NULL
- ITEM_CODE — int(11) — Foreign key → answer_shop_item.ITEM_CODE — NOT NULL
- CART_CNT — int(11) — NOT NULL
- CART_DATE — datetime
answer_shop_item
- ITEM_CODE — int(11) — Primary key — NOT NULL
- CATE_CODE — int(11) — Foreign key → answer_item_category.CATE_CODE — NOT NULL
- ITEM_NAME — varchar(50) — NOT NULL
- ITEM_PRICE — int(11) — NOT NULL
- ITEM_INTRO — varchar(100)
- ITEM_STOCK — int(11)
- ITEM_STATUS — varchar(10)
answer_shop_member
- MEM_ID — varchar(50) — Primary key — NOT NULL
- MEM_PW — varchar(100) — NOT NULL
- MEM_NAME — varchar(50) — NOT NULL
- MEM_TEL — varchar(30)
- POST — varchar(10)
- MEM_ADDR — varchar(50)
- ADDR_DETAIL — varchar(100)
- MEM_EMAIL — varchar(100)
- MEM_ROLE — varchar(30)