| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| fin_cash_flow_reset | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
| cas_flow_reset_dt | TimeStampWithTimeZone | Data-hora do registro | ||||||
|
| cas_flow_reset_id | Integer |
| nextval('"URX_PUBLIC".fin_cash_flow_reset_id_seq'::regclass) | Identificador | |||
| cas_flow_reset_unit_id | Integer | Unidade |
| |||||
| cas_flow_reset_date | Date | Data | ||||||
| cas_flow_reset_cell_id | SmallInt | Célula de Crédito |
| |||||
| cas_flow_reset_value | Numeric(10, 2) | Valor | ||||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| ix_fin_cas_flow_reset_cell_id | URX_PUBLIC.fin_cash_flow_reset | cas_flow_reset_cell_id | ||
| ix_fin_cash_flow_reset_date | URX_PUBLIC.fin_cash_flow_reset | cas_flow_reset_date | ||
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_fin_cash_flow_reset_credit_cell | URX_PUBLIC.fin_credit_cell | URX_PUBLIC.fin_cash_flow_reset | cre_id | cas_flow_reset_cell_id |
| fk_fin_cash_flow_reset_unit | URX_PUBLIC.adm_unit | URX_PUBLIC.fin_cash_flow_reset | uni_person_id | cas_flow_reset_unit_id |
| Parent Relations (none) |
| Triggers | |||||||
| Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
| tg_cas_flow_reset_dt | URX_PUBLIC.fin_cash_flow_reset |
| BEFORE | FOR EACH ROW | "URX_PUBLIC"."_u ... | ||
| tg_fin_cash_flow_reset_create | URX_PUBLIC.fin_cash_flow_reset |
| AFTER | FOR EACH ROW | "URX_PUBLIC"."_u ... | ||
| Used in Diagrams |
| Diagram Name |
| diagramA |