Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| NM_USUARIO | VARCHAR | 50 | null |
|
|
||||||
| CD_APLICACAO | VARCHAR | 8 | null |
|
|
||||||
| DT_ATRIBUICAO | TIMESTAMP | 24 | √ | null |
|
|
|||||
| ID_PERMISSAO | VARCHAR | 1 | √ | null |
|
|
|||||
| QT_ACESSO | INTEGER | 10 | √ | null |
|
|
|||||
| DT_ACESSO | TIMESTAMP | 24 | √ | null |
|
|
|||||
| ID_INSERT | CHAR | 1 | √ | null |
|
|
|||||
| ID_UPDATE | CHAR | 1 | √ | null |
|
|
|||||
| ID_DELETE | CHAR | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FK_APL_USU_APL | Performance | Asc | CD_APLICACAO |
| RDB$FOREIGN253 | Performance | Asc | NM_USUARIO |
| RDB$PRIMARY89 | Must be unique | Asc/Asc | NM_USUARIO + CD_APLICACAO |
Relationships
Close relationships within degrees of separation
