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 |