MASK SHOPPING2
Tables (12)
ADMIN_ORDER
- AORDER_NUM — NUMBER
- ORDER_NUM — NUMBER — Foreign key → MK_ORDER.ORDER_NUM
- MEM_NUM — NUMBER — Foreign key → MEMBER.MEM_NUM
- AORDER_STATE — VARCHAR2(100 BYTE)
- AORDER_TRACKING — VARCHAR2(30 BYTE)
- AORDER_RTRACKING — VARCHAR2(30 BYTE)
- AORDER_TRA_COM — VARCHAR2(30 BYTE)
- ORDER_REPORT_COMMENT — VARCHAR2(300 BYTE)
- AS_SDATE — DATE
- AS_EDATE — DATE
BANNERS
- BANNERS_NUM — NUMBER
- BANNERS_ORG — VARCHAR2(260 BYTE)
- BANNERS_NAME — VARCHAR2(40 BYTE)
- BANNERS_SIZE — NUMBER(8,0)
- BANNERS_LINK — VARCHAR2(30 BYTE)
- BANNERS_CK — VARCHAR2(2 BYTE)
BOARD
- BOARD_NUM — NUMBER
- BOARD_TYPE — VARCHAR2(4 BYTE)
- BOARD_TITLE — VARCHAR2(40 BYTE)
- MEM_ID — VARCHAR2(20 BYTE) — Foreign key → MEMBER.MEM_ID
- BOARD_CONTENT — VARCHAR2(400 BYTE)
- BOARD_COUNT — NUMBER
- BOARD_DATE — DATE
- BOARD_DEL_GB — VARCHAR2(2 BYTE)
- BOARD_UP — NUMBER
- BOARD_COM — NUMBER
- BOARD_STAR — NUMBER
- GOODS_NUM — NUMBER — Foreign key → GOODS.GOODS_NUM
- BOARD_SECRET — VARCHAR2(2 BYTE)
- BOARD_IMAGE — VARCHAR2(200 BYTE)
FILES
- FILE_NUM — NUMBER
- BOARD_TYPE — VARCHAR2(4 BYTE) — Foreign key → BOARD.BOARD_TYPE
- BOARD_NUM — NUMBER — Foreign key → BOARD.BOARD_NUM
- FILE_ORG — VARCHAR2(260 BYTE)
- FILE_STD — VARCHAR2(40 BYTE)
- FILE_SIZE — NUMBER(8,0)
- FILE_DATE — DATE
- FILE_DEL — VARCHAR2(2 BYTE)
GOODS
- GOODS_NUM — NUMBER(5,0)
- GOODS_NAME — VARCHAR2(40 BYTE)
- GOODS_CONTENT — VARCHAR2(400 BYTE)
- GOODS_PRICE — VARCHAR2(40 BYTE)
- GOODS_CPRICE — VARCHAR2(40 BYTE)
- GOODS_DATE — DATE
- GOODS_CATEGORY1 — VARCHAR2(20 BYTE)
- GOODS_CATEGORY2 — VARCHAR2(20 BYTE)
- GOODS_COUNT — NUMBER
GOODS_ATTRIBUTE
- GOODS_ATT_NO — NUMBER
- GOODS_NUM — NUMBER(5,0) — Foreign key → GOODS.GOODS_NUM
- GOODS_STOCK — NUMBER(30,0)
- GOODS_STATUS — NUMBER(20,0)
GOODS_BASKET
- MEM_NUM — NUMBER — Foreign key → MEMBER.MEM_NUM
- GOODS_NUM — NUMBER(5,0) — Foreign key → GOODS.GOODS_NUM
- GOODS_AMOUNT — NUMBER
GOODS_IMAGE
- GOODS_IMAGE_NUM — NUMBER
- GOODS_NUM — NUMBER — Foreign key → GOODS.GOODS_NUM
- GOODS_IMAGE_ORG — VARCHAR2(30 BYTE)
- GOODS_IMAGE_STD — VARCHAR2(30 BYTE)
MEMBER
- MEM_NUM — NUMBER
- MEM_ADMIN — VARCHAR2(2 BYTE)
- MEM_ID — VARCHAR2(20 BYTE)
- MEM_PW — VARCHAR2(20 BYTE)
- MEM_NAME — VARCHAR2(20 BYTE)
- MEM_GEN — VARCHAR2(2 BYTE)
- MEM_EMAIL — VARCHAR2(50 BYTE)
- MEM_PHONE — VARCHAR2(11 BYTE)
- MEM_ZIPCODE — VARCHAR2(13 BYTE)
- MEM_ADDRESS1 — VARCHAR2(70 BYTE)
- MEM_ADDRESS2 — VARCHAR2(70 BYTE)
- MEM_JOINDATE — DATE
- MEM_EMAILCK — VARCHAR2(2 BYTE)
- MEM_PHONECK — VARCHAR2(2 BYTE)
- MEM_DEL_GB — VARCHAR2(2 BYTE)
- MEM_SNSCK — VARCHAR2(2 BYTE)
MK_COMMENT
- COMMENT_NUM — NUMBER
- COMMENT_REF — NUMBER
- COMMENT_REFNUM — NUMBER
- COMMENT_LEV — NUMBER
- BOARD_NUM — NUMBER — Foreign key → BOARD.BOARD_NUM
- MEM_ID — VARCHAR2(20 BYTE) — Foreign key → MEMBER.MEM_ID
- COMMENT_CONTENT — VARCHAR2(400 BYTE)
- COMMENT_DATE — DATE
- COMMENT_DEL_GB — VARCHAR2(2 BYTE)
MK_ORDER
- ORDER_NUM — NUMBER
- MEM_NUM — NUMBER — Foreign key → MEMBER.MEM_NUM
- ORDER_NAME — VARCHAR2(20 BYTE)
- ORDER_USER_NAME — VARCHAR2(20 BYTE)
- ORDER_PHONE1 — VARCHAR2(11 BYTE)
- ORDER_PHONE2 — VARCHAR2(11 BYTE)
- ORDER_DATE — DATE
- ORDER_PRICE — NUMBER
- ORDER_DCOST — NUMBER
- ORDER_TCOST — NUMBER
- ORDER_DZIPCODE — VARCHAR2(6 BYTE)
- ORDER_DADD1 — VARCHAR2(30 BYTE)
- ORDER_DADD2 — VARCHAR2(30 BYTE)
- ORDER_DMEMO — VARCHAR2(100 BYTE)
- ORDER_PAY — VARCHAR2(20 BYTE)
- ORDER_PAY_NAME — VARCHAR2(20 BYTE)
- ORDER_PAY_RBANK — VARCHAR2(20 BYTE)
- ORDER_PAY_RACCOUNT — VARCHAR2(20 BYTE)
- ORDER_PAY_CASHRE — VARCHAR2(30 BYTE)
ORDER_DETAIL
- ORDER_DETAIL_NUM — NUMBER
- ORDER_NUM — NUMBER — Foreign key → MK_ORDER.ORDER_NUM
- GOODS_NUM — NUMBER — Foreign key → GOODS.GOODS_NUM
- GOODS_AMOUNT — NUMBER
- ORDER_DETAIL_DATE — DATE
- ORDER_DETAIL_RECEIVER — VARCHAR2(20 BYTE)
- ORDER_DETAIL_RECIVER — VARCHAR2(20 BYTE)
- ORDER_DETAIL_PNUM — VARCHAR2(20 BYTE)
- ORDER_DETAIL_ADDRESS — VARCHAR2(20 BYTE)
- ORDER_DETAIL_DADDRESS — VARCHAR2(30 BYTE)
- ORDER_DETAIL_DMEMO — VARCHAR2(100 BYTE)
- ORDER_DETAIL_TCOST — NUMBER