Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| UsuRolId | BIGINT | 19 | √ | null |
|
|
|||||
| UsuId | BIGINT | 19 | null |
|
|
||||||
| RolId | BIGINT | 19 | null |
|
|
||||||
| UsuRolFchMod | DATETIME | 19 | null |
|
|
||||||
| UsuRolUsu | VARCHAR | 40 | null |
|
|
||||||
| UsuRolApp | VARCHAR | 255 | null |
|
|
||||||
| InsId | BIGINT | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | UsuRolId |
| ISSUSUARIOSROLES | Performance | Asc | InsId |
| IUSUARIOSROLES1 | Performance | Asc | RolId |
| USSUSUARIOSROLES | Must be unique | Asc/Asc/Asc | UsuId + RolId + InsId |
Relationships
Close relationships within degrees of separation
