JHC_ERD
테이블 (7)
공통 (Untitled)
- createdAt — Date
- updatedAt — Date
- reg_date — String
- update_date — String
- del_it — String
유저 (member)
- idx — int — 기본 키 — NOT NULL
- user_id — varchar(30)
- user_pw — varchar(200)
- user_name — varchar(50)
- user_email — varchar(50)
- user_phone — varchar(50)
- department — varchar(50)
- position — varchar(50)
입고이력 (income_history)
- id — String — 기본 키 — NOT NULL
- product_name — String
- product_category — String
- serial — String
- income_date — Date
- manager — String
재고 (inventory)
- id — String — 기본 키 — NOT NULL
- order_id — String — 외래 키 → 주문이력.id — NOT NULL
- product_code — String
- product_name — String
- product_category — String
- serial — String
- income_date_first — Date
- income_date_re — Date
- release_date_first — Date
- release_date_re — Date
- release_location — String
- inventory_state — String
주문메모 (order_memo)
- id — int — 기본 키 — NOT NULL
- order_id — varchar(20) — 외래 키 → 주문이력.id — NOT NULL
- name — varchar(50)
- content (conetnt) — varchar(1000)
- reg_date (regdate) — datetime
- update_date — datetime
주문이력 (order_history)
- id — String — 기본 키 — NOT NULL
- order_date — DateTime
- product_name — String
- product_category — String
- order_name — String
- order_tel — String
- bill_it — String
- qa — int
- price — int
- tax — int
- manager — String
- serial — String
- delivery_company — String
- delivery_invoice — String
- delivery_date — Date
- delivery_address — String
- delivery_name — String
- delivery_tel — String
- payment_date — Date
- payment_way — String
- payment_state — String
- payment_person — String
- delivery_state — String
- del_it — String
출고이력 (release_history)
- id — String — 기본 키 — NOT NULL
- product_name — String
- product_category — String
- serial — String
- manager — String
- release_location — String
- release_date — Date