Any idea why value is included in the clustered index for PostgreSQL and Sybase in the DDLs? The MySQL definition agrees with the GMOD table definition:
http://gmod.org/wiki/Chado_Sequence_Module#Table:_featureprop
MySQL:
CREATE UNIQUE INDEX uc1_featureprop ON featureprop (feature_id, type_id, rank);
PostgreSQL:
CREATE UNIQUE INDEX uc1_featureprop ON featureprop (feature_id, type_id, value, rank);
Sybase:
CREATE UNIQUE NONCLUSTERED INDEX uc1_featureprop ON featureprop (feature_id, type_id, value, rank);