Diagrams


Table

Registered Absence

Fields

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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field