Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Appointment_Address
Touchworks 25.2
[dbo].[Appointment_Address]
MS_Description
Appointment address details. This table is a child table to appoinment table
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Appointment_Address table
AddressLine1
varchar(35)
35
NULL allowed
Location address line 1
AddressLine2
varchar(35)
35
NULL allowed
Location address line 2
City
varchar(20)
20
NULL allowed
City of the location
State
char(2)
2
NULL allowed
State of the location
ZipCode
char(10)
10
NULL allowed
Location zip code
County
varchar(35)
35
NULL allowed
County of the location
Country
varchar(30)
30
NULL allowed
Country of the location
CreatedByID
[dbo].[uniqueid]
9
NOT NULL
User ID of the person who is inserting the data. Link to IDX_User.ID
CreatedDTTM
datetime
8
NOT NULL
Date and time when the data was inserted / added.