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