recordset

Table info.

Title Record Set
Description Record Set

Fields

Name Type Required Index Hidden On form Title Pick list Description
RecordSetID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
CollectionMemberID int(11) Collection Member Id collectionMemberId
AllPermissionLevel int(11) All Permission Level allPermissionLevel
TableID int(11)
GroupPermissionLevel int(11) Group Permission Level groupPermissionLevel
Name varchar(64) MUL Name name
OwnerPermissionLevel int(11) Owner Permission Level ownerPermissionLevel
Remarks text Remarks Additional Comments
Type tinyint(4) Type type
ModifiedByAgentID int(11) MUL
InfoRequestID int(11) MUL
SpPrincipalID int(11) MUL
SpecifyUserID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK3B38A27110D22B7A InfoRequestID
FK3B38A2714BDD9E10 SpecifyUserID
FK3B38A2715327F942 ModifiedByAgentID
FK3B38A2717699B003 CreatedByAgentID
FK3B38A27199A7381A SpPrincipalID
PRIMARY RecordSetID
RecordSetNameIDX Name

One-to-many relationships

Name Field Related table Related field
FKD0817D047F06EB5A RecordSetID recordsetitem RecordSetID

Many-to-one relationships

Name Field Related table Related field
FK3B38A27110D22B7A InfoRequestID inforequest InfoRequestID
FK3B38A2714BDD9E10 SpecifyUserID specifyuser SpecifyUserID
FK3B38A2715327F942 ModifiedByAgentID agent AgentID
FK3B38A2717699B003 CreatedByAgentID agent AgentID
FK3B38A27199A7381A SpPrincipalID spprincipal SpPrincipalID