데이터 모델링 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