selectionmember Table (24)
Selection detail table Each row in a selection is represented by one record in this table. Contact_id is always filled in, person_id is optional, but if used, must point to a person belonging to the contact in contact_id.
Fields
Name Description Type Null selectionmember_id Primary key PK selection_id Owning selection FK selection contact_id Contact ID of selection member FK contact person_id Person ID of selection member, if person FK person ● targetTableNumber Table number of the target that this selection member points to TableNumber ● targetRecordId Record id of the target that this selection member points to RecordId ●
Indexes
Fields Types Description selectionmember_id PK Unique selection_id FK Index person_id FK Index contact_id, person_id FK, FK Index selection_id, contact_id FK, FK Index contact_id FK Clustered
Relationships
Replication Flags
Security Flags
Sentry controls access to items in this table using user’s Role and data rights matrix on the table’s parent.
