> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# selectionmember table

> 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.

## 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                            | Nullable |
| ------------------- | --------------------------------------------------------------- | ------------------------------- | :------: |
| selectionmember\_id | Primary key                                                     | PK                              |    No    |
| selection\_id       | Owning selection                                                | FK [selection](./selection.mdx) |    No    |
| contact\_id         | Contact ID of selection member                                  | FK [contact](./contact.mdx)     |    No    |
| person\_id          | Person ID of selection member, if person                        | FK [person](./person.mdx)       |    Yes   |
| targetTableNumber   | Table number of the target that this selection member points to | TableNumber                     |    Yes   |
| targetRecordId      | Record id of the target that this selection member points to    | RecordId                        |    Yes   |

<img src="https://mintcdn.com/superofficeas-bugfix-ty-screen-designer-paradox/G4reeQVP-LmhQATQ/media/loc/en/database/tables/selectionmember.png?fit=max&auto=format&n=G4reeQVP-LmhQATQ&q=85&s=7ff6a2e6e19c25c8c1687493574c28dd" alt="selectionmember table relationship diagram" width="639" height="632" data-path="media/loc/en/database/tables/selectionmember.png" />

## Indexes

| Fields                     | Types  | Description |
| -------------------------- | ------ | ----------- |
| 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](./contact)     | Companies and Organizations. |
| [person](./person)       | Persons                      |
| [selection](./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.