Here is what the CenterResources table looks like now, is this correct?
Field Type Attributes Null Default Extra Action
resourceID int(11) UNSIGNED No auto_increment
centerID int(11) UNSIGNED Yes NULL
resourceGroup varchar(50) Yes NULL
typeID int(11) UNSIGNED Yes NULL
resource varchar(100) Yes NULL
description text Yes NULL
Indexes:
Keyname Type Cardinality Action Field
resourceID UNIQUE 8 Edit Drop resourceID
centerID INDEX None Edit Drop centerID
typeID INDEX None Edit Drop typeID