Clients

identifier

varchar

255

yes

yes

Client ID

is_active

boolean

no

yes

true/false

Is client active
 The most common examples for our system for inactive clients:
Deceased clients should be tagged as 'false' as they are classed as inactive in our system. 
Clients that the business no longer wants to service should also be classed as 'false'.
Clients that have been soft deleted in the source system should be classed as 'false'.

title

varchar

40

no

no

Title

first_name

varchar

50

no

no

First name

last_name

varchar

255

no

yes

Last name

street

varchar

255

no

no

Street

postcode

varchar

20

no

no

Postcode

city

varchar

255

no

no

City

state

varchar

255

no

no

State

country

varchar

255

no

no

Country

telephone

varchar

40

no

no

Phone number

mobile_phone

varchar

40

no

no

Mobile phone

email

varchar

80

no

no

Email Address