spsymbiotainstance

Table info.

Title Sp Symbiota Instance
Description Sp Symbiota Instance

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpSymbiotaInstanceID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
CollectionMemberID int(11) Collection Member Id collectionMemberId
Description varchar(256) Description description
InstanceName varchar(256) Instance Name instanceName
LastCacheBuild datetime Last Cache Build lastCacheBuild
LastPull datetime Last Pull lastPull
LastPush datetime Last Push lastPush
Remarks text Remarks remarks
SymbiotaKey varchar(128) Symbiota Key symbiotaKey
SchemaMappingID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK95FF2A005327F942 ModifiedByAgentID
FK95FF2A007699B003 CreatedByAgentID
FK95FF2A00E5409F21 SchemaMappingID
PRIMARY SpSymbiotaInstanceID

Many-to-one relationships

Name Field Related table Related field
FK95FF2A005327F942 ModifiedByAgentID agent AgentID
FK95FF2A007699B003 CreatedByAgentID agent AgentID
FK95FF2A00E5409F21 SchemaMappingID spexportschemamapping SpExportSchemaMappingID