Diagrams


Table

Registered Absence

Fields

# Name Type
1 Capacity Type (Capacity Type) Option
2 No. (No.) Code20
3 Date (Date) Date
4 Starting Time (Starting Time) Time
5 Ending Time (Ending Time) Time
6 Description (Description) Text50
7 Capacity (Capacity) Decimal
8 Starting Date-Time (Starting Date-Time) DateTime
9 Ending Date-Time (Ending Date-Time) DateTime

Keys

# Fields
0 Capacity Type,No.,Date,Starting Time,Ending Time (Capacity Type,No.,Date,Starting Time,Ending Time) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) Machine Center No. (No.) 1..n
No. (No.) Work Center No. (No.) 1..n

Table Relations From Other Tables

From Table From Field