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