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