Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
TFID NUMBER(10,0) Yes null 1 null
STATEFP00 VARCHAR2(2 BYTE) Yes null 2 null
COUNTYFP00 VARCHAR2(3 BYTE) Yes null 3 null
TRACTCE00 VARCHAR2(6 BYTE) Yes null 4 null
BLKGRPCE00 VARCHAR2(1 BYTE) Yes null 5 null
BLOCKCE00 VARCHAR2(4 BYTE) Yes null 6 null
COUSUBFP00 VARCHAR2(5 BYTE) Yes null 7 null
SUBMCDFP00 VARCHAR2(5 BYTE) Yes null 8 null
CONCTYFP00 VARCHAR2(5 BYTE) Yes null 9 null
PLACEFP00 VARCHAR2(5 BYTE) Yes null 10 null
AIANNHFP00 VARCHAR2(5 BYTE) Yes null 11 null
AIANNHCE00 VARCHAR2(4 BYTE) Yes null 12 null
COMPTYP00 VARCHAR2(1 BYTE) Yes null 13 null
TRSUBFP00 VARCHAR2(5 BYTE) Yes null 14 null
TRSUBCE00 VARCHAR2(3 BYTE) Yes null 15 null
ANRCFP00 VARCHAR2(5 BYTE) Yes null 16 null
ELSDLEA00 VARCHAR2(5 BYTE) Yes null 17 null
SCSDLEA00 VARCHAR2(5 BYTE) Yes null 18 null
UNSDLEA00 VARCHAR2(5 BYTE) Yes null 19 null
UACE VARCHAR2(5 BYTE) Yes null 20 null
CD108FP VARCHAR2(2 BYTE) Yes null 21 null
SLDUST00 VARCHAR2(3 BYTE) Yes null 22 null
SLDLST00 VARCHAR2(3 BYTE) Yes null 23 null
VTDST00 VARCHAR2(6 BYTE) Yes null 24 null
ZCTA5CE00 VARCHAR2(5 BYTE) Yes null 25 null
TAZCE00 VARCHAR2(6 BYTE) Yes null 26 null
UGACE00 VARCHAR2(5 BYTE) Yes null 27 null
PUMA5CE00 VARCHAR2(5 BYTE) Yes null 28 null
STATEFP10 VARCHAR2(2 BYTE) Yes null 29 null
COUNTYFP10 VARCHAR2(3 BYTE) Yes null 30 null
TRACTCE10 VARCHAR2(6 BYTE) Yes null 31 null
BLKGRPCE10 VARCHAR2(1 BYTE) Yes null 32 null
BLOCKCE10 VARCHAR2(4 BYTE) Yes null 33 null
COUSUBFP10 VARCHAR2(5 BYTE) Yes null 34 null
SUBMCDFP10 VARCHAR2(5 BYTE) Yes null 35 null
CONCTYFP10 VARCHAR2(5 BYTE) Yes null 36 null
PLACEFP10 VARCHAR2(5 BYTE) Yes null 37 null
AIANNHFP10 VARCHAR2(5 BYTE) Yes null 38 null
AIANNHCE10 VARCHAR2(4 BYTE) Yes null 39 null
COMPTYP10 VARCHAR2(1 BYTE) Yes null 40 null
TRSUBFP10 VARCHAR2(5 BYTE) Yes null 41 null
TRSUBCE10 VARCHAR2(3 BYTE) Yes null 42 null
ANRCFP10 VARCHAR2(5 BYTE) Yes null 43 null
TTRACTCE10 VARCHAR2(6 BYTE) Yes null 44 null
TBLKGPCE10 VARCHAR2(1 BYTE) Yes null 45 null
ELSDLEA10 VARCHAR2(5 BYTE) Yes null 46 null
SCSDLEA10 VARCHAR2(5 BYTE) Yes null 47 null
UNSDLEA10 VARCHAR2(5 BYTE) Yes null 48 null
UACE10 VARCHAR2(5 BYTE) Yes null 49 null
CD111FP VARCHAR2(2 BYTE) Yes null 50 null
SLDUST10 VARCHAR2(3 BYTE) Yes null 51 null
SLDLST10 VARCHAR2(3 BYTE) Yes null 52 null
VTDST10 VARCHAR2(6 BYTE) Yes null 53 null
ZCTA5CE10 VARCHAR2(5 BYTE) Yes null 54 null
TAZCE10 VARCHAR2(6 BYTE) Yes null 55 null
UGACE10 VARCHAR2(5 BYTE) Yes null 56 null
PUMA5CE10 VARCHAR2(5 BYTE) Yes null 57 null
CSAFP10 VARCHAR2(3 BYTE) Yes null 58 null
CBSAFP10 VARCHAR2(5 BYTE) Yes null 59 null
METDIVFP10 VARCHAR2(5 BYTE) Yes null 60 null
CNECTAFP10 VARCHAR2(3 BYTE) Yes null 61 null
NECTAFP10 VARCHAR2(5 BYTE) Yes null 62 null
NCTADVFP10 VARCHAR2(5 BYTE) Yes null 63 null
LWFLAG VARCHAR2(1 BYTE) Yes null 64 null
OFFSET VARCHAR2(1 BYTE) Yes null 65 null
ATOTAL NUMBER(10,0) Yes null 66 null
INTPTLAT VARCHAR2(11 BYTE) Yes null 67 null
INTPTLON VARCHAR2(12 BYTE) Yes null 68 null
GEOM SDO_GEOMETRY Yes null 69 null
G3785 SDO_GEOMETRY Yes null 70 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
SELECT CENSUS_EDITOR NO TIGER10 FACES
SELECT DOI NO TIGER10 FACES
SELECT GOOGLE_USER NO TIGER10 FACES
SELECT NATIONAL_ATLAS NO TIGER10 FACES
SELECT PRECINCT NO TIGER10 FACES
SELECT TIGER12 NO TIGER10 FACES
NAME VALUE
NUM_ROWS 22851438
BLOCKS 2385911
AVG_ROW_LEN 295
SAMPLE_SIZE 22851438
LAST_ANALYZED 09-DEC-12
LAST_ANALYZED_SINCE 09-DEC-12



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 29-JUN-13
OWNER TIGER10
TABLE_NAME FACES
TABLESPACE_NAME TIGER_10
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 0
PCT_USED null
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 4294967296
NEXT_EXTENT 1048576
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
FREELISTS null
FREELIST_GROUPS null
LOGGING NO
BACKED_UP N
NUM_ROWS 22851438
BLOCKS 2385911
EMPTY_BLOCKS 2697
AVG_SPACE 585
CHAIN_CNT 0
AVG_ROW_LEN 295
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 22851438
LAST_ANALYZED 09-DEC-12
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
TIGER10 FACES_PK UNIQUE VALID NORMAL N NO null NO TFID null
TIGER10 FACES_SDX NONUNIQUE VALID DOMAIN N NO null NO GEOM null
TIGER10 FACES_SC00 NONUNIQUE VALID FUNCTION-BASED NORMAL N NO ENABLED NO SYS_NC00077$ "STATEFP00"||"COUNTYFP00"
TIGER10 FACES_SC10 NONUNIQUE VALID FUNCTION-BASED NORMAL N NO ENABLED NO SYS_NC00078$ "STATEFP10"||"COUNTYFP10"
TIGER10 FACES_BLKGP00 NONUNIQUE VALID FUNCTION-BASED NORMAL N NO ENABLED NO SYS_NC00081$ "STATEFP00"||"COUNTYFP00"||"TRACTCE00"||"BLKGRPCE00"
TIGER10 FACES_BLKGP10 NONUNIQUE VALID FUNCTION-BASED NORMAL N NO ENABLED NO SYS_NC00082$ "STATEFP10"||"COUNTYFP10"||"TRACTCE10"||"BLKGRPCE10"
TIGER10 FACES_BLOCK00 NONUNIQUE VALID FUNCTION-BASED NORMAL N NO ENABLED NO SYS_NC00083$ "STATEFP00"||"COUNTYFP00"||"TRACTCE00"||"BLOCKCE00"
TIGER10 FACES_BLOCK10 NONUNIQUE VALID FUNCTION-BASED NORMAL N NO ENABLED NO SYS_NC00084$ "STATEFP10"||"COUNTYFP10"||"TRACTCE10"||"BLOCKCE10"
TIGER10 FACES_TRACT00 NONUNIQUE VALID FUNCTION-BASED NORMAL N NO ENABLED NO SYS_NC00079$ "STATEFP00"||"COUNTYFP00"||"TRACTCE00"
TIGER10 FACES_TRACT10 NONUNIQUE VALID FUNCTION-BASED NORMAL N NO ENABLED NO SYS_NC00080$ "STATEFP10"||"COUNTYFP10"||"TRACTCE10"




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_PK TIGER10 FACES TFID 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_SDX TIGER10 FACES GEOM 1 1 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_SC00 TIGER10 FACES SYS_NC00077$ 1 5 5 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_SC10 TIGER10 FACES SYS_NC00078$ 1 5 5 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_BLKGP00 TIGER10 FACES SYS_NC00081$ 1 12 12 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_BLKGP10 TIGER10 FACES SYS_NC00082$ 1 12 12 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_BLOCK00 TIGER10 FACES SYS_NC00083$ 1 15 15 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_BLOCK10 TIGER10 FACES SYS_NC00084$ 1 15 15 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_TRACT00 TIGER10 FACES SYS_NC00079$ 1 11 11 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 FACES_TRACT10 TIGER10 FACES SYS_NC00080$ 1 11 11 ASC