| Tables |
|
VIGENCIAS
| Tables |
|
VIGENCIAS
Description
MAESTRO DE VIGENCIAS CON GENERADORES
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CODIGO |
|
CHAR(4) |
|
|
|
|
|
NOMBRE |
|
CHAR(100) |
|
|
|
|
|
GENERADOR_PARCIAL |
|
CHAR(31) |
|
|
|
|
|
GENERADOR_PPTO |
|
CHAR(31) |
|
|
|
|
|
GENERADOR_CDP |
|
CHAR(31) |
|
|
|
|
|
GENERADOR_RP |
|
CHAR(31) |
|
|
|
|
|
ACTIVA |
|
CHAR(1) |
|
'N' |
|
Triggers
(There are no triggers for table VIGENCIAS)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CODIGO |
|
|
ASC |
References
(There are no references for table VIGENCIAS)
Referenced By
(There are no tables referenced by table VIGENCIAS)
Definition
CREATE TABLE VIGENCIAS (
CODIGO CHAR(4) NOT NULL,
NOMBRE CHAR(100) NOT NULL,
GENERADOR_PARCIAL CHAR(31),
GENERADOR_PPTO CHAR(31),
GENERADOR_CDP CHAR(31),
GENERADOR_RP CHAR(31),
ACTIVA CHAR(1) DEFAULT 'N'
);
ALTER TABLE VIGENCIAS ADD CONSTRAINT PK_VIGENCIAS PRIMARY KEY (CODIGO);
|
|
