Diagrams


Table

Booking Item

Fields

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

Keys

# Fields
0 Item ID Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field