123

Tables (11)

ADMIN_MENU

  • MENU_CODE — VARCHAR2(20)
  • MENU_NAME — VARCHAR2(50) — NOT NULL
  • MENU_URL — VARCHAR2(100)

ADMIN_SUB_MENU

  • SUB_MENU_CODE — VARCHAR2(20)
  • SUB_MENU_NAME — VARCHAR2(50) — NOT NULL
  • SUB_MENU_URL — VARCHAR2(100)
  • MENU_CODE — VARCHAR2(20) — NOT NULL

BUY_DETAIL

  • BUY_DETAIL_CODE — VARCHAR2(30)
  • ITEM_CODE — VARCHAR2(20)
  • BUY_CNT — NUMBER
  • DETAIL_BUY_PRICE — NUMBER
  • BUY_CODE — VARCHAR2(20)

ITEM_CATEGORY

  • CATE_CODE — VARCHAR2(50)
  • CATE_NAME — VARCHAR2(50) — NOT NULL
  • ORDER_NUM — NUMBER
  • IS_USE — VARCHAR2(1)

ITEM_IMG

  • IMG_CODE — VARCHAR2(50)
  • ORIGIN_FILE_NAME — VARCHAR2(100) — NOT NULL
  • ATTACHED_FILE_NAME — VARCHAR2(100) — NOT NULL
  • IS_MAIN — VARCHAR2(1)
  • ITEM_CODE — VARCHAR2(20) — NOT NULL

ORDER_STATUS

  • ORDER_NUM — NUMBER
  • STATUS_CODE — NUMBER
  • BUY_CODE — VARCHAR2(20)
  • MEM_ID — VARCHAR2(50)
  • UPDATE_DATE — DATE

SHOP_BUY

  • BUY_CODE — VARCHAR2(20)
  • MEM_ID — VARCHAR2(50)
  • BUY_PRICE — NUMBER — NOT NULL
  • BUY_DATE — DATE

SHOP_CART

  • CART_CODE — VARCHAR2(20)
  • ITEM_CODE — VARCHAR2(20)
  • MEM_ID — VARCHAR2(50)
  • REG_DATE — DATE
  • CART_CNT — NUMBER

SHOP_ITEM

  • ITEM_CODE — VARCHAR2(20)
  • CATE_CODE — VARCHAR2(50) — NOT NULL
  • ITEM_NAME — VARCHAR2(100) — NOT NULL
  • ITEM_PRICE — NUMBER — NOT NULL
  • ITEM_STOCK — NUMBER
  • ITEM_INTRO — VARCHAR2(200)
  • ITEM_STATUS — NUMBER

SHOP_MEMBER

  • MEM_ID — VARCHAR2(50)
  • MEM_PW — VARCHAR2(100) — NOT NULL — 회원PW
  • MEM_NAME — VARCHAR2(50) — NOT NULL
  • GENDER — VARCHAR2(1) — NOT NULL
  • MEM_TELL — VARCHAR2(100) — NOT NULL
  • MEM_ADDR — VARCHAR2(100)
  • ADDR_DETAIL — VARCHAR2(100)
  • MEM_ROLE — VARCHAR2(10) — NOT NULL
  • MEM_STATUS — NUMBER — NOT NULL
  • JOIN_DATE — DATE — NOT NULL

STATUS_INFO

  • STATUS_CODE — NUMBER
  • STATUS_NAME — VARCHAR2(50) — NOT NULL