| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| ope_vector | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
|
| vec_id | SmallInt |
| nextval('"URX_PUBLIC".ope_vector_id_seq'::regclass) | Identificador | |||
| vec_delete_bit | SmallInt | 0 | Bit de Exclusão |
|
||||
| vec_label | VarChar(50) | Rótulo |
|
|||||
| vec_label_scientific | VarChar(150) |
| Nome Científico | |||||
| vec_prevent | Text |
| Medidas Corretivas ou Preventivas (NOP-INEA-16 Anexo 2) | |||||
| vec_unit_id | Integer | Unidade | ||||||
| vec_type_id | SmallInt | Tipo | ||||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| ix_ope_vector_label | URX_PUBLIC.ope_vector | vec_label | ||
| Foreign Keys (none) |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ope_service_type_vector | URX_PUBLIC.ope_vector | URX_PUBLIC.ope_service_type | vec_id | ser_type_vector_id |
| fk_ope_service_vector_vector | URX_PUBLIC.ope_vector | URX_PUBLIC.ope_service_vector | vec_id | ser_vector_vector_id |
| Triggers | |||||||
| Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
| tg_ope_vector_create | URX_PUBLIC.ope_vector |
| AFTER | FOR EACH ROW | "URX_PUBLIC"."_u ... | ||
| Used in Diagrams |
| Diagram Name |
| diagramA |