Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
TLID NUMBER(10,0) Yes null 1 null
FULLNAME VARCHAR2(100 BYTE) Yes null 2 null
NAME VARCHAR2(100 BYTE) Yes null 3 null
PREDIRABRV VARCHAR2(15 BYTE) Yes null 4 null
PRETYPABRV VARCHAR2(50 BYTE) Yes null 5 null
PREQUALABR VARCHAR2(15 BYTE) Yes null 6 null
SUFDIRABRV VARCHAR2(15 BYTE) Yes null 7 null
SUFTYPABRV VARCHAR2(50 BYTE) Yes null 8 null
SUFQUALABR VARCHAR2(15 BYTE) Yes null 9 null
PREDIR VARCHAR2(2 BYTE) Yes null 10 null
PRETYP VARCHAR2(3 BYTE) Yes null 11 null
PREQUAL VARCHAR2(2 BYTE) Yes null 12 null
SUFDIR VARCHAR2(2 BYTE) Yes null 13 null
SUFTYP VARCHAR2(3 BYTE) Yes null 14 null
SUFQUAL VARCHAR2(2 BYTE) Yes null 15 null
LINEARID VARCHAR2(22 BYTE) Yes null 16 null
MTFCC VARCHAR2(5 BYTE) Yes null 17 null
PAFLAG VARCHAR2(1 BYTE) Yes null 18 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 TIGER12 FEATNAMES
NAME VALUE
NUM_ROWS 68700352
BLOCKS 384419
AVG_ROW_LEN 58
SAMPLE_SIZE 68700352
LAST_ANALYZED 20-APR-13
LAST_ANALYZED_SINCE 20-APR-13



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 10-APR-13
LAST_DDL_TIME 18-JUN-13
OWNER TIGER12
TABLE_NAME FEATNAMES
TABLESPACE_NAME TIGER_12
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 10
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 68700352
BLOCKS 384419
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 58
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 68700352
LAST_ANALYZED 20-APR-13
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 OLTP
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
TIGER12 FEATNAMES_PK UNIQUE VALID NORMAL N NO null NO TLID, LINEARID null
TIGER12 FEATNAMES_NAME NONUNIQUE VALID NORMAL N NO null NO NAME null
TIGER12 FEATNAMES_TLID NONUNIQUE VALID NORMAL N NO null NO TLID null
TIGER12 FEATNAMES_FULLNAME NONUNIQUE VALID NORMAL N NO null NO FULLNAME null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER12 FEATNAMES_PK TIGER12 FEATNAMES TLID 1 22 0 ASC
TIGER12 FEATNAMES_PK TIGER12 FEATNAMES LINEARID 2 22 22 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER12 FEATNAMES_NAME TIGER12 FEATNAMES NAME 1 100 100 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER12 FEATNAMES_TLID TIGER12 FEATNAMES TLID 1 22 0 ASC
INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
TIGER12 FEATNAMES_FULLNAME TIGER12 FEATNAMES FULLNAME 1 100 100 ASC