Diagrams


Table

Booking Item

Fields

# Name Type
1 Item ID (Item ID) Text50
2 Start (Start) DateTime
3 End (End) DateTime
4 Duration (Duration) Integer
5 Notes (Notes) Text250
7 Price Type (Price Type) Integer
8 Price (Price) Decimal
10 Service ID (Service ID) Text50
11 Service Name (Service Name) Text50
13 Customer ID (Customer ID) Text50
14 Customer Email (Customer Email) Text80
15 Customer Name (Customer Name) Text50
17 Invoiced (Invoiced) Boolean
18 Invoice Link (Invoice Link) Text250
19 Invoice No. (Invoice No.) Code20
21 Paid (Paid) Boolean

Keys

# Fields
0 Item ID (Item ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field