Columnas

Restricciones

Permisos

Estadísticas

Disparadores

Dependencias

Detalles

Particiones

Índices


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
IDGASTO NUMBER(38,0) No null 1 null
FECHA DATE No null 2 null
IDEJERCICIO NUMBER(38,0) No null 3 null
IDPARLAMENTO NUMBER(38,0) No null 4 null
IDPARLAMENTARIO NUMBER(38,0) Yes null 5 null
IDPARTIDO NUMBER(38,0) Yes null 6 null
DESCRIPCION VARCHAR2(500 BYTE) Yes null 7 null
BASEIMPONIBLE NUMBER No 0.0  8 null
IDTIPOIVA NUMBER(38,0) No null 9 null
IDCATEGORIAGASTO NUMBER(38,0) No null 10 null
IDESTADO NUMBER(38,0) No null 11 null
IDFORMAPAGO NUMBER(38,0) Yes null 12 null
IDPROVEEDOR NUMBER(38,0) Yes null 13 null
JUSTIFICACION VARCHAR2(500 BYTE) Yes null 14 null
PRESUPUESTOURL VARCHAR2(200 BYTE) Yes null 15 null
FACTURAURL VARCHAR2(200 BYTE) Yes null 16 null
CONTRATOURL VARCHAR2(200 BYTE) Yes null 17 null
CONSTRAINT_NAME CONSTRAINT_TYPE SEARCH_CONDITION R_OWNER R_TABLE_NAME R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED
GASTO_CATEGORIAGASTO_FK Foreign_Key null TFC CATEGORIAGASTO CATEGORIAGASTO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
GASTO_EJERCICIO_FK Foreign_Key null TFC EJERCICIO EJERCICIO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
GASTO_ESTADO_FK Foreign_Key null TFC ESTADO ESTADO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
GASTO_FORMAPAGO_FK Foreign_Key null TFC FORMAPAGO FORMAPAGO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
GASTO_PARLAMENTARIO_FK Foreign_Key null TFC PARLAMENTARIO PARLAMENTARIO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
GASTO_PARLAMENTO_FK Foreign_Key null TFC PARLAMENTO PARLAMENTO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
GASTO_PARTIDO_FK Foreign_Key null TFC PARTIDO PARTIDO_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
GASTO_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 TFC GASTO_PK null null
GASTO_PROVEEDOR_FK Foreign_Key null TFC PROVEEDOR PROVEEDOR_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
GASTO_TIPOIVA_FK Foreign_Key null TFC TIPOIVA TIPOIVA_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 13/06/14 null null null null
SYS_C0016061 Check "IDGASTO" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13/06/14 null null null null
SYS_C0016062 Check "FECHA" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13/06/14 null null null null
SYS_C0016063 Check "IDEJERCICIO" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13/06/14 null null null null
SYS_C0016064 Check "IDPARLAMENTO" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13/06/14 null null null null
SYS_C0016065 Check "BASEIMPONIBLE" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13/06/14 null null null null
SYS_C0016066 Check "IDTIPOIVA" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13/06/14 null null null null
SYS_C0016067 Check "IDCATEGORIAGASTO" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13/06/14 null null null null
SYS_C0016068 Check "IDESTADO" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED GENERATED NAME null null 13/06/14 null null null null



Columnas


COLUMN_NAME COLUMN_POSITION
IDCATEGORIAGASTO 1
COLUMN_NAME COLUMN_POSITION
IDEJERCICIO 1
COLUMN_NAME COLUMN_POSITION
IDESTADO 1
COLUMN_NAME COLUMN_POSITION
IDFORMAPAGO 1
COLUMN_NAME COLUMN_POSITION
IDPARLAMENTARIO 1
COLUMN_NAME COLUMN_POSITION
IDPARLAMENTO 1
COLUMN_NAME COLUMN_POSITION
IDPARTIDO 1
COLUMN_NAME COLUMN_POSITION
IDGASTO 1
COLUMN_NAME COLUMN_POSITION
IDPROVEEDOR 1
COLUMN_NAME COLUMN_POSITION
IDTIPOIVA 1
COLUMN_NAME COLUMN_POSITION
IDGASTO null
COLUMN_NAME COLUMN_POSITION
FECHA null
COLUMN_NAME COLUMN_POSITION
IDEJERCICIO null
COLUMN_NAME COLUMN_POSITION
IDPARLAMENTO null
COLUMN_NAME COLUMN_POSITION
BASEIMPONIBLE null
COLUMN_NAME COLUMN_POSITION
IDTIPOIVA null
COLUMN_NAME COLUMN_POSITION
IDCATEGORIAGASTO null
COLUMN_NAME COLUMN_POSITION
IDESTADO null
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME VALUE
NUM_ROWS null
BLOCKS null
AVG_ROW_LEN null
SAMPLE_SIZE null
LAST_ANALYZED null
LAST_ANALYZED_SINCE null



Estadísticas de Columna


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME
IDGASTO BEFORE EACH ROW TFC INSERT ENABLED GASTO




TRIGGER idGasto BEFORE
	INSERT ON Gasto FOR EACH ROW WHEN
		(
			NEW.idGasto IS NULL
		)
		BEGIN :NEW.idGasto := idGasto_SQ.NEXTVAL;
END;
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
TFC IDGASTO TRIGGER TFC GASTO TABLE
TFC PKG_COMUN PACKAGE TFC GASTO TABLE
TFC PKG_COMUN PACKAGE BODY TFC GASTO TABLE
TFC PKG_GASTO PACKAGE TFC GASTO TABLE
TFC PKG_GASTO PACKAGE BODY TFC GASTO TABLE
TFC PKG_LISTADO PACKAGE TFC GASTO TABLE
TFC PKG_LISTADO PACKAGE BODY TFC GASTO TABLE
TFC PKG_PARLAMENTARIO PACKAGE BODY TFC GASTO TABLE



Referencias


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
NAME VALUE
CREATED 13/06/14
LAST_DDL_TIME 13/06/14
OWNER TFC
TABLE_NAME GASTO
TABLESPACE_NAME TFC
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 10
PCT_USED null
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 65536
NEXT_EXTENT 1048576
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
FREELISTS null
FREELIST_GROUPS null
LOGGING YES
BACKED_UP N
NUM_ROWS null
BLOCKS null
EMPTY_BLOCKS null
AVG_SPACE null
CHAIN_CNT null
AVG_ROW_LEN null
AVG_SPACE_FREELIST_BLOCKS null
NUM_FREELIST_BLOCKS null
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE null
LAST_ANALYZED null
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS NO
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION DISABLED
COMPRESS_FOR null
DROPPED NO
COMMENTS null
PARTITION_NAME LAST_ANALYZED NUM_ROWS BLOCKS SAMPLE_SIZE HIGH_VALUE




INDEX_OWNER INDEX_NAME UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS JOIN_INDEX COLUMNS COLUMN_EXPRESSION
TFC GASTO_PK UNIQUE VALID NORMAL N NO null NO IDGASTO null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TFC GASTO_PK TFC GASTO IDGASTO 1 22 0 ASC