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 |
---|---|---|---|---|---|
VENTA_ID | NUMBER | No | null | 1 | null |
TIENDA_ID | NUMBER(38,0) | No | null | 2 | null |
COD_EAN | NUMBER(38,0) | No | null | 3 | null |
FECHA | DATE | No | null | 4 | null |
HORA | NUMBER(2,0) | No | null | 5 | null |
UD_VENDIDAS | NUMBER(38,0) | No | null | 6 | null |
CTD_TOTAL | NUMBER(38,0) | No | null | 7 | null |
PB_TOTAL | NUMBER(10,2) | No | null | 8 | null |
BN_TOTAL | NUMBER(10,2) | No | null | 9 | null |
PB_UNITARIO | NUMBER(10,2) | No | null | 10 | null |
BN_UNITARIO | NUMBER(10,2) | Yes | null | 11 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SYS_C009295 | Check | "VENTA_ID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009296 | Check | "TIENDA_ID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009297 | Check | "COD_EAN" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009298 | Check | "FECHA" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009299 | Check | "HORA" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009300 | Check | "UD_VENDIDAS" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009301 | Check | "CTD_TOTAL" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009302 | Check | "PB_TOTAL" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009303 | Check | "BN_TOTAL" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
SYS_C009304 | Check | "PB_UNITARIO" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | GENERATED NAME | null | null | 08/01/16 | null | null | null | null |
VENTAS_FK1 | Foreign_Key | null | DWH_TIENDAS_ADM | TIENDAS | TIENDAS_PK | CASCADE | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 08/01/16 | null | null | null | null |
VENTAS_FK2 | Foreign_Key | null | DWH_TIENDAS_ADM | PRODUCTOS | PRODUCTOS_PK | CASCADE | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 08/01/16 | null | null | null | null |
VENTAS_FK3 | Foreign_Key | null | DWH_TIENDAS_ADM | FECHAS | FECHAS_PK | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 08/01/16 | null | null | null | null |
VENTAS_PK | Primary_Key | null | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 08/01/16 | null | VENTAS_PK | null | null |
Columnas
COLUMN_NAME | COLUMN_POSITION |
---|---|
VENTA_ID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
TIENDA_ID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
COD_EAN | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
FECHA | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
HORA | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
UD_VENDIDAS | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CTD_TOTAL | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
PB_TOTAL | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
BN_TOTAL | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
PB_UNITARIO | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
TIENDA_ID | 1 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
COD_EAN | 1 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
FECHA | 1 |
HORA | 2 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
VENTA_ID | 1 |
TIENDA_ID | 2 |
COD_EAN | 3 |
FECHA | 4 |
HORA | 5 |
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 |
---|---|---|---|---|---|
VENTAS_TR1 | AFTER STATEMENT | DWH_TIENDAS_ADM | DELETE | ENABLED | VENTAS |
VENTAS_TR2 | BEFORE STATEMENT | DWH_TIENDAS_ADM | UPDATE | ENABLED | VENTAS |
TRIGGER VENTAS_TR1 AFTER DELETE ON VENTAS DECLARE rsp_temp STRING (200); BEGIN PKG_EST_DIR.ACTLZR_EST_GLOBAL(rsp_temp); END;
TRIGGER VENTAS_TR2 BEFORE UPDATE ON VENTAS BEGIN raise_application_error (-20003, 'No se pueden actualizar datos de ventas.'); END;
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
DWH_TIENDAS_ADM | PKG_EST_DIR | PACKAGE BODY | DWH_TIENDAS_ADM | VENTAS | TABLE |
DWH_TIENDAS_ADM | PKG_VENTA | PACKAGE BODY | DWH_TIENDAS_ADM | VENTAS | TABLE |
DWH_TIENDAS_ADM | PKG_CONSULTAS | PACKAGE BODY | DWH_TIENDAS_ADM | VENTAS | TABLE |
DWH_TIENDAS_ADM | VENTAS_TR1 | TRIGGER | DWH_TIENDAS_ADM | VENTAS | TABLE |
DWH_TIENDAS_ADM | VENTAS_TR2 | TRIGGER | DWH_TIENDAS_ADM | VENTAS | 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 |
---|
NAME | VALUE |
---|---|
CREATED | 08/01/16 |
LAST_DDL_TIME | 08/01/16 |
OWNER | DWH_TIENDAS_ADM |
TABLE_NAME | VENTAS |
TABLESPACE_NAME | DWH_TIENDAS |
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 |
---|---|---|---|---|---|---|---|---|---|---|
DWH_TIENDAS_ADM | VENTAS_PK | UNIQUE | VALID | NORMAL | N | NO | null | NO | VENTA_ID, TIENDA_ID, COD_EAN, FECHA | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND |
---|---|---|---|---|---|---|---|---|
DWH_TIENDAS_ADM | VENTAS_PK | DWH_TIENDAS_ADM | VENTAS | VENTA_ID | 1 | 22 | 0 | ASC |
DWH_TIENDAS_ADM | VENTAS_PK | DWH_TIENDAS_ADM | VENTAS | TIENDA_ID | 2 | 22 | 0 | ASC |
DWH_TIENDAS_ADM | VENTAS_PK | DWH_TIENDAS_ADM | VENTAS | COD_EAN | 3 | 22 | 0 | ASC |
DWH_TIENDAS_ADM | VENTAS_PK | DWH_TIENDAS_ADM | VENTAS | FECHA | 4 | 7 | 0 | ASC |
DWH_TIENDAS_ADM | VENTAS_PK | DWH_TIENDAS_ADM | VENTAS | HORA | 5 | 22 | 0 | ASC |