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