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)