MiniProject ERD ver1.1
MiniProject를 위한 기본적인 DB 구조
테이블 (3)
Product
- Key (prod_no) — NUMBER — 기본 키 — NOT NULL
- Field (prod_name) — VARCHAR2 — NOT NULL
- Field (prod_detail) — VARCHAR2
- Field (manufacture_day) — VARCHAR2
- Field (price) — NUMBER
- Field (image_file) — VARCHAR2
- Field (reg_date) — DATE
- Field (count) — NUMBER
Transaction
- Key (tran_no) — NUMBER — 기본 키 — NOT NULL
- Key (buyer_id) — VARCHAR2 — 외래 키 → Users.Key — NOT NULL
- Key (prod_no) — NUMBER — 외래 키 → Product.Key — 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 (prod_count) — NUMBER — NOT NULL
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