test

Tables (25)

cart

  • cartNum — NUMBER
  • userId — VARCHAR2(50) — NOT NULL
  • productNum — NUMBER — NOT NULL
  • stockNum — NUMBER — NOT NULL
  • qty — NUMBER — NOT NULL
  • reg_date — DATE
  • UNIQUE(userId, — stockNum)

deliveryCompany

  • num — NUMBER — Primary key — NOT NULL
  • deliveryName — VARCHAR2(255)
  • tel — VARCHAR2(50) — NOT NULL

destination

  • num — NUMBER — Primary key — NOT NULL
  • userId — VARCHAR2(50) — NOT NULL
  • recipientName — VARCHAR2(50) — NOT NULL
  • defaultDest — NUMBER(1)
  • tel — VARCHAR2(50) — NOT NULL
  • zip — VARCHAR2(7) — NOT NULL
  • addr1 — VARCHAR2(100) — NOT NULL
  • addr2 — VARCHAR2(100) — NOT NULL
  • destMemo — VARCHAR2(255)

detailStateInfo

  • stateNum — NUMBER — Primary key — NOT NULL
  • orderDetailNum — NUMBER — NOT NULL
  • memberIdx — NUMBER
  • detailState — NUMBER(3) — NOT NULL
  • stateMemo — VARCHAR2(4000)
  • detailStateDate — DATE

member

  • memberIdx — NUMBER — Primary key — NOT NULL
  • membership — NUMBER(5)

member1

  • memberIdx — NUMBER — Primary key — NOT NULL
  • userId — VARCHAR2(50) — NOT NULL
  • userName — VARCHAR2(50) — NOT NULL
  • userPwd — VARCHAR2(100) — NOT NULL
  • enabled — NUMBER(1)
  • register_date — DATE
  • modify_date — DATE
  • last_login — DATE
  • failure_cnt — NUMBER(2)

member2

  • userId — VARCHAR2(50) — Primary key — NOT NULL
  • birth — DATE
  • email — VARCHAR2(100)
  • tel — VARCHAR2(20)
  • zip — VARCHAR2(7)
  • addr1 — VARCHAR2(100)
  • addr2 — VARCHAR2(100)

optionDetail

  • detailNum — NUMBER — Primary key — NOT NULL
  • optionNum — NUMBER — NOT NULL
  • optionValue — VARCHAR2(500) — NOT NULL

orderDelivery

  • orderNum — VARCHAR2(255)
  • recipientName — VARCHAR2(50) — NOT NULL
  • tel — VARCHAR2(50) — NOT NULL
  • zip — VARCHAR2(7) — NOT NULL
  • addr1 — VARCHAR2(100) — NOT NULL
  • addr2 — VARCHAR2(100) — NOT NULL
  • destMemo — VARCHAR2(255)

orderDetail

  • orderDetailNum — NUMBER — Primary key — NOT NULL
  • orderNum — VARCHAR2(255) — NOT NULL
  • qty — NUMBER — NOT NULL
  • price — NUMBER — NOT NULL
  • salePrice — NUMBER — NOT NULL
  • productNum — NUMBER — NOT NULL
  • detailNum — NUMBER
  • detailNum2 — NUMBER
  • productMoney — NUMBER
  • savedMoney — NUMBER
  • userDelete — NUMBER(1)
  • detailState — NUMBER(3)

payCancel

  • orderNum — VARCHAR2(255) — Primary key — NOT NULL
  • cancelAmount — NUMBER — NOT NULL
  • cancelDate — DATE

payDetail

  • orderNum — VARCHAR2(255) — Primary key — NOT NULL
  • payMethod — VARCHAR2(255)
  • cardName — VARCHAR2(255)
  • authNumber — VARCHAR2(255)
  • authDate — DATE

