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 )