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)