Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes
Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
ID | NUMBER(10,0) | Yes | null | 1 | null |
CNTYIDFP | VARCHAR2(5 BYTE) | Yes | null | 2 | null |
GEOGRAPHIC_COMPONENT | VARCHAR2(2 BYTE) | Yes | null | 3 | null |
RENTER_OCCUPIED_HOUSING_UNITS | NUMBER(9,0) | Yes | null | 4 | null |
NO_CASH_RENT | NUMBER(9,0) | Yes | null | 5 | null |
WITH_CASH_RENT | NUMBER(9,0) | Yes | null | 6 | null |
RENT_LT_100 | NUMBER(9,0) | Yes | null | 7 | null |
RENT_100_149 | NUMBER(9,0) | Yes | null | 8 | null |
RENT_150_199 | NUMBER(9,0) | Yes | null | 9 | null |
RENT_200_249 | NUMBER(9,0) | Yes | null | 10 | null |
RENT_250_299 | NUMBER(9,0) | Yes | null | 11 | null |
RENT_300_349 | NUMBER(9,0) | Yes | null | 12 | null |
RENT_350_399 | NUMBER(9,0) | Yes | null | 13 | null |
RENT_400_449 | NUMBER(9,0) | Yes | null | 14 | null |
RENT_450_499 | NUMBER(9,0) | Yes | null | 15 | null |
RENT_500_549 | NUMBER(9,0) | Yes | null | 16 | null |
RENT_550_599 | NUMBER(9,0) | Yes | null | 17 | null |
RENT_600_649 | NUMBER(9,0) | Yes | null | 18 | null |
RENT_650_699 | NUMBER(9,0) | Yes | null | 19 | null |
RENT_700_749 | NUMBER(9,0) | Yes | null | 20 | null |
RENT_750_799 | NUMBER(9,0) | Yes | null | 21 | null |
RENT_800_899 | NUMBER(9,0) | Yes | null | 22 | null |
RENT_900_999 | NUMBER(9,0) | Yes | null | 23 | null |
RENT_1000_1249 | NUMBER(9,0) | Yes | null | 24 | null |
RENT_1250_1499 | NUMBER(9,0) | Yes | null | 25 | null |
RENT_1500_1999 | NUMBER(9,0) | Yes | null | 26 | null |
RENT_GT_1999 | NUMBER(9,0) | Yes | null | 27 | 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 |
---|
Columns
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
NAME | VALUE |
---|---|
NUM_ROWS | 12876 |
BLOCKS | 186 |
AVG_ROW_LEN | 84 |
SAMPLE_SIZE | 12876 |
LAST_ANALYZED | 15-DEC-11 |
LAST_ANALYZED_SINCE | 15-DEC-11 |
Column Statistics
TRIGGER_NAME | TRIGGER_TYPE | TRIGGER_OWNER | TRIGGERING_EVENT | STATUS | TABLE_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 15-DEC-11 |
LAST_DDL_TIME | 15-DEC-11 |
OWNER | SF3_00 |
TABLE_NAME | CO_HOUSING_GROSS_RENT |
TABLESPACE_NAME | STATE_COUNTY_00 |
CLUSTER_NAME | null |
IOT_NAME | null |
STATUS | VALID |
PCT_FREE | 0 |
PCT_USED | null |
INI_TRANS | 1 |
MAX_TRANS | 255 |
INITIAL_EXTENT | 2097152 |
NEXT_EXTENT | 1048576 |
MIN_EXTENTS | 1 |
MAX_EXTENTS | 2147483645 |
PCT_INCREASE | null |
FREELISTS | null |
FREELIST_GROUPS | null |
LOGGING | NO |
BACKED_UP | N |
NUM_ROWS | 12876 |
BLOCKS | 186 |
EMPTY_BLOCKS | 0 |
AVG_SPACE | 0 |
CHAIN_CNT | 0 |
AVG_ROW_LEN | 84 |
AVG_SPACE_FREELIST_BLOCKS | 0 |
NUM_FREELIST_BLOCKS | 0 |
DEGREE | 1 |
INSTANCES | 1 |
CACHE | N |
TABLE_LOCK | ENABLED |
SAMPLE_SIZE | 12876 |
LAST_ANALYZED | 15-DEC-11 |
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 | YES |
USER_STATS | NO |
DURATION | null |
SKIP_CORRUPT | DISABLED |
MONITORING | YES |
CLUSTER_OWNER | null |
DEPENDENCIES | DISABLED |
COMPRESSION | ENABLED |
COMPRESS_FOR | BASIC |
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 |
---|---|---|---|---|---|---|---|---|---|---|
SF3_00 | CO_HOUSE_GROSS_RENT_UIDX | UNIQUE | VALID | NORMAL | N | NO | null | NO | CNTYIDFP, GEOGRAPHIC_COMPONENT | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND |
---|---|---|---|---|---|---|---|---|
SF3_00 | CO_HOUSE_GROSS_RENT_UIDX | SF3_00 | CO_HOUSING_GROSS_RENT | CNTYIDFP | 1 | 5 | 5 | ASC |
SF3_00 | CO_HOUSE_GROSS_RENT_UIDX | SF3_00 | CO_HOUSING_GROSS_RENT | GEOGRAPHIC_COMPONENT | 2 | 2 | 2 | ASC |