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
GEOGRAPHIC_COMPONENT VARCHAR2(2 BYTE) Yes null 3 null
TOTAL_SPECIFY_ANCESTRY_TALLIED NUMBER(9,0) Yes null 4 null
ACADIAN_CAJUN NUMBER(9,0) Yes null 5 null
AFGHAN NUMBER(9,0) Yes null 6 null
ALBANIAN NUMBER(9,0) Yes null 7 null
ALSATIAN NUMBER(9,0) Yes null 8 null
ARAB NUMBER(9,0) Yes null 9 null
ARAB_EGYPTIAN NUMBER(9,0) Yes null 10 null
ARAB_IRAQI NUMBER(9,0) Yes null 11 null
ARAB_JORDANIAN NUMBER(9,0) Yes null 12 null
ARAB_LEBANESE NUMBER(9,0) Yes null 13 null
ARAB_MOROCCAN NUMBER(9,0) Yes null 14 null
ARAB_PALESTINIAN NUMBER(9,0) Yes null 15 null
ARAB_SYRIAN NUMBER(9,0) Yes null 16 null
ARAB_ARAB_ARABIC NUMBER(9,0) Yes null 17 null
ARAB_OTHER_ARAB NUMBER(9,0) Yes null 18 null
ARMENIAN NUMBER(9,0) Yes null 19 null
ASSYRIAN_CHALDEAN_SYRIAC NUMBER(9,0) Yes null 20 null
AUSTRALIAN NUMBER(9,0) Yes null 21 null
AUSTRIAN NUMBER(9,0) Yes null 22 null
BASQUE NUMBER(9,0) Yes null 23 null
BELGIAN NUMBER(9,0) Yes null 24 null
BRAZILIAN NUMBER(9,0) Yes null 25 null
BRITISH NUMBER(9,0) Yes null 26 null
BULGARIAN NUMBER(9,0) Yes null 27 null
CANADIAN NUMBER(9,0) Yes null 28 null
CARPATHO NUMBER(9,0) Yes null 29 null
CELTIC NUMBER(9,0) Yes null 30 null
CROATIAN NUMBER(9,0) Yes null 31 null
CYPRIOT NUMBER(9,0) Yes null 32 null
CZECH NUMBER(9,0) Yes null 33 null
CZECHOSLOVAKIAN NUMBER(9,0) Yes null 34 null
DANISH NUMBER(9,0) Yes null 35 null
DUTCH NUMBER(9,0) Yes null 36 null
EASTERN_EUROPEAN NUMBER(9,0) Yes null 37 null
ENGLISH NUMBER(9,0) Yes null 38 null
ESTONIAN NUMBER(9,0) Yes null 39 null
EUROPEAN NUMBER(9,0) Yes null 40 null
FINNISH NUMBER(9,0) Yes null 41 null
FRENCH_EXCEPT_BASQUE NUMBER(9,0) Yes null 42 null
FRENCH_CANADIAN NUMBER(9,0) Yes null 43 null
GERMAN NUMBER(9,0) Yes null 44 null
GERMAN_RUSSIAN NUMBER(9,0) Yes null 45 null
GREEK NUMBER(9,0) Yes null 46 null
GUYANESE NUMBER(9,0) Yes null 47 null
HUNGARIAN NUMBER(9,0) Yes null 48 null
ICELANDER NUMBER(9,0) Yes null 49 null
IRANIAN NUMBER(9,0) Yes null 50 null
IRISH NUMBER(9,0) Yes null 51 null
ISRAELI NUMBER(9,0) Yes null 52 null
ITALIAN NUMBER(9,0) Yes null 53 null
LATVIAN NUMBER(9,0) Yes null 54 null
LITHUANIAN NUMBER(9,0) Yes null 55 null
LUXEMBURGER NUMBER(9,0) Yes null 56 null
MACEDONIAN NUMBER(9,0) Yes null 57 null
MALTESE NUMBER(9,0) Yes null 58 null
NEW_ZEALANDER NUMBER(9,0) Yes null 59 null
NORTHERN_EUROPEAN NUMBER(9,0) Yes null 60 null
NORWEGIAN NUMBER(9,0) Yes null 61 null
PENNSYLVANIA_GERMAN NUMBER(9,0) Yes null 62 null
POLISH NUMBER(9,0) Yes null 63 null
PORTUGUESE NUMBER(9,0) Yes null 64 null
ROMANIAN NUMBER(9,0) Yes null 65 null
RUSSIAN NUMBER(9,0) Yes null 66 null
SCANDINAVIAN NUMBER(9,0) Yes null 67 null
SCOTCH_IRISH NUMBER(9,0) Yes null 68 null
SCOTTISH NUMBER(9,0) Yes null 69 null
SERBIAN NUMBER(9,0) Yes null 70 null
SLAVIC NUMBER(9,0) Yes null 71 null
SLOVAK NUMBER(9,0) Yes null 72 null
SLOVENE NUMBER(9,0) Yes null 73 null
SOVIET_UNION NUMBER(9,0) Yes null 74 null
SUBSAHARAN_AFRICAN NUMBER(9,0) Yes null 75 null
SUBSAHARA_CAPE_VERDEAN NUMBER(9,0) Yes null 76 null
SUBSAHARA_ETHIOPIAN NUMBER(9,0) Yes null 77 null
SUBSAHARA_GHANIAN NUMBER(9,0) Yes null 78 null
SUBSAHARA_KENYAN NUMBER(9,0) Yes null 79 null
SUBSAHARA_LIBERIAN NUMBER(9,0) Yes null 80 null
SUBSAHARA_NIGERIAN NUMBER(9,0) Yes null 81 null
SUBSAHARA_SENEGALESE NUMBER(9,0) Yes null 82 null
SUBSAHARA_SIERRA_LEONEAN NUMBER(9,0) Yes null 83 null
SUBSAHARA_SOMALIAN NUMBER(9,0) Yes null 84 null
SUBSAHARA_SOUTH_AFRICAN NUMBER(9,0) Yes null 85 null
SUBSAHARA_SUDANESE NUMBER(9,0) Yes null 86 null
SUBSAHARA_UGANDAN NUMBER(9,0) Yes null 87 null
SUBSAHARA_ZAIRIAN NUMBER(9,0) Yes null 88 null
SUBSAHARA_ZIMBABWEAN NUMBER(9,0) Yes null 89 null
SUBSAHARA_AFRICAN NUMBER(9,0) Yes null 90 null
SUBSAHARA_OTHER NUMBER(9,0) Yes null 91 null
SWEDISH NUMBER(9,0) Yes null 92 null
SWISS NUMBER(9,0) Yes null 93 null
TURKISH NUMBER(9,0) Yes null 94 null
UKRAINIAN NUMBER(9,0) Yes null 95 null
UNITED_STATES_AMERICAN NUMBER(9,0) Yes null 96 null
WELSH NUMBER(9,0) Yes null 97 null
WEST_INDIAN_NOT_HISPANIC NUMBER(9,0) Yes null 98 null
WEST_INDIAN_BAHAMIAN NUMBER(9,0) Yes null 99 null
WEST_INDIAN_BARBADIAN NUMBER(9,0) Yes null 100 null
WEST_INDIAN_BELIZEAN NUMBER(9,0) Yes null 101 null
WEST_INDIAN_BERMUDAN NUMBER(9,0) Yes null 102 null
BRITISH_WEST_INDIAN NUMBER(9,0) Yes null 103 null
DUTCH_WEST_INDIAN NUMBER(9,0) Yes null 104 null
WEST_INDIAN_HAITIAN NUMBER(9,0) Yes null 105 null
WEST_INDIAN_JAMAICAN NUMBER(9,0) Yes null 106 null
WEST_INDIAN_TRINIDAD_TOBAGON NUMBER(9,0) Yes null 107 null
WEST_INDIAN_US_VIRGIN_ISLAND NUMBER(9,0) Yes null 108 null
WEST_INDIAN NUMBER(9,0) Yes null 109 null
OTHER_WEST_INDIAN NUMBER(9,0) Yes null 110 null
YUGOSLAVIAN NUMBER(9,0) Yes null 111 null
OTHER_GROUPS NUMBER(9,0) Yes null 112 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 7
BLOCKS 5
AVG_ROW_LEN 371
SAMPLE_SIZE 7
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 CC_ANCESTRY_TOTAL_TALLIED
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 7
BLOCKS 5
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 371
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 7
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