Table Index

SpotWIDSpotIdMethodWID

Associates a spot with a SpotIdMethod,
which is the method used to identify a spot with a particular protein.
A spot can be identified as a particular protein by multiple methods,
so this table supports this many-to-many relationship.

Columns

Column MySQL Type Oracle Type Nullable Description
SpotWID BIGINT NUMBER No Reference to the2A Spot record.
SpotIdMethodWID BIGINT NUMBER No Reference to the method that was used to identify a spot as a
particular protein.

Referenced By

None.

Other Constraints

None.

Indexes

Name Columns
SM_SPOTWID_IDMETHWID SpotWID, SpotIdMethodWID
SM_IDMETHWID_SPOTWID SpotIdMethodWID, SpotWID