test

Tables (7)

BASKET (Untitled6)

  • b_reg — number — Primary key — NOT NULL
  • id — varchar2
  • p_code — varchar2
  • p_name — varchar2
  • p_subject — varchar2
  • p_price — number
  • p_cnt — number
  • p_filename — varchar2
  • p_date — SYSDATE
  • p_option — varchar2
  • id (id2) — varchar2 — Foreign key → SHOPPING_MEMBER.id — NOT NULL

NOTICE (Untitled5)

  • n_num — number — Primary key — NOT NULL
  • n_id — varchar2
  • n_subject — varchar2
  • n_content — clob
  • n_date — SYSDATE

PRODUCT (Untitled2)

  • p_code — varchar2 — Primary key — NOT NULL
  • p_name — varchar2
  • p_subject — varchar2
  • p_price — number
  • p_filename — varchar2
  • p_content — varchar2
  • p_category — varchar2
  • p_seller — varchar2
  • p_point — number
  • p_reg — number
  • p_date — SYSDATE
  • Field

PRODUCT_OPTION (Untitled3)

  • p_option_reg — number — Primary key — NOT NULL
  • p_code — varchar2
  • p_option — varchar2
  • p_total_cnt — number
  • p_code (p_code2) — varchar2 — Foreign key → PRODUCT.p_code — NOT NULL

QUESTIONS_BOARD (Untitled7)

  • p_num — number — Primary key — NOT NULL
  • ref — number
  • ref_step — number
  • ref_level — number
  • p_code — varchar2
  • id — varchar2
  • subject — varchar2
  • content — varchar2
  • password — varchar2
  • q_type — varchar2
  • q_date — SYSDATE
  • p_code (p_code2) — varchar2 — Foreign key → PRODUCT.p_code — NOT NULL
  • id (id2) — varchar2 — Foreign key → SHOPPING_MEMBER.id — NOT NULL

REVIEW_WRITE (Untitled4)

  • id — varchar2 — Primary key — NOT NULL
  • id (id2) — varchar2 — Foreign key → SHOPPING_MEMBER.id — NOT NULL
  • name — varchar2
  • p_code — varchar2
  • p_name — varchar2
  • review_content — varchar2
  • review_filename — varchar2
  • review_filesize — number
  • review_star — varchar2
  • review_cnt — number
  • review_like — number
  • review_date — SYSDATE
  • p_code (p_code2) — varchar2 — Foreign key → PRODUCT.p_code — NOT NULL

SHOPPING_MEMBER (Untitled)

  • id — varchar2 — Primary key — NOT NULL
  • pw — varchar2
  • name — varchar2
  • email — varchar2
  • address — varchar2
  • phone — varchar2
  • gender — varchar2
  • birthday — varchar2
  • lv — number
  • member_date — SYSDATE