landing_page_tab Table (498)
A tab (pinned selection or entity record) on a landing pageFields
| Name | Description | Type | Nullable |
|---|---|---|---|
| landing_page_tab_id | Primary key | PK | No |
| landing_page_id | The landing page this pin belongs to | FK landing_page | No |
| table_number | Table number of the pinned record (selection table number, or entity table number such as contact, person, sale) | TableNumber | No |
| record_id | The id of the pinned record in the referenced table | RecordId | No |
| registered | Registered when | UtcDateTime | No |
| registered_associate_id | Registered by whom | FK associate | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | No |
| updatedCount | Number of updates made to this record | UShort | No |
| pinned | Whether this tab is pinned by the associate | Bool | No |
| rank | Display order of the tab within the landing page | Int | No |
| tab_type | What kind of content the tab shows (selection, entity record, or a hardcoded provider) | Enum LandingPageTabType | No |
| provider_name | Provider key for a provider tab (e.g. LastTickets, FavouriteTickets); empty for selection and entity tabs | String(128) | No |
Indexes
| Fields | Types | Description |
|---|---|---|
| landing_page_id | FK | Index |
| landing_page_id, table_number, record_id, provider_name | FK, TableNumber, RecordId, String(128) | Unique |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| landing_page | Per-associate landing page configuration for a given entity type |
Replication Flags
- None
Security Flags
- No access control via user’s Role.