EVision
Tables (9)
M_customer (판매업체 마스터)
- customer_code (Key) — varchar — Primary key — NOT NULL
- name (Field) — varchar
- manager (Field2) — varchar
- address (Field3) — varchar
- phone (Field4) — varchar
- email (Field5) — varchar
M_item (상품 마스터)
- item_code (Key) — varchar — Primary key — NOT NULL
- name (Field) — varchar
- unit (Field2) — varchar
M_permission (권한 마스터)
- permission_code (Key) — varchar — Primary key — NOT NULL
M_purchase_price (공급가 마스터)
- purchase_price_id (Key) — bigint — Primary key — NOT NULL
- price (Field) — int
- date (Field2) — timestamp
- quantity (Field3) — int
M_sales_price (판매가 마스터)
- sales_price_id (Key) — bigint — Primary key — NOT NULL
- price (Field) — int
- start_date (Field2) — timestamp
- end_date (Field3) — timestamp
M_supplier (공급업체 마스터)
- supplier_code (Key) — varchar — Primary key — NOT NULL
- name (Field) — varchar
T_member (판매사원)
- member_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- position (Field2) — varchar
- department (Field3) — varchar
T_order_header (주문)
- order_header_id (Key) — bigint — Primary key — NOT NULL
- order_date (Field) — timestamp
- demand_date (Field2) — timestamp
- accept_date (Field3) — timestamp
- dispatch_date (Field4) — timestamp
T_order_item (주문 상품)
- order_item_id (Key) — bigint — Primary key — NOT NULL
- item_code (Field) — varchar
- item_name (Field2) — varchar
- item_unit (Field3) — varchar
- quantity (Field4) — int
- sales_price (Field5) — int
- margin_rate (Field6) — long
- Field7