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