INDEX_TAXON

INDEX_TAXON_NAME	TAXON_LIST_ITEM_KEY	CHAR	16
INDEX_TAXON_NAME	TAXON_LIST_VERSION_KEY	CHAR	16
INDEX_TAXON_NAME	ACTUAL_NAME	VARCHAR	75
INDEX_TAXON_NAME	ACTUAL_NAME_ITALIC	BIT
INDEX_TAXON_NAME	COMMON_NAME	VARCHAR	75
INDEX_TAXON_NAME	COMMON_NAME_ITALIC	BIT
INDEX_TAXON_NAME	PREFERRED_NAME	VARCHAR	75
INDEX_TAXON_NAME	PREFERRED_NAME_ITALIC	BIT
INDEX_TAXON_NAME	ABBREVIATION	VARCHAR	5
INDEX_TAXON_NAME	AUTHORITY	VARCHAR	80
INDEX_TAXON_NAME	SYSTEM_SUPPLIED_DATA	BIT
INDEX_TAXON_NAME	PREFERRED_LIST	BIT
INDEX_TAXON_NAME	Allow_Data_Entry	BIT
INDEX_TAXON_NAME	RECOMMENDED_TAXON_LIST_ITEM_KEY	CHAR	16
INDEX_TAXON_NAME	SORT_ORDER	VARCHAR	30
INDEX_TAXON_NAME	Has_Children	BIT

New columns introduced in version 6.21

INDEX_TAXON_NAME
ACTUAL_NAME_ATTRIBUTE
VARCHAR
65

INDEX_TAXON_NAME
COMMON_NAME_ATTRIBUTE
VARCHAR
65

INDEX_TAXON_NAME
PREFERRED_NAME_ATTRIBUTE
VARCHAR
65

INDEX_TAXON_NAME
PREFERRED_NAME_AUTHORITY
VARCHAR
80

Actual_Name is the name originally name used to record the taxa. Can be a common name. Common_Name is the common name which applies to the Actual_Name. Preferred_Name is the preferred name of the taxa.

INDEX_TAXON_NAME	ACTUAL_NAME_ATTRIBUTE	VARCHAR	65
INDEX_TAXON_NAME	COMMON_NAME_ATTRIBUTE	VARCHAR	65
INDEX_TAXON_NAME	PREFERRED_NAME_ATTRIBUTE	VARCHAR	65
INDEX_TAXON_NAME	PREFERRED_NAME_AUTHORITY	VARCHAR	80