cmax
Tables (44)
authority_backup
- id — uuid
- name — text
- level — bigint
- description — text
- parent_id — uuid
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- menu_id — uuid
client
- id — uuid — Primary key — NOT NULL
- name — text
- business_number — text
- contact_name — text
- contact_phone — text
- address — text
- created_id — uuid
- updated_id — uuid
- created_at — timestamp
- updated_at — timestamp
common_code_groups
- id — uuid — Primary key — NOT NULL
- group_code — character — NOT NULL
- group_name — character — NOT NULL
- description — text
- is_active — boolean
- created_at — timestamp
- updated_at — timestamp
common_codes
- id — uuid — Primary key — NOT NULL
- group_code — character — NOT NULL
- code — character — NOT NULL
- name — character — NOT NULL
- description — text
- sort_order — integer
- is_active — boolean
- created_at — timestamp
- updated_at — timestamp
defective_processing
- operation_introduction_id — uuid — Primary key — NOT NULL
- defective_count — bigint
- defective_handling_method — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- manager_id — uuid
- Occurrence_date — timestamp
- Processing_date — timestamp
design_bom
- id — uuid — Primary key — NOT NULL
- material_id — uuid — NOT NULL
- quantity — integer — NOT NULL
- parent_id — uuid
- created_id — uuid
- updated_id — uuid
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- code — character — NOT NULL
equipment
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- code — character — NOT NULL
- type — character
- status — character
- installed_at — date
- specs — text
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
line
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- code — character — NOT NULL
- worker_code — character
- line_area — character
- status — character
- remark — text
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
- process_id — uuid
- location_id — uuid
location
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- code — character — NOT NULL
- type — character — NOT NULL
- parent_id — uuid
- address — character
- worker_id — uuid
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
- parent_code — character
material
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- code — character — NOT NULL
- type — character
- spec — text
- unit — character
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
- amount — bigint
material_requirement
- id — uuid — Primary key — NOT NULL
- material_id — uuid — NOT NULL
- required_quantity — numeric — NOT NULL
- totalprice — numeric — NOT NULL
- created_id — uuid
- updated_id — uuid
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
menu_backup
- id — uuid
- name — text
- parent_id — uuid
- type — text
- url — text
- icon — text
- permission — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- sort_order — bigint
- parent_code — text
- code — text
menu_group_menus
- id — uuid — Primary key — NOT NULL
- menu_group_id — uuid — NOT NULL
- menu_id — uuid — NOT NULL
- access_type — character
- created_at — timestamp
- created_id — uuid
menu_groups
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- code — character — NOT NULL
- description — text
- icon — character
- sort_order — integer
- is_active — boolean
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
menus
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- url — character
- code — character — NOT NULL
- type — character
- icon — character
- menu_group_id — uuid
- parent_id — uuid
- sort_order — integer
- is_active — boolean
- is_public — boolean
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
- parent_code — text
order
- id — uuid — Primary key — NOT NULL
- client_id — uuid
- order_date — timestamp
- amount — numeric
- invoice_issued — boolean
- delivery_date — date
- created_id — uuid
- updated_id — uuid
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- quantity — integer
- material_id — uuid
order_plan
- id — uuid — Primary key — NOT NULL
- order_id — uuid — NOT NULL
- plan_date — date — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- material_id — uuid — NOT NULL
- location_id — uuid — NOT NULL
- quantity — integer — NOT NULL
- created_id — uuid
- updated_id — uuid
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
page
- id — bigint — Primary key — NOT NULL
- title — text — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- user_id — uuid
- description — text
- status — character
- slug — character
- meta_title — character
- meta_description — text
- updated_at — timestamp
- deleted_at — timestamp
- author_id — uuid
- author_email — text
- author_name — text
performance_registration
- id — uuid — Primary key — NOT NULL
- process_id — uuid
- facility_code — character
- operation_introduction_id — uuid
- employee_id — uuid
- completion_or_not — boolean
- date_of_registration — timestamp
- remarks — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
permission_group_menu_groups
- id — uuid — Primary key — NOT NULL
- permission_group_id — uuid — NOT NULL
- menu_group_id — uuid — NOT NULL
- access_type — character
- created_at — timestamp
- created_id — uuid
permission_groups
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- code — character — NOT NULL
- description — text
- is_active — boolean
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
permissions
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- code — character — NOT NULL
- level — integer
- description — text
- permission_group_id — uuid
- is_active — boolean
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
posts
- id — uuid — Primary key — NOT NULL
- title — text — NOT NULL
- content — text — NOT NULL
- author_name — text — NOT NULL
- author_email — text
- status — text
- created_at — timestamp
- updated_at — timestamp
- created_id — uuid
- updated_id — uuid
process
- id — uuid — Primary key — NOT NULL
- name — character — NOT NULL
- worker_id — uuid
- status — character
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
- worker_code — character
process_equipment
- id — uuid — Primary key — NOT NULL
- line_id — uuid — NOT NULL
- equipment_id — uuid — NOT NULL
- created_id — uuid
- updated_id — uuid
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
process_flow
- id — uuid — Primary key — NOT NULL
- design_bom_id — uuid — NOT NULL
- step_order — integer — NOT NULL
- line_id — uuid — NOT NULL
- created_id — uuid
- updated_id — uuid
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
process_inspection
- id — uuid — Primary key — NOT NULL
- process_id — uuid
- inspection_criteria_id — uuid
- version — character
- judgment_result — boolean
- inspector_id — uuid
- inspected_at — timestamp
- remarks — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- inspected_quantity — bigint
- pass_count — bigint
- fail_count — bigint
process_inspection_criteria
- id — uuid — Primary key — NOT NULL
- code — text
- inspection_method — text
- acceptance_criteria — text
- equipment_id — uuid
- effective_date — date
- expiry_date — date
- is_active — boolean
- registration_at — timestamp
- remarks — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- registration_id — uuid
- material_id — uuid
- sample_size — bigint
- acceptance_number — bigint
- inspection_scope — character
- reject_policy — text
- inspection_frequency — text
process_inspection_criteria_management
- id — uuid — Primary key — NOT NULL
- inspection_criteria_id — uuid
- reason — text
- request_id — uuid
- request_at — time
- examine_id — uuid
- examine_at — time
- approval_id — uuid
- approval_at — time
- application_at — time
- remarks — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- change_type — character
- version — character
product
- id — uuid — Primary key — NOT NULL
- code — character
- name — character
- category — character
- unit — character
- specification — character
- image_url — character
- safety_stock — bigint
- status — character
- priority — character
- remarks — character
- created_at — timestamp — NOT NULL
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
profiles
- id — uuid — Primary key — NOT NULL
- name — text
- phone_number — text
- address — text
- created_id — uuid
- updated_id — uuid
- created_at — timestamp
- updated_at — timestamp
- role — boolean
- display_name — text
- avatar_url — text
shipment_inspection
- id — uuid — Primary key — NOT NULL
- process_id — uuid
- inspection_criteria_id — uuid
- version — character
- judgment_result — boolean
- inspector_id — uuid
- inspected_at — timestamp
- remarks — text
- created_id — uuid
- created_at — timestamp
- update_id — uuid
- update_at — timestamp
- inspected_quantity — bigint
- pass_count — bigint
- fail_count — bigint
shipment_inspection_criteria
- id — uuid — Primary key — NOT NULL
- code — text
- inspection_method — text
- acceptance_criteria — text
- equipment_id — uuid
- effective_date — date
- expiry_date — date
- is_active — boolean
- raegistration_id — timestamp
- remarks — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- registration_id — uuid
- sampling — text
- sampling_number — bigint
- inspection_scope — character
- sample_size — bigint
- acceptance_number — bigint
- reject_policy — text
- inspection_frequency — text
shipment_inspection_criteria_management
- id — uuid — Primary key — NOT NULL
- inspection_criteria_id — uuid
- reason — text
- request_id — uuid
- request_at — time
- examine_id — uuid
- examine_at — time
- approval_id — uuid
- approval_at — time
- application_at — time
- remarks — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- change_type — character
- version — character
stock
- id — uuid — Primary key — NOT NULL
- material_id — uuid
- count — bigint
- carry_at — timestamp
- release_at — timestamp
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
user
- id — uuid — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- username — character
- password — character
- update_at — timestamp
- update_id — uuid
user_menu_groups
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- menu_group_id — uuid — NOT NULL
- granted_by — uuid
- granted_at — timestamp
- expires_at — timestamp
- created_at — timestamp
user_permission_groups
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- permission_group_id — uuid — NOT NULL
- granted_by — uuid
- granted_at — timestamp
- expires_at — timestamp
- created_at — timestamp
user_permissions
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- permission_id — uuid — NOT NULL
- granted_by — uuid
- granted_at — timestamp
- expires_at — timestamp
- created_at — timestamp
warehouse
- id — uuid — Primary key — NOT NULL
- name — text
- status — text
- type — text
- purpose — text
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- location_id — uuid
- remark — text
warehouse_moving
- id — uuid — Primary key — NOT NULL
- created_id — uuid
- created_at — timestamp
- updated_id — uuid
- updated_at — timestamp
- former_warehouse_id — uuid
- after_warehouse_id — uuid
- material_id — uuid
- material_count — bigint
work_order_detail
- id — uuid — Primary key — NOT NULL
- code — character — NOT NULL
- master_id — uuid
- quantity — integer — NOT NULL
- line_id — uuid
- start_date — date
- end_date — date
- status — character
- assigned_by — uuid
- assigned_to — uuid
- remark — text
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
- design_bom_id — uuid
- location_id — uuid
work_order_master
- id — uuid — Primary key — NOT NULL
- code — character — NOT NULL
- order_id — uuid
- start_date — date
- end_date — date
- status — character
- assigned_by — uuid
- assigned_to — uuid
- remark — text
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid
worker
- id — uuid — Primary key — NOT NULL
- name — character
- code — character
- position — character
- phone — character
- is_active — boolean
- created_at — timestamp
- created_id — uuid
- updated_at — timestamp
- updated_id — uuid