Diagrams

Table

Shop Calendar Working Days

DynamicsDocs.comShop Calendar Working Days«Table 99000752»Shop Calendar Working DaysShop Calendar Code [PK,NN]Day; [Monday,Tuesday,Wednesday,Thursda...Work Shift Code [PK,NN]Starting Time [PK]Ending Time [PK]«Table 99000751»Shop CalendarCode [PK,NN]Description«Table 99000750»Work ShiftCode [PK,NN]Description<Shop Calendar Code><Work Shift Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Shop Calendar Code (Shop Calendar Code) Code10 NotBlank: Yes
2 Day (Day) Option
3 Work Shift Code (Work Shift Code) Code10 NotBlank: Yes
4 Starting Time (Starting Time) Time
5 Ending Time (Ending Time) Time

Keys

# Fields
0 Shop Calendar Code,Day,Starting Time,Ending Time,Work Shift Code (Shop Calendar Code,Day,Starting Time,Ending Time,Work Shift Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Shop Calendar Code (Shop Calendar Code) Shop Calendar Code (Code) 1..n
Work Shift Code (Work Shift Code) Work Shift Code (Code) 1..n

Table Relations From Other Tables

From Table From Field