MES
Tables (46)
attachment
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- attachment_type — varchar(255) — 엔티티 타입
- file_name — varchar(255) — 파일명
- file_path — varchar(255) — 파일 경로
- file_size — bigint(20) — NOT NULL — 파일 사이즈
- file_type — varchar(255) — 파일 타입
- base_entity_id — bigint(20)
authority
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- authority_code_category_type — varchar(255)
- authority_code_type — varchar(255)
company
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 회사코드
- title — varchar(255) — 회사명
cooperator
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 협력사코드
- title — varchar(255) — 협력사명
customer
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 고객사코드
- title — varchar(255) — 고객명
defect_code
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 결함 코드
- title — varchar(255) — 결함명
- defect_code_category_id — bigint(20) — Foreign key → defect_code_category.id
defect_code_category
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- title — varchar(255) — 카테고리 이름
department
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 부서 코드
- title — varchar(255) — 부서명
- company_id — bigint(20) — Foreign key → company.id
- parent_id — bigint(20) — Foreign key → department.id
employee
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 사번
- email — varchar(255) — 이메일
- phone — varchar(255) — 전화번호
- position — varchar(255) — 직급
- title — varchar(255) — 직원명
- department_id — bigint(20) — Foreign key → department.id
employee_production_plan_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- employee_id — bigint(20) — Foreign key → employee.id
- production_order_id — bigint(20) — Foreign key → production_order.id
employee_role_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- employee_id — bigint(20) — Foreign key → employee.id
- role_id — bigint(20) — Foreign key → role.id
equipment
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 장비 코드
- title — varchar(255) — 장비명
equipment_record
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- equipment_id — bigint(20) — Foreign key → equipment.id
- off_code_id — bigint(20) — Foreign key → off_code.id
hibernate_sequence
- next_val — bigint(20)
inventory
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- last — bit(1) — 마지막 순서 확인
- quantity — int(11) — 수량
- routing_number — int(11) — 순서
- part_template_id — bigint(20) — Foreign key → part_template.id
inventory_record
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- arrival — varchar(255) — 도착지
- departure — varchar(255) — 출발지
- progress_result_type — varchar(255)
- quantity — int(11) — 수량
- inventory_storage_link_id — bigint(20) — Foreign key → inventory_storage_link.id
- progress_result_id — bigint(20)
inventory_storage_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- quantity — int(11) — 수량
- inventory_id — bigint(20) — Foreign key → inventory.id
- storage_id — bigint(20) — Foreign key → storage.id
item_category
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 카테고리 코드
- title — varchar(255) — 카테고리 이름
item_part_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- quantity — int(11) — 수량
- item_template_id — bigint(20) — Foreign key → item_template.id
- part_template_id — bigint(20) — Foreign key → part_template.id
item_template
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 템플릿 코드
- title — varchar(255) — 템플릿명
- item_category_id — bigint(20) — Foreign key → item_category.id
note
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- note — varchar(255) — 비고
- base_entity_id — bigint(20)
off_code
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 결함 코드
- title — varchar(255) — 결함명
- off_code_category_id — bigint(20) — Foreign key → off_code_category.id
off_code_category
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- title — varchar(255) — 카테고리 이름
outsourcing_order
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- completed_quantity — int(11) — 성공 수량
- production_order_status_type — varchar(255) — 작업 상태
- total_quantity — int(11) — 목표 수량
- work_order — int(11) — 작업 순번
- routing_id — bigint(20) — Foreign key → routing.id
outsourcing_result
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- quantity — int(11)
- production_result_type — varchar(255) — 생산 상태
- defect_code_id — bigint(20) — Foreign key → defect_code.id
- outsourcing_order_id — bigint(20) — Foreign key → outsourcing_order.id
part_template
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 템플릿 코드
- part_template_type — varchar(255) — 파트 타입
- title — varchar(255) — 템플릿명
- process_template_id — bigint(20) — Foreign key → process_template.id
part_template_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- quantity — int(11) — 수량
- child_template_id — bigint(20) — Foreign key → part_template.id
- parent_template_id — bigint(20) — Foreign key → part_template.id
part_template_purchase_order_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- part_template_id — bigint(20) — Foreign key → part_template.id
- purchase_order_id — bigint(20) — Foreign key → purchase_order.id
plant
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 작업장코드
- title — varchar(255) — 작업장명
- company_id — bigint(20) — Foreign key → company.id
process
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 공정 코드
- title — varchar(255) — 공정명
- plant_id — bigint(20) — Foreign key → plant.id
process_equipment_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- equipment_id — bigint(20) — Foreign key → equipment.id
- process_id — bigint(20) — Foreign key → process.id
process_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- routing_number — int(11)
- process_id — bigint(20) — Foreign key → process.id
- process_template_id — bigint(20) — Foreign key → process_template.id
process_template
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 템플릿 코드
- title — varchar(255) — 템플릿 명
production_order
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- completed_quantity — int(11) — 성공 수량
- production_order_status_type — varchar(255) — 작업 상태
- total_quantity — int(11) — 목표 수량
- work_order — int(11) — 작업 순번
- routing_id — bigint(20) — Foreign key → routing.id
production_result
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- quantity — int(11)
- production_result_type — varchar(255) — 생산 상태
- defect_code_id — bigint(20) — Foreign key → defect_code.id
- production_order_id — bigint(20) — Foreign key → production_order.id
project
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- title — varchar(255) — 프로젝트명
- company_id — bigint(20) — Foreign key → company.id
project_item_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- quantity — int(11) — 수량
- item_template_id — bigint(20) — Foreign key → item_template.id
- project_id — bigint(20) — Foreign key → project.id
property
- id — bigint(20) — Primary key — NOT NULL
- value — varchar(255)
- entity_id — bigint(20)
- property_def_id — bigint(20) — Foreign key → property_def.id
property_def
- id — bigint(20) — Primary key — NOT NULL
- active — bit(1) — NOT NULL
- data_type — varchar(255)
- description — varchar(255)
- entity_type — varchar(255)
- options — varchar(255)
- title — varchar(255)
purchase
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- quantity — int(11) — 수량
- item_template_id — bigint(20) — Foreign key → item_template.id
- part_template_id — bigint(20) — Foreign key → part_template.id
- project_id — bigint(20) — Foreign key → project.id
purchase_order
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- completed_quantity — int(11) — 성공 수량
- purchase_type — varchar(255) — 구매 타입
- total_quantity — int(11) — 목표 수량
purchase_result
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- quantity — int(11)
- purchase_type — varchar(255) — 구매 상태
- purchase_order_id — bigint(20) — Foreign key → purchase_order.id
role
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- title — varchar(255) — 권한명
role_authority_link
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- authority_id — bigint(20) — Foreign key → authority.id
- role_id — bigint(20) — Foreign key → role.id
routing
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- completed_quantity — int(11) — 완료 수량
- defect_quantity — int(11) — 불량 수량
- routing_number — int(11) — 공정 순서
- total_quantity — int(11) — 목표 수량
- item_template_id — bigint(20) — Foreign key → item_template.id
- parent_id — bigint(20) — Foreign key → routing.id
- part_template_id — bigint(20) — Foreign key → part_template.id
- prev_id — bigint(20) — Foreign key → routing.id
- process_id — bigint(20) — Foreign key → process.id
- project_id — bigint(20) — Foreign key → project.id
storage
- id — bigint(20) — Primary key — NOT NULL
- date_of_creation — datetime(6)
- date_of_modification — datetime(6)
- active — bit(1) — NOT NULL
- code — varchar(255) — 창고 코드
- title — varchar(255) — 창고명