product

  • productNum — NUMBER — Primary key — NOT NULL
  • categoryNum — NUMBER — NOT NULL
  • productName — VARCHAR2(1000) — NOT NULL
  • classify — NUMBER(3)
  • price — NUMBER — NOT NULL
  • discountRate — NUMBER(3) — NOT NULL
  • savedMoney — NUMBER — NOT NULL
  • delivery — NUMBER — NOT NULL
  • optionCount — NUMBER(3) — NOT NULL
  • content — CLOB
  • thumbnail — VARCHAR2(500) — NOT NULL
  • productShow — NUMBER(1)
  • reg_date — DATE
  • update_date — DATE

productCategory

  • categoryNum — NUMBER — Primary key — NOT NULL
  • categoryName — VARCHAR2(100) — NOT NULL
  • use — NUMBER(1)
  • displayNo — NUMBER(5)
  • parentNum — NUMBER

productFile

  • fileNum — NUMBER — Primary key — NOT NULL
  • productNum — NUMBER — NOT NULL
  • filename — VARCHAR2(500)

productOption

  • optionNum — NUMBER — Primary key — NOT NULL
  • optionName — VARCHAR2(500) — NOT NULL
  • productNum — NUMBER — NOT NULL
  • parentOption — NUMBER

productOrder

  • orderNum — VARCHAR2(255)
  • memberIdx — NUMBER — NOT NULL
  • orderDate — DATE
  • totalMoney — NUMBER — NOT NULL
  • usedSaved — NUMBER — NOT NULL
  • deliveryCharge — NUMBER — NOT NULL
  • payment — NUMBER — NOT NULL
  • cancelAmount — NUMBER
  • orderState — NUMBER(3)
  • orderStateDate — DATE
  • deliveryName — VARCHAR2(255)
  • invoiceNumber — VARCHAR2(255)

productQna

  • num — NUMBER — Primary key — NOT NULL
  • productNum — NUMBER — NOT NULL
  • memberIdx — NUMBER — NOT NULL
  • secret — NUMBER(1)
  • question — VARCHAR2(4000) — NOT NULL
  • answer — VARCHAR2(4000)
  • answerId — VARCHAR2(50)
  • showQuestion — NUMBER(1)
  • question_date — DATE
  • answer_date — DATE
  • locked — NUMBER(1)

productQnaFile

  • fileNum — NUMBER — Primary key — NOT NULL
  • num — NUMBER — NOT NULL
  • filename — VARCHAR2(500)

productReview

  • num — NUMBER — Primary key — NOT NULL
  • score — NUMBER(2,1) — NOT NULL
  • review — VARCHAR2(4000) — NOT NULL
  • answer — VARCHAR2(4000)
  • productNum — NUMBER — NOT NULL
  • review_date — DATE
  • answer_date — DATE
  • memberIdx — NUMBER — NOT NULL
  • showReview — NUMBER(1)
  • locked — NUMBER(1)

productReviewFile

  • fileNum — NUMBER — Primary key — NOT NULL
  • num — NUMBER — NOT NULL
  • filename — VARCHAR2(500)

productStock

  • stockNum — NUMBER — Primary key — NOT NULL
  • productNum — NUMBER — NOT NULL
  • detailNum — NUMBER
  • detailNum2 — NUMBER
  • totalStock — NUMBER

specials

  • specialNum — NUMBER — Primary key — NOT NULL
  • classify — NUMBER(3) — NOT NULL
  • subject — VARCHAR2(255) — NOT NULL
  • content — CLOB
  • imageFilename — VARCHAR2(255)
  • startDate — DATE
  • endDate — DATE
  • showSpecial — NUMBER(1)
  • reg_date — DATE

specialsDetail

  • detailNum — NUMBER — Primary key — NOT NULL
  • specialNum — NUMBER — NOT NULL
  • productNum — NUMBER — NOT NULL
  • displayOrder — NUMBER(5) — NOT NULL
  • showDetail — NUMBER(1)

userPoint

  • pointNum — NUMBER
  • userId — VARCHAR2(50) — NOT NULL
  • reg_date — DATE
  • orderNum — VARCHAR2(255)
  • base_date — DATE
  • classify — NUMBER(2) — NOT NULL
  • point — NUMBER — NOT NULL
  • balance — NUMBER — NOT NULL
  • memo — VARCHAR2(1000)