selectionmember Table (24)
Some tooltip text!
• 1 minute to read
• 1 minute to read
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
| Table | Description |
|---|---|
| contact | Companies and Organizations. This table features a special record containing information about the contact that owns the database. |
| person | Persons in a company or an organizations. All associates have a corresponding person record |
| selection | Selections |
Replication Flags
- None
Security Flags
- Sentry controls access to items in this table using user's Role and data rights matrix on the table's parent.