Columnas
Restricciones
Permisos
Estadísticas
Disparadores
Dependencias
Detalles
Particiones
Índices
Columnas
Restricciones
Permisos
Estadísticas
Disparadores
Dependencias
Detalles
Particiones
Índices
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
ORDENINVERSIONID | NUMBER | No | null | 1 | null |
ISINID | CHAR(12 BYTE) | No | null | 2 | null |
TIPOORDENID | CHAR(1 BYTE) | No | null | 3 | null |
TIPOORIGENID | CHAR(1 BYTE) | No | null | 4 | null |
FECHAINTRODUCCION | DATE | No | null | 5 | null |
ESTADOID | CHAR(1 BYTE) | No | null | 6 | null |
FECHAEJECUCION | DATE | No | null | 7 | null |
CANTIDAD | NUMBER(38,0) | No | null | 8 | null |
PRECIOMINIMO | NUMBER(10,3) | Yes | null | 9 | null |
EJECUCIONPRECIO | NUMBER(10,3) | Yes | null | 10 | null |
SIGNOTIPOORDEN | NUMBER(38,0) | No | null | 11 | null |
CARTERAID | NUMBER | No | null | 12 | null |
CLIENTEID | NUMBER | No | null | 13 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ORDENINVERSION_ACCION_FK | Foreign_Key | null | CARTERAINVERSION_USER | ACCION | ACCION_PK | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 11/06/15 | null | null | null | null |
ORDENINVERSION_CARTERA_FK | Foreign_Key | null | CARTERAINVERSION_USER | CARTERA | CARTERA_PK | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 11/06/15 | null | null | null | null |
ORDENINVERSION_ORDENESTADO_FK | Foreign_Key | null | CARTERAINVERSION_USER | ORDENESTADO | ORDENESTADO_PK | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 11/06/15 | null | null | null | null |
ORDENINVERSION_PK | Primary_Key | null | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 11/06/15 | null | ORDENINVERSION_PK | null | null |
ORDENINVERSION_TIPOORDEN_FK | Foreign_Key | null | CARTERAINVERSION_USER | TIPOORDEN | TIPOORDEN_PK | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 11/06/15 | null | null | null | null |
ORDENINVERSION_TIPOORIGEN_FK | Foreign_Key | null | CARTERAINVERSION_USER | TIPOORIGEN | TIPOORIGEN_PK | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 11/06/15 | null | null | null | null |
RES_CANTIDAD_ORDEN | Check | Cantidad BETWEEN 0 AND 999999999 | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022768 | Check | "ORDENINVERSIONID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022769 | Check | "ISINID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022770 | Check | "TIPOORDENID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022771 | Check | "TIPOORIGENID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022772 | Check | "FECHAINTRODUCCION" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022773 | Check | "ESTADOID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022774 | Check | "FECHAEJECUCION" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022775 | Check | "CANTIDAD" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022776 | Check | "SIGNOTIPOORDEN" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022777 | Check | "CARTERAID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
SYS_C0022778 | Check | "CLIENTEID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 11/06/15 | null | null | null | null |
Columnas
COLUMN_NAME | COLUMN_POSITION |
---|---|
ISINID | 1 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CARTERAID | 1 |
CLIENTEID | 2 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
ESTADOID | 1 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
ORDENINVERSIONID | 1 |
CARTERAID | 2 |
CLIENTEID | 3 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
TIPOORDENID | 1 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
TIPOORIGENID | 1 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CANTIDAD | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
ORDENINVERSIONID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
ISINID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
TIPOORDENID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
TIPOORIGENID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
FECHAINTRODUCCION | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
ESTADOID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
FECHAEJECUCION | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CANTIDAD | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
SIGNOTIPOORDEN | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CARTERAID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CLIENTEID | 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 |
---|---|---|---|---|---|
INSORDENINVERSION | BEFORE EACH ROW | CARTERAINVERSION_USER | INSERT OR UPDATE | ENABLED | ORDENINVERSION |
TRIGGER insOrdenInversion BEFORE INSERT OR UPDATE ON OrdenInversion FOR EACH ROW BEGIN IF :new.OrdenInversionId IS NULL THEN SELECT SEQ_OrdenInversion.NEXTVAL INTO :NEW.OrdenInversionId FROM DUAL; END IF; IF(:old.EstadoId <> 'P') THEN RAISE_APPLICATION_ERROR (-20000, 'Orden de Inversión no puede ser modificada'); END IF ; END insOrdenInversion ;
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
CARTERAINVERSION_USER | GESTIONTEST | PACKAGE | CARTERAINVERSION_USER | ORDENINVERSION | TABLE |
CARTERAINVERSION_USER | GESTIONTEST | PACKAGE BODY | CARTERAINVERSION_USER | ORDENINVERSION | TABLE |
CARTERAINVERSION_USER | CONSULTAS | PACKAGE BODY | CARTERAINVERSION_USER | ORDENINVERSION | TABLE |
CARTERAINVERSION_USER | INSORDENINVERSION | TRIGGER | CARTERAINVERSION_USER | ORDENINVERSION | 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 |
---|
NAME | VALUE |
---|---|
CREATED | 11/06/15 |
LAST_DDL_TIME | 11/06/15 |
OWNER | CARTERAINVERSION_USER |
TABLE_NAME | ORDENINVERSION |
TABLESPACE_NAME | CARTERAINVERSION |
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 |
---|---|---|---|---|---|---|---|---|---|---|
CARTERAINVERSION_USER | ORDENINVERSION_PK | UNIQUE | VALID | NORMAL | N | NO | null | NO | ORDENINVERSIONID, CARTERAID, CLIENTEID | null |
CARTERAINVERSION_USER | ORDENINVERSION__IDX | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | TIPOORDENID | null |
CARTERAINVERSION_USER | ORDENINVERSION__IDXV1 | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | ESTADOID | null |
CARTERAINVERSION_USER | ORDENINVERSION__IDXV2 | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | TIPOORIGENID | null |
CARTERAINVERSION_USER | ORDENINVERSION__IDXV3 | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | ISINID | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND |
---|---|---|---|---|---|---|---|---|
CARTERAINVERSION_USER | ORDENINVERSION_PK | CARTERAINVERSION_USER | ORDENINVERSION | ORDENINVERSIONID | 1 | 22 | 0 | ASC |
CARTERAINVERSION_USER | ORDENINVERSION_PK | CARTERAINVERSION_USER | ORDENINVERSION | CARTERAID | 2 | 22 | 0 | ASC |
CARTERAINVERSION_USER | ORDENINVERSION_PK | CARTERAINVERSION_USER | ORDENINVERSION | CLIENTEID | 3 | 22 | 0 | ASC |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND |
---|---|---|---|---|---|---|---|---|
CARTERAINVERSION_USER | ORDENINVERSION__IDX | CARTERAINVERSION_USER | ORDENINVERSION | TIPOORDENID | 1 | 1 | 1 | ASC |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND |
---|---|---|---|---|---|---|---|---|
CARTERAINVERSION_USER | ORDENINVERSION__IDXV1 | CARTERAINVERSION_USER | ORDENINVERSION | ESTADOID | 1 | 1 | 1 | ASC |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND |
---|---|---|---|---|---|---|---|---|
CARTERAINVERSION_USER | ORDENINVERSION__IDXV2 | CARTERAINVERSION_USER | ORDENINVERSION | TIPOORIGENID | 1 | 1 | 1 | ASC |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND |
---|---|---|---|---|---|---|---|---|
CARTERAINVERSION_USER | ORDENINVERSION__IDXV3 | CARTERAINVERSION_USER | ORDENINVERSION | ISINID | 1 | 12 | 12 | ASC |