table_1

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) — Primary key — 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) — Primary key — 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) — Primary key — 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) — Primary key — 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) — Primary key — 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) — Primary key — 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) — Primary key — NOT NULL
  • ORDER_DETAIL_ID — number(10,0) — Foreign key → USERORDER_DETAIL.ORDER_DETAIL_ID — NOT NULL
  • REFUND_REASON — varchar2(100)
  • REFUND_STATUS — number(2,0)
  • REFUND_DATE — date
  • REFUND_TOTAL — number(10)

USERS

  • USER_ID — varchar2(50) — Primary key — 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) — Primary key — 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)