| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| fin_bank_order_feedback | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
| ban_order_feedback_dt | TimeStampWithTimeZone | Data de Importação | ||||||
|
| ban_order_feedback_id | Integer |
| nextval('"URX_PUBLIC".fin_bank_order_feedback_id_seq'::regclass) | Identificador | |||
| ban_order_feedback_bank_order_id | Integer |
| Ordem de Pagamento |
| ||||
| ban_order_feedback_unit_id | Integer | Unidade |
| |||||
| ban_order_feedback_account_id | Integer | Conta Bancária |
| |||||
| ban_order_feedback_file_id | Integer | Arquivo |
|
|
||||
| ban_order_feedback_date | Date | Data de Geração | ||||||
| ban_order_feedback_count | SmallInt | Nº de Registros | ||||||
| ban_order_feedback_is_test | SmallInt | 0 | É teste | |||||
| ban_order_feedback_bank_id | VarChar(3) | Banco |
| |||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| ix_fin_bank_order_feedback_sys_file | URX_PUBLIC.fin_bank_order_feedback | ban_order_feedback_file_id | ||
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_fin_bank_order_feedback_account | URX_PUBLIC.fin_account | URX_PUBLIC.fin_bank_order_feedback | acc_id | ban_order_feedback_account_id |
| fk_fin_bank_order_feedback_bank | URX_PUBLIC.fin_bank | URX_PUBLIC.fin_bank_order_feedback | ban_id | ban_order_feedback_bank_id |
| fk_fin_bank_order_feedback_bank_order | URX_PUBLIC.fin_bank_order | URX_PUBLIC.fin_bank_order_feedback | ban_order_id | ban_order_feedback_bank_order_id |
| fk_fin_bank_order_feedback_sys_file | URX_PUBLIC.sys_file | URX_PUBLIC.fin_bank_order_feedback | fil_id | ban_order_feedback_file_id |
| fk_fin_bank_order_feedback_unit | URX_PUBLIC.adm_unit | URX_PUBLIC.fin_bank_order_feedback | uni_person_id | ban_order_feedback_unit_id |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_fin_bank_order_feedback_item_feedback | URX_PUBLIC.fin_bank_order_feedback | URX_PUBLIC.fin_bank_order_feedback_item | ban_order_feedback_id | ban_order_feedback_item_feedback_id |
| Triggers | |||||||
| Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
| tg_ban_order_feedback_dt | URX_PUBLIC.fin_bank_order_feedback |
| BEFORE | FOR EACH ROW | "URX_PUBLIC"."_u ... | ||
| tg_fin_bank_order_feedback_create | URX_PUBLIC.fin_bank_order_feedback |
| AFTER | FOR EACH ROW | "URX_PUBLIC"."_u ... | ||
| Used in Diagrams |
| Diagram Name |
| diagramA |