MiniProject ERD ver1.0

MiniProject를 위한 기본적인 DB 구조

테이블 (3)

Untitled (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

Untitled (Transaction)

  • Key (tran_no) — NUMBER — 기본 키 — NOT NULL
  • Key (buyer_id) — VARCHAR2 — 외래 키 → Users.Key — NOT NULL
  • Field (prod_no) — NUMBER — 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

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