Relationship Table

Relationship_Id

Integer

PK of the relationship

Name

String(255)

The name of the relationship

Status

String(255)

The status of the relationship

Salesperson_Id

Integer

FK to the owning user of the relationship

Salesperson_Name

String(100)

The name of the owning user of the relationship

Telephone_Number

String(30)

The telephone number of the relationship

Mobile_Number

String(30)

The mobile number of the relationship

Email_Address

String(100)

The email address of the relationship

External_Reference

String(50)

An arbitrary FK into another system/process

External_Reference_2

String(50)

A secondary arbitrary FK into another system/process

Caz_Error_Codes

String(512)

If the relationship is being used for a Clean Air Zone application, any error codes relevant to it

Legal_Status

String(30)

The legal form (e.g. Private Individual, LLP, Company etc) of the relationship

Email_Marketing_Flag

String(1)

Y = this relationship has a valid email marketing permission

Creation_Date

Timestamp

When this record was created

Last_Update_Date

Timestamp

When this record was last updated