MiniProject ERD ver1.4
MiniProject를 위한 기본적인 DB 구조
테이블 (8)
Product (product)
- Key (prod_no) — NUMBER — 기본 키 — NOT NULL
- Field (prod_name) — VARCHAR2 — NOT NULL
- Field (prod_detail) — VARCHAR2
- Field (manufacture_day) — DATE
- Field (price) — NUMBER
- Field (reg_date) — DATE
- Field (count) — NUMBER
Transaction (transaction)
- Key (tran_no) — NUMBER — 기본 키 — NOT NULL
- Key (buyer_id) — VARCHAR2 — 외래 키 → Users.Key — NOT NULL
- Field (tran_name) — VARCHAR2 — NOT NULL
- Field (payment_option) — CHAR
- Field (receiver_name) — VARCHAR2
- Field (receiver_phone) — VARCHAR2
- Field (dlvy_addr) — VARCHAR2
- Field (dlvy_request) — VARCHAR2
- Field (tran_status_code) — VARCHAR2
- Field (order_date) — DATE
- Field (dlvy_date) — DATE
- Field (total_price) — NUMBER — NOT NULL
Untitled (product_image)
- Key (image_no) — NUMBER — 기본 키 — NOT NULL
- Field (file_name) — VARCHAR2 — NOT NULL
- Key (prod_no) — NUMBER — 외래 키 → Product.Key — NOT NULL
Untitled (transaction_list)
- Key (tran_no) — NUMBER — 외래 키 → Transaction.Key — NOT NULL
- Field (prod_no) — NUMBER — NOT NULL
- Field (price) — NUMBER — NOT NULL
- Field (prod_count) — NUMBER — NOT NULL
Untitled (Cart)
- Key (user_id) — VARCHAR2 — 외래 키 → Users.Key — NOT NULL
- Key (prod_no) — NUMBER — 외래 키 → Product.Key — NOT NULL
- Field (price) — NUMBER — NOT NULL
- Field (count) — NUMBER — NOT NULL
Untitled (product_tag)
- Key (prod_no) — NUMBER — 외래 키 → Product.Key — NOT NULL
- Key (tag_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
Untitled (tag)
- Key (tag_no) — NUMBER — 기본 키 — NOT NULL
- Field (tag_name) — VARCHAR2 — NOT NULL
Users (users)
- Key (user_id) — VARCHAR2 — 기본 키 — NOT NULL
- Field (user_name) — VARCHAR2 — NOT NULL
- Field (password) — VARCHAR2 — NOT NULL
- Field (role) — VARCHAR2
- Field (ssh) — VARCHAR2
- Field (cell_phone) — VARCHAR2
- Field (addr) — VARCHAR2
- Field (email) — VARCHAR2
- Field (reg_date) — DATE
- Field (mileage) — NUMBER — NOT NULL