org.rcsb.openmms.util
Interface TypeNamesSql

All Known Implementing Classes:

DBLoader, InsertEntryBase, PanelSet, RDBEntryFoundry, SelectCategoryBase, SelectCategoryFinal, SqlWriter

public interface TypeNamesSql

Contains String definitions for the JDBC "MMS System" tables and the JDBC mappings of cif data types for various DB vendors.

Version:

1.7

Author:

Douglas S. Greer

Field Summary

static java.lang.String[]	bigBinaryType
static java.lang.String[]	bigTextType
static java.lang.String	CATEGORY_TABLE_CIF_ID_NAME
static java.lang.String	CATEGORY_TABLE_DESC_NAME
static java.lang.String	CATEGORY_TABLE_KEY_NAME
static java.lang.String	CATEGORY_TABLE_MAND_NAME
static java.lang.String	CATEGORY_TABLE_NAME
static java.lang.String	CATEGORY_TABLE_NEXT_RECORD_NAME
static java.lang.String	CATEGORY_TABLE_TABLE_NAME
static java.lang.String[]	dbTypeNames
static java.lang.String	ENTRY_CATS_CATEGORY_NAME
static java.lang.String	ENTRY_CATS_ENTRY_NAME
static java.lang.String	ENTRY_CATS_FIRST_KEY_NAME
static java.lang.String	ENTRY_CATS_LEN_NAME
static java.lang.String	ENTRY_CATS_TABLE_NAME
static java.lang.String	ENTRY_TABLE_DEP_DATE_NAME
static java.lang.String	ENTRY_TABLE_FLAG_BASE_NAME
static java.lang.String	ENTRY_TABLE_ID_NAME
static java.lang.String	ENTRY_TABLE_KEY_NAME
static java.lang.String	ENTRY_TABLE_LOAD_DATE_NAME
static java.lang.String	ENTRY_TABLE_LOAD_STATUS_NAME
static java.lang.String	ENTRY_TABLE_NAME
static java.lang.String[]	hugeTextType
static short	IBM_DB2_FLAVOR
static java.lang.String	ITEM_TABLE_CAT_INDX_NAME
static java.lang.String	ITEM_TABLE_CIF_ID_NAME
static java.lang.String	ITEM_TABLE_COLUMN_NAME
static java.lang.String	ITEM_TABLE_DESC_NAME
static java.lang.String	ITEM_TABLE_KEY_NAME
static java.lang.String	ITEM_TABLE_MAND_NAME
static java.lang.String	ITEM_TABLE_NAME
static java.lang.String	KEY_ID_SUFFIX
static java.lang.String[]	largeTableQualifier
static short	MICROSOFT_ACCESS_FLAVOR
static short	MYSQL_FLAVOR
static short	NUMBER_OF_FLAVORS
static short	ORACLE_FLAVOR
static java.lang.String	SCHEMA_PREFIX
static java.lang.String[]	smallBinaryType
static java.lang.String	STD_DATE_TYPE
static java.lang.String	STD_KEY_TYPE
static java.lang.String	STD_LINE_TYPE
static java.lang.String	STD_NAME_TYPE
static short	SYBASE_FLAVOR
static java.lang.String	SYSTEM_DATA_BANK_NAME
static java.lang.String	SYSTEM_MODEL_ID_NAME
static java.lang.String	SYSTEM_REVISION_NUMBER_NAME
static java.lang.String	SYSTEM_TABLE_NAME
static java.lang.String	SYSTEM_VERSION_NAME
static int	TYPE_FIELD_LEN

Field Detail

STD_KEY_TYPE

public static final java.lang.String STD_KEY_TYPE

See Also:

Constant Field Values

STD_NAME_TYPE

public static final java.lang.String STD_NAME_TYPE

See Also:

Constant Field Values

STD_LINE_TYPE

public static final java.lang.String STD_LINE_TYPE

See Also:

Constant Field Values

STD_DATE_TYPE

public static final java.lang.String STD_DATE_TYPE

See Also:

Constant Field Values

SCHEMA_PREFIX

public static final java.lang.String SCHEMA_PREFIX

See Also:

Constant Field Values

KEY_ID_SUFFIX

public static final java.lang.String KEY_ID_SUFFIX

See Also:

Constant Field Values

SYSTEM_TABLE_NAME

public static final java.lang.String SYSTEM_TABLE_NAME

See Also:

Constant Field Values

SYSTEM_DATA_BANK_NAME

public static final java.lang.String SYSTEM_DATA_BANK_NAME

See Also:

Constant Field Values

SYSTEM_VERSION_NAME

public static final java.lang.String SYSTEM_VERSION_NAME

See Also:

Constant Field Values

SYSTEM_MODEL_ID_NAME

public static final java.lang.String SYSTEM_MODEL_ID_NAME

See Also:

Constant Field Values

SYSTEM_REVISION_NUMBER_NAME

public static final java.lang.String SYSTEM_REVISION_NUMBER_NAME

See Also:

Constant Field Values

ENTRY_TABLE_NAME

public static final java.lang.String ENTRY_TABLE_NAME

See Also:

Constant Field Values

ENTRY_TABLE_KEY_NAME

