Appearance
dbo.ethAppointmentInstance
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethAppointmentInstance.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | AppointmentInstanceId | int | no | ||
| 2 | AppointmentDefinitionId | int | no | ||
| 3 | OccurrenceKey | nvarchar(120) | no | ||
| 4 | PrimeUserId | uniqueidentifier | yes | ||
| 5 | StartAt | datetime2(0) | no | ||
| 6 | EndAt | datetime2(0) | no | ||
| 7 | Status | nvarchar(30) | no | ||
| 8 | PrimeAppointmentId | uniqueidentifier | yes | ||
| 9 | PrimeCreateAttemptAt | datetime2(0) | yes | ||
| 10 | PrimeCreatedAt | datetime2(0) | yes | ||
| 11 | LastError | nvarchar(MAX) | yes | ||
| 12 | CreatedAt | datetime2(0) | no | ||
| 13 | UpdatedAt | datetime2(0) | no |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_ethAppointmentInstance | CLUSTERED | yes | yes | AppointmentInstanceId | ||
| UX_RecurringApptInst_Def_OccurrenceKey | NONCLUSTERED | yes | AppointmentDefinitionId, PrimeUserId | |||
| IX_RecurringApptInst_Pending | NONCLUSTERED | Status, StartAt | AppointmentDefinitionId, EndAt, PrimeAppointmentId |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.ethAppointmentInstance.PrimeAppointmentId | dbo.primeAppointments.id | low |
| dbo.ethAppointmentInstance.PrimeUserId | dbo.primeUsers.id | low |