뉴 커머스
테이블 (3)
detail_item
- item_code — varchar2(50) — 기본 키 — NOT NULL
- item_title — varchar2(50)
- item_content — varchar2(3000)
- item_image1 — varchar2(1000)
- item_image2 — varchar2(1000)
- item_image3 — varchar2(1000)
- item_image4 — varchar2(1000)
item
- item_code — varchar2(50) — 기본 키 — NOT NULL
- item_category — varchar2(50)
- item_name — varchar2(50) — NOT NULL
- item_price — number
- item_id — varchar2(50)
- item_code (item_code2) — varchar2(50) — 외래 키 → detail_item.item_code — NOT NULL
member
- id — varchar2(50) — 기본 키 — NOT NULL
- password — varchar2(100)
- nickname — varchar2(100)
- email — varchar2(100)
- name — varchar2(50)
- address — varchar2(100)
- grade — varchar2(50)
- item_code — varchar2(50) — 외래 키 → item.item_code — NOT NULL