Quality database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`quality_action`

Doctrine entity: Quality\Entity\Action

Column	Doctrine type	Key
`action_id`	`integer`
`action`	`string`
`sequence`	`smallint`
`participants`	`string`
`deadline`	`string`
`how_evaluated`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_archived`	`datetime`
`process_id`	`FK`	FK
`year_id`	`FK`	FK
`source_id`	`FK`	FK
`contact_id`	`FK`	FK
`group_id`	`FK`	FK

`quality_action_group`

Doctrine entity: Quality\Entity\Action\Group

Column	Doctrine type	Key
`group_id`	`integer`
`group`	`string`
`type`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`

`quality_action_result`

Doctrine entity: Quality\Entity\Action\Result

Column	Doctrine type	Key
`result_id`	`integer`
`description`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`action_id`	`FK`	FK
`phase_id`	`FK`	FK
`status_id`	`FK`	FK

`quality_action_source`

Doctrine entity: Quality\Entity\Action\Source

Column	Doctrine type	Key
`source_id`	`integer`
`source`	`string`
`sequence`	`integer`
`active`	`boolean`
`date_created`	`datetime`
`date_updated`	`datetime`

`quality_dashboard_category`

Doctrine entity: Quality\Entity\Dashboard\Category

Column	Doctrine type	Key
`category_id`	`integer`
`category`	`string`
`sequence`	`integer`

`quality_dashboard_type`

Doctrine entity: Quality\Entity\Dashboard\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`
`description`	`text`
`sequence`	`integer`
`report_per_call`	`boolean`
`category_id`	`FK`	FK

`quality_kpi`

Doctrine entity: Quality\Entity\Kpi

Column	Doctrine type	Key
`kpi_id`	`integer`
`sequence`	`smallint`
`sequence_dashboard`	`smallint`
`kpi`	`string`
`unit`	`string`
`show_on_dashboard`	`boolean`
`date_created`	`datetime`
`date_updated`	`datetime`
`date_archived`	`datetime`
`process_id`	`FK`	FK
`group_id`	`FK`	FK
`dashboard_type_id`	`FK`	FK
`year_id`	`FK`	FK
`contact_id`	`FK`	FK

`quality_kpi_group`

Doctrine entity: Quality\Entity\Kpi\Group

Column	Doctrine type	Key
`group_id`	`integer`
`group`	`string`
`sequence`	`smallint`
`background_color`	`string`
`front_color`	`string`
`type`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`

`quality_kpi_result`

Doctrine entity: Quality\Entity\Kpi\Result

Column	Doctrine type	Key
`result_id`	`integer`
`value`	`decimal`
`not_applicable`	`boolean`
`comments`	`text`
`date_created`	`datetime`
`date_updated`	`datetime`
`contact_id`	`FK`	FK
`kpi_id`	`FK`	FK
`phase_id`	`FK`	FK
`status_id`	`FK`	FK

`quality_kpi_target`

Doctrine entity: Quality\Entity\Kpi\Target

Column	Doctrine type	Key
`kpi_target_id`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`min_value`	`decimal`
`max_value`	`decimal`
`include_equal`	`boolean`
`cause_analysis`	`text`
`corrective_action`	`text`
`target_id`	`FK`	FK
`kpi_id`	`FK`	FK

`quality_phase`

Doctrine entity: Quality\Entity\Phase

Column	Doctrine type	Key
`phase_id`	`integer`
`phase`	`string`
`sequence`	`integer`
`date_created`	`datetime`
`date_updated`	`datetime`
`active_for_kpi`	`boolean`
`active_for_actions`	`boolean`
`show_on_dashboard`	`boolean`
`type_id`	`FK`	FK
`year_id`	`FK`	FK

`quality_phase_type`

Doctrine entity: Quality\Entity\Phase\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`

`quality_process`

Doctrine entity: Quality\Entity\Process

Column	Doctrine type	Key
`process_id`	`integer`
`sequence`	`integer`
`process`	`string`
`background_color`	`string`
`front_color`	`string`

`quality_status`

Doctrine entity: Quality\Entity\Status

Column	Doctrine type	Key
`status_id`	`integer`
`StatusRepository`	`string`
`score`	`smallint`
`lower_bound`	`decimal`
`upper_bound`	`decimal`
`color`	`string`
`background_color`	`string`
`sequence`	`smallint`
`date_created`	`datetime`
`date_updated`	`datetime`
`active`	`boolean`

`quality_target`

Doctrine entity: Quality\Entity\Target

Column	Doctrine type	Key
`target_id`	`integer`
`target`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`
`active`	`boolean`
`year_id`	`FK`	FK

