PCC_view_ods_contact

437343 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ContactID int 4 null
Gender char 1 √ null
Title varchar 15 √ null
FirstName varchar 50 null
LastName varchar 50 null
Address1 varchar 35 √ null
Address2 varchar 35 √ null
Address3 varchar 35 √ null
HomePhone varchar 35 √ null
CellPhone varchar 35 √ null
OfficePhone varchar 35 √ null
OfficeExtension varchar 5 √ null
OtherPhone varchar 35 √ null
PagePhone varchar 35 √ null
Fax varchar 35 √ null
City varchar 50 √ null
State varchar 3 √ null
ZipCode varchar 15 √ null
country varchar 254 √ null
Email varchar 75 √ null
DateOfBirth datetime 16,3 √ null
CreatedDate datetime 16,3 null
Revisiondate datetime 16,3 √ null
Deleted char 1 √ null
AVA_insdate datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_PCC_view_ods_contact Primary key Asc ContactID

Diagram producer might be missing

No diagrams were produced please see application output for any errors