test

Tables (18)

ANSWER

  • ANSWER_ID — NUMBER — NOT NULL
  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • PRODUCT_ID — INT — NOT NULL
  • ANSWER_CONTENT — VARCHAR2(500) — NOT NULL
  • ANSWER_DATE_CREATED — TIMESTAMP — NOT NULL
  • INQUIRY_ID — NUMBER

BASKET

  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • PRODUCT_ID — INT — NOT NULL
  • PRODUCT_NUM — NUMBER — NOT NULL

COUPON

  • COUPON_ID — NUMBER — NOT NULL
  • COUPON_NAME — VARCHAR2(50)
  • DISCOUNT — NUMBER — NOT NULL
  • DATE_CREATED — TIMESTAMP — NOT NULL
  • PUBLISHING — NUMBER

COUPON_POCKET

  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • COUPON_ID — NUMBER — NOT NULL
  • IS_USED — NUMBER — NOT NULL
  • EXPIRATION_DATE — TIMESTAMP — NOT NULL

CopyOfLIKES

  • MESSAGE_ID — NUMBER — NOT NULL
  • TYPE — VARCHAR2(20)
  • TITLE — VARCHAR2(60) — NOT NULL
  • CONTENT — VARCHAR2(300) — NOT NULL
  • WRITER_ID — VARCHAR2(20) — NOT NULL
  • RECEIVER_ID — VARCHAR2(20)
  • DATE_CREATED — TIMESTAMP
  • CALLBACK_INFO — VARCHAR2(100)

DELIVERY

  • DELIVERY_ID — NUMBER — NOT NULL
  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • RECEIVER_NAME — VARCHAR2(20) — NOT NULL
  • RECEIVER_ADDRESS — VARCHAR2(150) — NOT NULL
  • RECEIVER_PHONE — VARCHAR2(20)
  • REQUIREMENT — VARCHAR2(150 )
  • DELIVERY_ADDRESS_DETAILS — VARCHAR2(50 )
  • IS_DEFAULT — NUMBER(1,0)

IMAGE

  • IMG_ID — NUMBER
  • PRODUCT_ID — NUMBER
  • IMG_PATH — VARCHAR2(200) — NOT NULL
  • IMG_REAL_NAME — VARCHAR2(200) — NOT NULL
  • IMG_CHANGE_NAME — VARCHAR2(200) — NOT NULL
  • IMG_EXTENSION — VARCHAR2(20) — NOT NULL

INQUIRY

  • INQUIRY_ID — NUMBER — NOT NULL
  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • PRODUCT_ID — INT — NOT NULL
  • INQUIRY_CONTENT — VARCHAR2(500) — NOT NULL
  • INQUIRY_DATE_CREATED — TIMESTAMP — NOT NULL

LIKES

  • LIKES_ID — NUMBER — NOT NULL
  • PRODUCT_ID — INT
  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • REVIEW_ID — VARCHAR2(20) — NOT NULL
  • LIKES_TYPE — NUMBER(1,0) — NOT NULL
  • LIKES_DATE_CREATED — TIMESTAMP — NOT NULL

MEMBER

  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • MEMBER_PW — VARCHAR2
  • MEMBER_NAME — VARCHAR2
  • MEMBER_EMAIL — VARCHAR2
  • MEMBER_PHONE — VARCHAR2
  • MEMBER_AUTH — VARCHAR2

MEMBERSHIP

  • MEMBERSHIP_ID — NUMBER — NOT NULL
  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • JOIN_DATE — TIMESTAMP — NOT NULL
  • EXPIRY_DATE — TIMESTAMP — NOT NULL
  • PAYMENT_DATE — TIMESTAMP — NOT NULL
  • MEMBERSHIP_FEE — NUMBER
  • CHARGE_ID — VARCHAR2(50)

ORDER

  • ORDER_ID — NUMBER — NOT NULL
  • PAYMENT_ID — NUMBER — NOT NULL
  • PRODUCT_ID — NUMBER — NOT NULL
  • PRODUCT_NAME — NUMBER — NOT NULL
  • PRODUCT_PRICE — VARCHAR2 — NOT NULL
  • PURCHASE_NUM — NUMBER — NOT NULL
  • EXPECT_DELIVERY_DATE — TIMESTAMP(6) — NOT NULL
  • IMG_ID — INT
  • MEMBER_ID — VARCHAR2(20)

PAYMENT

  • PAYMENT_ID — NUMBER — NOT NULL
  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • DELIVERY_ADDRESS — VARCHAR2(150) — NOT NULL
  • RECEIVER_NAME — VARCHAR2(20) — NOT NULL
  • RECEIVER_PHONE — VARCHAR2(20)
  • REQUIREMENT — VARCHAR2(150 )
  • MEMBERSHIP_DISCOUNT — NUMBER
  • COUPON_DISCOUNT — NUMBER
  • DELIVERY_PRICE — NUMBER
  • CHARGE_PRICE — NUMBER
  • CHARGE_ID — VARCHAR2(50)

PERSISTENT_LOGINS

  • SERIES — VARCHAR2(100) — NOT NULL
  • USERNAME — VARCHAR2(100) — NOT NULL
  • TOKEN — VARCHAR2(100) — NOT NULL
  • LAST_USED — TIMESTAMP — NOT NULL

PRODUCT

  • PRODUCT_ID — NUMBER — NOT NULL
  • MEMBER_ID — VARCHAR2(20)
  • PRODUCT_NAME — NUMBER
  • PRODUCT_PRICE — VARCHAR2
  • REVIEW_NUM — NUMBER
  • PRODUCT_REMAINS — NUMBER
  • PRODUCT_PLACE — VARCHAR2
  • PRODUCT_STATE — VARCHAR2
  • CATEGORY — VARCHAR2
  • IMG_ID — NUMBER
  • PRODUCT_DATE_CREATED — TIMESTAMP
  • REVIEW_AVG — FLOAT

REGULAR_PURCHASE

  • PAYMENT_ID — NUMBER — NOT NULL
  • DELIVERY_INTERVAL — NUMBER — NOT NULL

REVIEW

  • REVIEW_ID — VARCHAR2(20) — NOT NULL
  • MEMBER_ID — VARCHAR2(20)
  • REVIEW_CONTENT — VARCHAR2
  • REVIEW_DATE_CREATED — VARCHAR2
  • MEMBER_PHONE — VARCHAR2
  • REVIEW_LIKE — VARCHAR2

SELLER

  • MEMBER_ID — VARCHAR2(20) — NOT NULL
  • BUSINESS_NAME — VARCHAR2(50 ) — NOT NULL
  • REQUEST_TIME — TIMESTAMP(6) — NOT NULL
  • REQUEST_CONTENT — VARCHAR2(100) — NOT NULL
  • REQUEST_STATE — VARCHAR2(20)
  • REFUSE_MSG — VARCHAR2(50 )