Enumeration

This table defines enumerated types used within the warehouse. Essentially,
enumerated types correspond to small controlled vocabularies used within
one or more warehouse tables. For example, the warehouse table Feature has
a column called Type that defines the type of a feature within an amino-acid
sequence. Examples types might be PHOS-RESIDUE and GLY-RESIDUE, corresponding
to residues in a protein that are phosphorylated and glycosylated, respectively.
Those two enumerated types would be entered into two rows of this Enumeration
table. Note that in some cases the values actually stored in the warehouse
table are numbers, which are stored in the Value field of the Enumeration table
as the string form of that number.

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
TableName	VARCHAR	VARCHAR2(50)	No	Table this enumeration is used in
ColumnName	VARCHAR	VARCHAR2(50)	No	Column this enumeration is used in
Value	VARCHAR	VARCHAR2(50)	No	The enumeration value
Meaning	TEXT	VARCHAR2(4000)	Yes	A comment describing its meaning

Referenced By

None.

Other Constraints

None.

Indexes

Name	Columns
ENUM_TBNAME	TABLENAME
ENUM_COLNAME	COLUMNNAME
ENUM_VALUE	VALUE