dd
Tables (11)
ATTACHMENT
- f_ID — NUMBER — NOT NULL
- product_no — NUMBER — NOT NULL
- ORIGIN_NAME — VARCHAR2(255) — NOT NULL
- CHANGE_NAME — VARCHAR2(255) — NOT NULL
- FILE_PATH — VARCHAR2(1000) — NOT NULL
- FILE_LEVEL — NUMBER — NOT NULL
Black_list
- report_no — NUMBER — Primary key — NOT NULL
- black_id — VARCHAR2(20) — NOT NULL
- reporter_id — VARCHAR2(20) — NOT NULL
- reporter_date — DATE — NOT NULL
- reporter_reason — VARCHAR2(100) — NOT NULL
Category
- category_code — VARCHAR2(20) — Primary key — NOT NULL
- category_name — VARCHAR2(30) — NOT NULL
Member
- user_id — VARCHAR2(20) — Primary key — NOT NULL
- user_type — NUMBER — NOT NULL
- user_pwd — VARCHAR2(45) — NOT NULL
- user_name — VARCHAR2(30) — NOT NULL
- birth_date — VARCHAR2(20) — NOT NULL
- gender — VARCHAR2(1) — NOT NULL
- email — VARCHAR2(45) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
- address — VARCHAR2(50) — NOT NULL
- join_date — DATE — NOT NULL
- Withdrawal — VARCHAR2(1) — NOT NULL
- black_code — VARCHAR2(1) — NOT NULL
Notice
- Notice_no — NUMBER — Primary key — NOT NULL
- Notice_type — NUMBER — NOT NULL
- Notice_title — VARCHAR2(20) — NOT NULL
- Notice_content — VARCHAR2(1000) — NOT NULL
- Notice_date — Date — NOT NULL
- Notice_readcount — NUMBER
- Status — VARCHAR2(1) — NOT NULL
Payment
- Payment_no — VARCHAR2(40) — NOT NULL
- b_id — VARCHAR2(20) — NOT NULL
- product_ok_no — NUMBER — NOT NULL
- price — NUMBER — NOT NULL
- user_state — VARCHAR2(1) — NOT NULL
- deal_date — Date
Product
- product_no — NUMBER — Primary key — NOT NULL
- p_id — VARCHAR2(20) — NOT NULL
- price — NUMBER — NOT NULL
- category_code — VARCHAR2(20) — NOT NULL
- Approval — VARCHAR2(1) — NOT NULL
- product_title — VARCHAR2(1000) — NOT NULL
- product_Contents — VARCHAR2(1000) — NOT NULL
- reg_date — DATE — NOT NULL
- product_state — VARCHAR2(1)
- status — VARCHAR2(1) — NOT NULL
inquiry
- inquiry_no — NUMBER — Primary key — NOT NULL
- inquiry_title — VARCHAR2(1000) — NOT NULL
- inquiry_content — VARCHAR2(1000) — NOT NULL
- inquiry_date — DATE — NOT NULL
- user_id — VARCHAR2(20) — NOT NULL
- answer_state — VARCHAR2(1) — NOT NULL
- status — VARCHAR2(1) — NOT NULL
product_ok
- product_ok_no — NUMBER — Primary key — NOT NULL
- product_no — NUMBER — NOT NULL
- Approval_date — DATE — NOT NULL
- p_id — VARCHAR2(20) — NOT NULL
review
- review_no — NUMBER — Primary key — NOT NULL
- review_title — VARCHAR2(20) — NOT NULL
- review_content — VARCHAR2(1000) — NOT NULL
- review_date — Date — NOT NULL
- review_readcount — NUMBER
- user_id — VARCHAR2(20) — NOT NULL
- status — VARCHAR2(1) — NOT NULL
shopping_basket
- product_ok_no — NUMBER — NOT NULL
- b_id — VARCHAR2(20) — NOT NULL