데이터 모델링 ezen

테이블 (13)

Untitled (orderlist)

  • Key (orderlist_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Key (order_num) — NUMBER(20) — 외래 키 → 주문.Key — NOT NULL
  • Field (product_name) — VARCHAR(20) — NOT NULL
  • Field2 (price) — NUMBER(20) — NOT NULL
  • Field3 (order_quantity) — NUMBER(20) — NOT NULL
  • Field4 (load_quantity) — NUMBER(10) — NOT NULL
  • Key (product_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (login_info)

  • Key (customer_id) — VARCHAR(20) — 기본 키 — NOT NULL
  • Key (customer_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (password) — VARCHAR(20) — NOT NULL

Untitled (customer)

  • Key (customer_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (customer_name) — VARCHAR(20) — NOT NULL
  • Field (phone_num) — NUMBER(20) — NOT NULL
  • Field (address) — VARCHAR(20) — NOT NULL
  • Field (city) — VARCHAR(20) — NOT NULL
  • Field (state) — VARCHAR(20) — NOT NULL
  • Field (nation) — VARCHAR(20) — NOT NULL
  • Field (zipcode) — NUMBER(20) — NOT NULL
  • Field (credit_level) — VARCHAR(20) — NOT NULL
  • Field (region_num) — NUMBER(20) — NOT NULL
  • Field (note) — VARCHAR(20)
  • Key (employee_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (employee)

  • Key (employee_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Key (department_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (first_name) — VARCHAR(20) — NOT NULL
  • Field (last_name) — VARCHAR(20) — NOT NULL
  • Field (employee_id) — VARCHAR(20) — NOT NULL
  • Field2 (hire_date) — DATE — NOT NULL
  • Field (rank) — VARCHAR(20) — NOT NULL
  • Field (salary) — NUMBER(20) — NOT NULL
  • Field (commission_pct) — NUMBER(20)
  • Field (opinion) — VARCHAR(20)
  • Key (warehouse_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (department)

  • Key (department_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (department_name) — VARCHAR(20) — NOT NULL

Untitled (product)

  • Key (product_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (product_name) — VARCHAR(20) — NOT NULL
  • Field (price) — NUMBER(20) — NOT NULL
  • Field (reorder_date) — DATE — NOT NULL
  • Field (simple_ex) — VARCHAR(20) — NOT NULL
  • Field (detail_ex) — VARCHAR(20) — NOT NULL
  • Field (sales_unit) — NUMBER(20) — NOT NULL
  • Field (offer_price) — NUMBER(20) — NOT NULL
  • Key (stock_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (warehouse)

  • Key (warehouse_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (warehouse_name) — VARCHAR2(20) — NOT NULL
  • Field (warehouse_tel) — NUMBER(20) — NOT NULL
  • Field (warehouse_address) — VARCHAR2(20) — NOT NULL
  • Field (warehouse_city) — VARCHAR2(20) — NOT NULL
  • Field (warehouse_state) — VARCHAR2(20) — NOT NULL
  • Field (warehouse_nation) — VARCHAR2(20) — NOT NULL
  • Field (warehouse_zipcode) — VARCHAR2(20) — NOT NULL
  • Key (region_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (region)

  • Key (region_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (region_name) — VARCHAR2(20) — NOT NULL

Untitled (release)

  • Key (release_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Key (orderlist_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (releaselist)

  • Key (releaselist_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Key (release_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (warehouse_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (stock)

  • Key (stock_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (total_stock) — NUMBER(20)
  • Field (max_stock) — NUMBER(20) — NOT NULL
  • Field (zero_reason) — VARCHAR(20)
  • Field (restock_date) — DATE

Untitled (stocklist)

  • Key (stocklist_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Key (stock_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (warehouse_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL

주문 (order)

  • Key (order_num) — NUMBER(20) — 기본 키 — NOT NULL
  • Key (customer_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (customer_name) — VARCHAR(20) — NOT NULL
  • Field (order_date) — DATE — NOT NULL
  • Field (load_date) — DATE — NOT NULL
  • Field (order_price) — NUMBER(20)
  • Field (payment_method) — VARCHAR(10) — NOT NULL
  • Field (load) — VARCHAR(10) — NOT NULL
  • Key (employee_num) — NUMBER(20) — 외래 키 → Untitled.Key — NOT NULL