| uranux_desenv [uranux.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| abi_record | (Table) |
| Columns | ||||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK | Unique |
|
| rec_employee_id | Integer | Funcionário |
| ||||
| rec_issued_date | Date |
| Data de Emissão | |||||
| rec_uf | SmallInt |
| UF | |||||
| rec_delete_bit | SmallInt | 0 | Bit de Exclusão |
|
||||
| rec_issued_by | VarChar(50) | Órgão Emissor | ||||||
| rec_number | VarChar(25) | Nº de Inscrição |
|
|||||
| rec_pis_number | VarChar(20) |
| PIS/PASEP |
|
||||
| rec_serie_number | VarChar(5) |
| Série | |||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| ix_abi_record_abi_employee | URX_PUBLIC.abi_record | rec_employee_id | ||
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_abi_record_abi_employee | URX_PUBLIC.abi_employee | URX_PUBLIC.abi_record | emp_id | rec_employee_id |
| Parent Relations (none) |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| diagramA |