public static final java.lang.String ENTRY_TABLE_KEY_NAME

See Also:

Constant Field Values

ENTRY_TABLE_ID_NAME

public static final java.lang.String ENTRY_TABLE_ID_NAME

See Also:

Constant Field Values

ENTRY_TABLE_DEP_DATE_NAME

public static final java.lang.String ENTRY_TABLE_DEP_DATE_NAME

See Also:

Constant Field Values

ENTRY_TABLE_LOAD_DATE_NAME

public static final java.lang.String ENTRY_TABLE_LOAD_DATE_NAME

See Also:

Constant Field Values

ENTRY_TABLE_LOAD_STATUS_NAME

public static final java.lang.String ENTRY_TABLE_LOAD_STATUS_NAME

See Also:

Constant Field Values

ENTRY_TABLE_FLAG_BASE_NAME

public static final java.lang.String ENTRY_TABLE_FLAG_BASE_NAME

See Also:

Constant Field Values

CATEGORY_TABLE_NAME

public static final java.lang.String CATEGORY_TABLE_NAME

See Also:

Constant Field Values

CATEGORY_TABLE_KEY_NAME

public static final java.lang.String CATEGORY_TABLE_KEY_NAME

See Also:

Constant Field Values

CATEGORY_TABLE_TABLE_NAME

public static final java.lang.String CATEGORY_TABLE_TABLE_NAME

See Also:

Constant Field Values

CATEGORY_TABLE_CIF_ID_NAME

public static final java.lang.String CATEGORY_TABLE_CIF_ID_NAME

See Also:

Constant Field Values

CATEGORY_TABLE_DESC_NAME

public static final java.lang.String CATEGORY_TABLE_DESC_NAME

See Also:

Constant Field Values

CATEGORY_TABLE_MAND_NAME

public static final java.lang.String CATEGORY_TABLE_MAND_NAME

See Also:

Constant Field Values

CATEGORY_TABLE_NEXT_RECORD_NAME

public static final java.lang.String CATEGORY_TABLE_NEXT_RECORD_NAME

See Also:

Constant Field Values

ITEM_TABLE_NAME

public static final java.lang.String ITEM_TABLE_NAME

See Also:

Constant Field Values

ITEM_TABLE_KEY_NAME

public static final java.lang.String ITEM_TABLE_KEY_NAME

See Also:

Constant Field Values

ITEM_TABLE_COLUMN_NAME

public static final java.lang.String ITEM_TABLE_COLUMN_NAME

See Also:

Constant Field Values

ITEM_TABLE_CIF_ID_NAME

public static final java.lang.String ITEM_TABLE_CIF_ID_NAME

See Also:

Constant Field Values

ITEM_TABLE_CAT_INDX_NAME

public static final java.lang.String ITEM_TABLE_CAT_INDX_NAME

See Also:

Constant Field Values

ITEM_TABLE_DESC_NAME

public static final java.lang.String ITEM_TABLE_DESC_NAME

See Also:

Constant Field Values

ITEM_TABLE_MAND_NAME

public static final java.lang.String ITEM_TABLE_MAND_NAME

See Also:

Constant Field Values

ENTRY_CATS_TABLE_NAME

public static final java.lang.String ENTRY_CATS_TABLE_NAME

See Also:

Constant Field Values

ENTRY_CATS_ENTRY_NAME

public static final java.lang.String ENTRY_CATS_ENTRY_NAME

See Also:

Constant Field Values

ENTRY_CATS_CATEGORY_NAME

public static final java.lang.String ENTRY_CATS_CATEGORY_NAME

See Also:

Constant Field Values

ENTRY_CATS_FIRST_KEY_NAME

public static final java.lang.String ENTRY_CATS_FIRST_KEY_NAME

See Also:

Constant Field Values

ENTRY_CATS_LEN_NAME

public static final java.lang.String ENTRY_CATS_LEN_NAME

See Also:

Constant Field Values

NUMBER_OF_FLAVORS

public static final short NUMBER_OF_FLAVORS

See Also:

Constant Field Values

ORACLE_FLAVOR

public static final short ORACLE_FLAVOR

See Also:

Constant Field Values

SYBASE_FLAVOR

public static final short SYBASE_FLAVOR

See Also:

Constant Field Values

MYSQL_FLAVOR

public static final short MYSQL_FLAVOR

See Also:

Constant Field Values

IBM_DB2_FLAVOR

public static final short IBM_DB2_FLAVOR

See Also:

Constant Field Values

MICROSOFT_ACCESS_FLAVOR

public static final short MICROSOFT_ACCESS_FLAVOR

See Also:

Constant Field Values

dbTypeNames

public static final java.lang.String[] dbTypeNames

TYPE_FIELD_LEN

public static final int TYPE_FIELD_LEN

See Also:

Constant Field Values

bigTextType

public static final java.lang.String[] bigTextType

hugeTextType

public static final java.lang.String[] hugeTextType

smallBinaryType

public static final java.lang.String[] smallBinaryType

bigBinaryType

public static final java.lang.String[] bigBinaryType

largeTableQualifier

public static final java.lang.String[] largeTableQualifier