`quality_year`

Doctrine entity: Quality\Entity\Year

Column	Doctrine type	Key
`year_id`	`integer`
`year`	`smallint`
`color`	`string`
`date_created`	`datetime`
`date_updated`	`datetime`

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`quality_action`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[quality_action]0..*-contact 0..1>[contact]`
`quality_action`	`group`	Many-to-one	`0..*`	`0..1`	`quality_action_group`	`[quality_action]0..*-group 0..1>[quality_action_group]`
`quality_action`	`process`	Many-to-one	`0..*`	`1`	`quality_process`	`[quality_action]0..*-process 1>[quality_process]`
`quality_action`	`source`	Many-to-one	`0..*`	`1`	`quality_action_source`	`[quality_action]0..*-source 1>[quality_action_source]`
`quality_action`	`year`	Many-to-one	`0..*`	`1`	`quality_year`	`[quality_action]0..*-year 1>[quality_year]`
`quality_action_result`	`action`	Many-to-one	`0..*`	`1`	`quality_action`	`[quality_action_result]0..*-action 1>[quality_action]`
`quality_action_result`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[quality_action_result]0..*-contact 1>[contact]`
`quality_action_result`	`phase`	Many-to-one	`0..*`	`1`	`quality_phase`	`[quality_action_result]0..*-phase 1>[quality_phase]`
`quality_action_result`	`StatusRepository`	Many-to-one	`0..*`	`1`	`quality_status`	`[quality_action_result]0..*-status 1>[quality_status]`
`quality_dashboard_type`	`category`	Many-to-one	`0..*`	`1`	`quality_dashboard_category`	`[quality_dashboard_type]0..*-category 1>[quality_dashboard_category]`
`quality_kpi`	`contact`	Many-to-one	`0..*`	`0..1`	`contact`	`[quality_kpi]0..*-contact 0..1>[contact]`
`quality_kpi`	`dashboardType`	Many-to-one	`0..*`	`0..1`	`quality_dashboard_type`	`[quality_kpi]0..*-dashboardType 0..1>[quality_dashboard_type]`
`quality_kpi`	`group`	Many-to-one	`0..*`	`0..1`	`quality_kpi_group`	`[quality_kpi]0..*-group 0..1>[quality_kpi_group]`
`quality_kpi`	`process`	Many-to-one	`0..*`	`1`	`quality_process`	`[quality_kpi]0..*-process 1>[quality_process]`
`quality_kpi`	`year`	Many-to-one	`0..*`	`1`	`quality_year`	`[quality_kpi]0..*-year 1>[quality_year]`
`quality_kpi_result`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[quality_kpi_result]0..*-contact 1>[contact]`
`quality_kpi_result`	`kpi`	Many-to-one	`0..*`	`1`	`quality_kpi`	`[quality_kpi_result]0..*-kpi 1>[quality_kpi]`
`quality_kpi_result`	`phase`	Many-to-one	`0..*`	`1`	`quality_phase`	`[quality_kpi_result]0..*-phase 1>[quality_phase]`
`quality_kpi_result`	`StatusRepository`	Many-to-one	`0..*`	`1`	`quality_status`	`[quality_kpi_result]0..*-status 1>[quality_status]`
`quality_kpi_target`	`kpi`	Many-to-one	`0..*`	`1`	`quality_kpi`	`[quality_kpi_target]0..*-kpi 1>[quality_kpi]`
`quality_kpi_target`	`target`	Many-to-one	`0..*`	`1`	`quality_target`	`[quality_kpi_target]0..*-target 1>[quality_target]`
`quality_phase`	`type`	Many-to-one	`0..*`	`1`	`quality_phase_type`	`[quality_phase]0..*-type 1>[quality_phase_type]`
`quality_phase`	`year`	Many-to-one	`0..*`	`1`	`quality_year`	`[quality_phase]0..*-year 1>[quality_year]`
`quality_target`	`year`	One-to-one	`0..1`	`1`	`quality_year`	`[quality_target]0..1-year 1>[quality_year]`

02 November 2026