| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| ope_service_item | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
|
| ser_item_id | Integer |
| nextval('"URX_PUBLIC".ope_service_item_id_seq'::regclass) | Identificador | |||
| ser_item_service_id | Integer | Serviço |
|
|
||||
| ser_item_work_order_id | Integer |
| Ordem de Serviço |
| ||||
| ser_item_activity_id | Integer |
| Atividade |
| ||||
| ser_item_warranty_finish | Date |
| Data de vencimento da garantia | |||||
| ser_item_type_id | SmallInt | Tipo |
|
|
||||
| ser_item_status_id | SmallInt | 0 | Situação | |||||
| ser_item_value | Numeric(10, 2) | 0 | Valor | |||||
| ser_item_places | Text |
| Locais a serem tratados | |||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| ix_ope_service_item_ope_service | URX_PUBLIC.ope_service_item | ser_item_service_id | ||
| ix_ope_service_item_service_type | URX_PUBLIC.ope_service_item | ser_item_type_id | ||
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ope_service_item_ope_service | URX_PUBLIC.ope_service | URX_PUBLIC.ope_service_item | ser_id | ser_item_service_id |
| fk_ope_service_item_pro_activity | URX_PUBLIC.pro_activity | URX_PUBLIC.ope_service_item | act_id | ser_item_activity_id |
| fk_ope_service_item_service_type | URX_PUBLIC.ope_service_type | URX_PUBLIC.ope_service_item | ser_type_id | ser_item_type_id |
| fk_ope_service_item_work_order | URX_PUBLIC.ope_work_order | URX_PUBLIC.ope_service_item | wor_order_id | ser_item_work_order_id |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ope_service_item_chemical_service | URX_PUBLIC.ope_service_item | URX_PUBLIC.ope_service_item_chemical | ser_item_id | ser_item_che_service_item_id |
| fk_ope_service_item_non_chemical_service | URX_PUBLIC.ope_service_item | URX_PUBLIC.ope_service_item_non_chemical | ser_item_id | ser_item_non_che_service_item_id |
| fk_ope_service_item_product_service_item | URX_PUBLIC.ope_service_item | URX_PUBLIC.ope_service_item_product | ser_item_id | ser_item_pro_service_item_id |
| fk_ope_service_item_tank_ope_service_item | URX_PUBLIC.ope_service_item | URX_PUBLIC.ope_service_item_tank | ser_item_id | ser_item_tank_service_item_id |
| Triggers | |||||||
| Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
| tg_ope_service_item_create | URX_PUBLIC.ope_service_item |
| AFTER | FOR EACH ROW | "URX_PUBLIC"."_u ... | ||
| Used in Diagrams |
| Diagram Name |
| diagramA |