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
STATEFP10 VARCHAR2(2 BYTE) Yes null 3 null
CNTYIDFP00 VARCHAR2(5 BYTE) Yes null 4 null
CNTYIDFP10 VARCHAR2(5 BYTE) Yes null 5 null
CTIDFP00 VARCHAR2(11 BYTE) Yes null 6 null
CTIDFP10 VARCHAR2(11 BYTE) Yes null 7 null
BKGPIDFP00 VARCHAR2(12 BYTE) Yes null 8 null
BKGPIDFP10 VARCHAR2(12 BYTE) Yes null 9 null
BLKIDFP00 VARCHAR2(15 BYTE) Yes null 10 null
BLKIDFP10 VARCHAR2(15 BYTE) Yes null 11 null
AIANNHID00 VARCHAR2(5 BYTE) Yes null 12 null
AIANNHID10 VARCHAR2(5 BYTE) Yes null 13 null
ANRCFP00 VARCHAR2(5 BYTE) Yes null 14 null
ANRCFP10 VARCHAR2(5 BYTE) Yes null 15 null
CBSAFP10 VARCHAR2(5 BYTE) Yes null 16 null
CD108IDFP VARCHAR2(7 BYTE) Yes null 17 null
CD111IDFP VARCHAR2(7 BYTE) Yes null 18 null
CNECTAFP10 VARCHAR2(3 BYTE) Yes null 19 null
CCTYIDFP00 VARCHAR2(7 BYTE) Yes null 20 null
CCTYIDFP10 VARCHAR2(7 BYTE) Yes null 21 null
COSBIDFP00 VARCHAR2(10 BYTE) Yes null 22 null
CSAFP10 VARCHAR2(3 BYTE) Yes null 23 null
ELSDIDFP00 VARCHAR2(7 BYTE) Yes null 24 null
ELSDIDFP10 VARCHAR2(7 BYTE) Yes null 25 null
METDIVFP10 VARCHAR2(5 BYTE) Yes null 26 null
NECTAFP10 VARCHAR2(5 BYTE) Yes null 27 null
NCTADVFP10 VARCHAR2(5 BYTE) Yes null 28 null
PLCIDFP00 VARCHAR2(7 BYTE) Yes null 29 null
PLCIDFP10 VARCHAR2(7 BYTE) Yes null 30 null
SCSDIDFP00 VARCHAR2(7 BYTE) Yes null 31 null
SCSDIDFP10 VARCHAR2(7 BYTE) Yes null 32 null
SLDLIDFP00 VARCHAR2(5 BYTE) Yes null 33 null
SLDLIDFP10 VARCHAR2(5 BYTE) Yes null 34 null
SLDUIDFP00 VARCHAR2(5 BYTE) Yes null 35 null
SLDUIDFP10 VARCHAR2(5 BYTE) Yes null 36 null
SMCDIDFP00 VARCHAR2(15 BYTE) Yes null 37 null
SMCDIDFP10 VARCHAR2(15 BYTE) Yes null 38 null
TAZIDFP00 VARCHAR2(11 BYTE) Yes null 39 null
TAZIDFP10 VARCHAR2(11 BYTE) Yes null 40 null
TRSUBID00 VARCHAR2(7 BYTE) Yes null 41 null
TRSUBID10 VARCHAR2(7 BYTE) Yes null 42 null
UACE00 VARCHAR2(5 BYTE) Yes null 43 null
UACE10 VARCHAR2(5 BYTE) Yes null 44 null
UGACE00 VARCHAR2(5 BYTE) Yes null 45 null
UGACE10 VARCHAR2(5 BYTE) Yes null 46 null
UNSDIDFP00 VARCHAR2(7 BYTE) Yes null 47 null
UNSDIDFP10 VARCHAR2(7 BYTE) Yes null 48 null
VTDIDFP00 VARCHAR2(11 BYTE) Yes null 49 null
VTDIDFP10 VARCHAR2(11 BYTE) Yes null 50 null
ZCTA5CE00 VARCHAR2(5 BYTE) Yes null 51 null
ZCTA5CE10 VARCHAR2(5 BYTE) Yes null 52 null
LWFLAG VARCHAR2(1 BYTE) Yes null 53 null
OFFSET VARCHAR2(1 BYTE) Yes null 54 null
GEOM SDO_GEOMETRY Yes null 55 null
G3785 SDO_GEOMETRY Yes null 56 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 RFACES
SELECT MTCROWD NO TIGER10 RFACES
SELECT TIGER12 NO TIGER10 RFACES
NAME VALUE
NUM_ROWS 22831197
BLOCKS 2675291
AVG_ROW_LEN 292
SAMPLE_SIZE 22831197
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 14-DEC-11
LAST_DDL_TIME 29-JUN-13
OWNER TIGER10
TABLE_NAME RFACES
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 22831197
BLOCKS 2675291
EMPTY_BLOCKS 2981
AVG_SPACE 633
CHAIN_CNT 0
AVG_ROW_LEN 292
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 22831197
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 RFACES_PK UNIQUE VALID NORMAL N NO null NO TFID null
TIGER10 RFACES_GEOM_SDX NONUNIQUE VALID DOMAIN N NO null NO GEOM null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 RFACES_PK TIGER10 RFACES TFID 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER10 RFACES_GEOM_SDX TIGER10 RFACES GEOM 1 1 0 ASC