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
CONCITIDFP VARCHAR2(7 BYTE) Yes null 2 null
RACE VARCHAR2(3 BYTE) Yes null 3 null
HISPANIC_LATINO VARCHAR2(1 BYTE) Yes null 4 null
MIN_AGE NUMBER(3,0) Yes null 5 null
TOTAL NUMBER(9,0) Yes null 6 null
TOTAL_ONE NUMBER(9,0) Yes null 7 null
WHT NUMBER(9,0) Yes null 8 null
BLK NUMBER(9,0) Yes null 9 null
IND NUMBER(9,0) Yes null 10 null
ASN NUMBER(9,0) Yes null 11 null
PAC NUMBER(9,0) Yes null 12 null
OTH NUMBER(9,0) Yes null 13 null
MIX NUMBER(9,0) Yes null 14 null
TOTAL_TWO NUMBER(9,0) Yes null 15 null
WHT_BLK NUMBER(9,0) Yes null 16 null
WHT_IND NUMBER(9,0) Yes null 17 null
WHT_ASN NUMBER(9,0) Yes null 18 null
WHT_PAC NUMBER(9,0) Yes null 19 null
WHT_OTH NUMBER(9,0) Yes null 20 null
BLK_IND NUMBER(9,0) Yes null 21 null
BLK_ASN NUMBER(9,0) Yes null 22 null
BLK_PAC NUMBER(9,0) Yes null 23 null
BLK_OTH NUMBER(9,0) Yes null 24 null
IND_ASN NUMBER(9,0) Yes null 25 null
IND_PAC NUMBER(9,0) Yes null 26 null
IND_OTH NUMBER(9,0) Yes null 27 null
ASN_PAC NUMBER(9,0) Yes null 28 null
ASN_OTH NUMBER(9,0) Yes null 29 null
PAC_OTH NUMBER(9,0) Yes null 30 null
TOTAL_THREE NUMBER(9,0) Yes null 31 null
WHT_BLK_IND NUMBER(9,0) Yes null 32 null
WHT_BLK_ASN NUMBER(9,0) Yes null 33 null
WHT_BLK_PAC NUMBER(9,0) Yes null 34 null
WHT_BLK_OTH NUMBER(9,0) Yes null 35 null
WHT_IND_ASN NUMBER(9,0) Yes null 36 null
WHT_IND_PAC NUMBER(9,0) Yes null 37 null
WHT_IND_OTH NUMBER(9,0) Yes null 38 null
WHT_ASN_PAC NUMBER(9,0) Yes null 39 null
WHT_ASN_OTH NUMBER(9,0) Yes null 40 null
WHT_PAC_OTH NUMBER(9,0) Yes null 41 null
BLK_IND_ASN NUMBER(9,0) Yes null 42 null
BLK_IND_PAC NUMBER(9,0) Yes null 43 null
BLK_IND_OTH NUMBER(9,0) Yes null 44 null
BLK_ASN_PAC NUMBER(9,0) Yes null 45 null
BLK_ASN_OTH NUMBER(9,0) Yes null 46 null
BLK_PAC_OTH NUMBER(9,0) Yes null 47 null
IND_ASN_PAC NUMBER(9,0) Yes null 48 null
IND_ASN_OTH NUMBER(9,0) Yes null 49 null
IND_PAC_OTH NUMBER(9,0) Yes null 50 null
ASN_PAC_OTH NUMBER(9,0) Yes null 51 null
TOTAL_FOUR NUMBER(9,0) Yes null 52 null
WHT_BLK_IND_ASN NUMBER(9,0) Yes null 53 null
WHT_BLK_IND_PAC NUMBER(9,0) Yes null 54 null
WHT_BLK_IND_OTH NUMBER(9,0) Yes null 55 null
WHT_BLK_ASN_PAC NUMBER(9,0) Yes null 56 null
WHT_BLK_ASN_OTH NUMBER(9,0) Yes null 57 null
WHT_BLK_PAC_OTH NUMBER(9,0) Yes null 58 null
WHT_IND_ASN_PAC NUMBER(9,0) Yes null 59 null
WHT_IND_ASN_OTH NUMBER(9,0) Yes null 60 null
WHT_IND_PAC_OTH NUMBER(9,0) Yes null 61 null
WHT_ASN_PAC_OTH NUMBER(9,0) Yes null 62 null
BLK_IND_ASN_PAC NUMBER(9,0) Yes null 63 null
BLK_IND_ASN_OTH NUMBER(9,0) Yes null 64 null
BLK_IND_PAC_OTH NUMBER(9,0) Yes null 65 null
BLK_ASN_PAC_OTH NUMBER(9,0) Yes null 66 null
IND_ASN_PAC_OTH NUMBER(9,0) Yes null 67 null
TOTAL_FIVE NUMBER(9,0) Yes null 68 null
WHT_BLK_IND_ASN_PAC NUMBER(9,0) Yes null 69 null
WHT_BLK_IND_ASN_OTH NUMBER(9,0) Yes null 70 null
WHT_BLK_IND_PAC_OTH NUMBER(9,0) Yes null 71 null
WHT_BLK_ASN_PAC_OTH NUMBER(9,0) Yes null 72 null
WHT_IND_ASN_PAC_OTH NUMBER(9,0) Yes null 73 null
BLK_IND_ASN_PAC_OTH NUMBER(9,0) Yes null 74 null
TOTAL_SIX NUMBER(9,0) Yes null 75 null
WHT_BLK_IND_ASN_PAC_OTH NUMBER(9,0) Yes null 76 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 42
BLOCKS 5
AVG_ROW_LEN 214
SAMPLE_SIZE 42
LAST_ANALYZED 13-DEC-11
LAST_ANALYZED_SINCE 13-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 13-DEC-11
LAST_DDL_TIME 13-DEC-11
OWNER SF1_00
TABLE_NAME CC_RACE
TABLESPACE_NAME CONCITY_00
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 0
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 NO
BACKED_UP N
NUM_ROWS 42
BLOCKS 5
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 214
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 42
LAST_ANALYZED 13-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