TEST
Tables (12)
CART
- PRODUCT_ID — number(3,0) — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- USER_ID — varchar2(50) — Foreign key → USERS.USER_ID — NOT NULL
- CART_ID — number(4,0)
- CART_PRODUCT_QTY — number(7,0)
CENTER_QNA
- CENTER_QNA_ID — number(5,0) — NOT NULL
- USER_ID — varchar2(50) — Foreign key → USERS.USER_ID — NOT NULL
- CENTER_QNA_CONTENT — varchar2(500)
- CENTER_QNA_TITLE — varchar2(100)
- CENTER_CNA_DATE — date
CENTER_REPLY
- CENTER_REPLY_ID — number(5,0) — NOT NULL
- CENTER_QNA_ID — number(5,0) — Foreign key → CENTER_QNA.CENTER_QNA_ID — NOT NULL
- RIPLY_CONTENT — varchar2(500)
- CENTER_REPLY_DATE — date
INVEN
- PRODUCT_ID — number(3,0) — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- INVEN_IN — number(5,0)
- INVEN_OUT — number(5,0)
- INVEN_STOCK — number(5,0)
PAYMENT
- BUYER_ADDR — varchar2(500)
- BUYER_NAME — varchar2(50)
- BUYER_POSTCODE — number(5,0)
- BUYER_TEL — varchar2(20)
- IAMPORT_IMP_UID — varchar2(50)
- ALL_SUM — number(10,0)
PRODUCT
- PRODUCT_ID — number(3,0) — NOT NULL
- CATEGORY_CODE — number(2,0)
- PRODUCT_NAME — varchar2(50)
- PRODUCT_PRICE — number(10,0)
- PRODUCT_STOCK — number(5,0)
- PRODUCT_INFO — varchar2(100)
- PRODUCT_DISCOUNT — number(10,4)
- PRODUCT_STATE — number(2,0)
- PRODUCT_PIC — varchar2(100)
PRODUCT_QNA
- QNA_ID — number(5,0) — NOT NULL
- USER_ID — varchar2(50) — Foreign key → USERS.USER_ID — NOT NULL
- PRODUCT_ID — number(3,0) — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- QNA_CONTENT — varchar2(500)
- Q_OR_A — number(2,0)
- QNA_GROUP_NUMBER — number(5,0)
- QNA_GROUP — number(5,0)
- PRODUCT_QNA_DATE — date
- PRODUCT_QNA_STATE — number(2,0)
REVIEW
- REVIEW_ID — number(2,0) — NOT NULL
- ORDER_DETAIL_ID — number(10,0) — Foreign key → USERORDER_DETAIL.ORDER_DETAIL_ID — NOT NULL
- REVIEW_CONTENT — varchar2(200)
- REVIEW_GRADE — number(2,0)
USERORDER_DETAIL
- ORDER_DETAIL_ID — number(10,0) — NOT NULL
- ORDER_ID — varchar2(100) — Foreign key → USER_ORDER.ORDER_ID — NOT NULL
- PRODUCT_ID — number(3,0) — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
- USER_ORDER_CNT — number(2,0)
- USER_ID — varchar2(50)
USERORDER_REFUND
- REFUND_ID — number(5,0) — NOT NULL
- ORDER_DETAIL_ID — number(10,0) — NOT NULL
- REFUND_REASON — varchar2(100)
- REFUND_STATUS — number(2,0)
- REFUND_DATE — date
- REFUND_TOTAL — number(10)
USERS
- USER_ID — varchar2(50) — NOT NULL
- USER_PW — varchar2(50)
- USER_NAME — varchar2(50)
- USER_NICKNAME — varchar2(50)
- USER_EMAIL — varchar2(150)
- USER_GRADE — number(2,0)
- USER_POINT — number(10,0)
- USER_ADDR — varchar2(150)
- USER_ADDR_D — varchar2(200)
- USER_ZIPCODE — varchar2(50)
- USER_STATE — number(2,0)
- USER_PHONE — varchar2(50)
USER_ORDER
- ORDER_ID — varchar2(100) — NOT NULL
- USER_ID — varchar2(50) — Foreign key → USERS.USER_ID — NOT NULL
- ORDER_DATE — date
- ORDER_ADDR — varchar2(100)
- ORDER_ADDR_D — varchar2(200)
- ORDER_ZIPCODE — varchar2(50)
- ORDER_RECEIVER — varchar2(50)
- ORDER_PHONE — varchar2(20)
- ORDER_TOTAL — number(10,0)
- USER_STATUS — number(2,0)