MiniProject ERD ver1.3

MiniProject를 위한 기본적인 DB 구조

테이블 (6)

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

  • 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 (ProductImage)

  • Key (image_no) — NUMBER — 기본 키 — NOT NULL
  • Field (file_name) — VARCHAR2 — NOT NULL
  • Key (prod_no) — NUMBER — 외래 키 → Product.Key — NOT NULL

Untitled (TransactionList)

  • 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

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