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