dbo.ethAppointmentDefinition

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.ethAppointmentDefinition.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	AppointmentDefinitionId	int	no
2	IsActive	bit	no
3	JobId	uniqueidentifier	no
4	AppointmentTypeId	uniqueidentifier	no
5	Notes	nvarchar(MAX)	no
6	TimeZoneId	nvarchar(100)	no
7	Start	datetime2(0)	no
8	DurationMinutes	int	no
10	Interval	int	no
11	ByDayOfWeekMask	int	yes
12	DayOfMonth	int	yes
13	WeekOfMonth	int	yes
14	DayOfWeek	int	yes
15	EndsAt	date	yes
16	EndsAfterCount	int	yes
17	HorizonDays	int	no
18	NextGenerationAt	datetime2(0)	yes
19	CreatedAt	datetime2(0)	no
20	UpdatedAt	datetime2(0)	no
21	Frequency	int	no

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_ethApptDef	CLUSTERED	yes	yes	AppointmentDefinitionId
IX_ethApptDef_Active	NONCLUSTERED			IsActive	JobId

Relationships (inferred)

From	To	Confidence
dbo.ethAppointmentDefinitionUser.AppointmentDefinitionId	dbo.ethAppointmentDefinition.AppointmentDefinitionId	medium

Referenced by

Procedures: dbo.spEthAppointmentDefinitionsGet