Diagrams


Table

Booking Item

Fields

# Name Type
1 Id (Id) Text250
2 Start Date (Start Date) BLOB [Json]
3 End Date (End Date) BLOB [Json]
4 Duration (Duration) Duration
5 Notes (Notes) Text250
7 Price Type (Price Type) Option
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
18 Invoice Link (Invoice Link) Text250
19 Invoice No. (Invoice No.) Text250
21 Invoice Status (Invoice Status) Option
22 Invoice Amount (Invoice Amount) Decimal
23 Invoice Date (Invoice Date) BLOB [Json]

Keys

# Fields
0 Id (Id) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field