| Tables |
|
PERFILES
| Tables |
|
PERFILES
Description
(There is no description for table PERFILES)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CODIGO |
|
CHAR(10) |
|
|
|
|
|
NOMBRE |
|
CHAR(80) |
|
|
|
|
|
INSERTAR |
|
CHAR(1) |
|
'N' |
|
|
|
EDITAR |
|
CHAR(1) |
|
'N' |
|
|
|
BORRAR |
|
CHAR(1) |
|
'N' |
|
|
|
F2_S |
|
CHAR(1) |
|
'N' |
|
|
|
F2_C |
|
CHAR(1) |
|
'N' |
|
|
|
F3_C |
|
CHAR(1) |
|
'N' |
|
|
|
F5 |
|
CHAR(1) |
|
'N' |
|
|
|
F6 |
|
CHAR(1) |
|
'N' |
|
|
|
F7 |
|
CHAR(1) |
|
'N' |
|
|
|
F8 |
|
CHAR(1) |
|
'N' |
|
|
|
F8_S |
|
CHAR(1) |
|
'N' |
|
|
|
F9 |
|
CHAR(1) |
|
'N' |
|
|
|
F10 |
|
CHAR(1) |
|
'N' |
|
|
|
F11 |
|
CHAR(1) |
|
'N' |
|
|
|
F12 |
|
CHAR(1) |
|
'N' |
|
|
|
NAVEGAR |
|
CHAR(1) |
|
'N' |
|
|
|
REIMPRIMIR |
|
CHAR(1) |
|
'N' |
|
|
|
MOVIMIENTO |
|
CHAR(15) |
|
|
|
|
|
SOLO_TABLERO |
|
CHAR(1) |
|
'N' |
|
|
|
TRANSITO |
|
SMALLINT |
|
5 |
|
|
|
NIVEL |
|
SMALLINT |
|
|
|
|
|
NIVEL_INFERIOR |
|
CHAR(1) |
|
'N' |
|
|
|
MODULOS |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
|
|
OPCIONES |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
|
|
EXCLUSIONES |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
|
|
COLABORADOR |
|
CHAR(1) |
|
'N' |
|
|
|
AL_VUELO |
|
CHAR(1) |
|
'N' |
|
|
|
ROL_TRAMITE |
|
CHAR(1) |
|
'N' |
|
|
|
ROL_APROBACION |
|
CHAR(1) |
|
'N' |
|
Triggers
(There are no triggers for table PERFILES)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CODIGO |
|
|
ASC |
References
(There are no references for table PERFILES)
Referenced By
Table | Foreign Key | Fields | FK Field | Delete Rule | Update Rule |
|---|---|---|---|---|---|
CODPERFIL |
CODIGO |
NO ACTION |
CASCADE |
||
CODPERFIL |
CODIGO |
NO ACTION |
CASCADE |
Definition
CREATE TABLE PERFILES (
CODIGO CHAR(10) NOT NULL,
NOMBRE CHAR(80) NOT NULL,
INSERTAR CHAR(1) DEFAULT 'N',
EDITAR CHAR(1) DEFAULT 'N',
BORRAR CHAR(1) DEFAULT 'N',
F2_S CHAR(1) DEFAULT 'N',
F2_C CHAR(1) DEFAULT 'N',
F3_C CHAR(1) DEFAULT 'N',
F5 CHAR(1) DEFAULT 'N',
F6 CHAR(1) DEFAULT 'N',
F7 CHAR(1) DEFAULT 'N',
F8 CHAR(1) DEFAULT 'N',
F8_S CHAR(1) DEFAULT 'N',
F9 CHAR(1) DEFAULT 'N',
F10 CHAR(1) DEFAULT 'N',
F11 CHAR(1) DEFAULT 'N',
F12 CHAR(1) DEFAULT 'N',
NAVEGAR CHAR(1) DEFAULT 'N',
REIMPRIMIR CHAR(1) DEFAULT 'N',
MOVIMIENTO CHAR(15),
SOLO_TABLERO CHAR(1) DEFAULT 'N',
TRANSITO SMALLINT DEFAULT 5,
NIVEL SMALLINT,
NIVEL_INFERIOR CHAR(1) DEFAULT 'N',
MODULOS BLOB SUB_TYPE 1 SEGMENT SIZE 80,
OPCIONES BLOB SUB_TYPE 1 SEGMENT SIZE 80,
EXCLUSIONES BLOB SUB_TYPE 1 SEGMENT SIZE 80,
COLABORADOR CHAR(1) DEFAULT 'N',
AL_VUELO CHAR(1) DEFAULT 'N',
ROL_TRAMITE CHAR(1) DEFAULT 'N',
ROL_APROBACION CHAR(1) DEFAULT 'N'
);
ALTER TABLE PERFILES ADD CONSTRAINT PK_PERFILES PRIMARY KEY (CODIGO);
|
|
