> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/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/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/selectionmember.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=28581d86b430e106db176ca847a85d77" 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.


## Related topics

- [How to retrieve members of a specific selection using services](/en/api/search/selection/services/get-selection-members-services.md)
- [selectionmembertype](/en/api/mdo-providers/reference/selectionmembertype.md)
- [selectionmembertypev2](/en/api/mdo-providers/reference/selectionmembertypev2.md)
- [SelectionMemberStatic](/en/api/archive-providers/reference/selectionmemberstatic.md)
- [How to add members to a static selection using OSQL](/en/api/search/selection/osql/add-member-to-static-selection-osql.md)
- [How to retrieve members of a specific selection using entities](/en/api/search/selection/entity/get-selection-members-entity.md)