Tables [dbo].[Appointment_Address]
Appointment address details. This table is a child table to appoinment table
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Appointment_Address_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Appointment_Address table
AddressLine1varchar(35)35NULL allowedLocation address line 1
AddressLine2varchar(35)35NULL allowedLocation address line 2
Cityvarchar(20)20NULL allowedCity of the location
Statechar(2)2NULL allowedState of the location
ZipCodechar(10)10NULL allowedLocation zip code
Countyvarchar(35)35NULL allowedCounty of the location
Countryvarchar(30)30NULL allowedCountry of the location
CreatedByID[dbo].[uniqueid]9NOT NULLUser ID of the person who is inserting the data. Link to IDX_User.ID
CreatedDTTMdatetime8NOT NULLDate and time when the data was inserted / added.