Contact Person

Contact Person Storage

ContactPerson Table
Column Name DataType Nullable Notes
CPE_ContactPersonID INT no IDENTITY, Primary Key
CPE_FigureID INT yes Foreign Key to Figure
CPE_Prefix NVARCHAR(10) yes
CPE_FirstName NVARCHAR(50) yes Indexed
CPE_MiddleName NVARCHAR(25) yes
CPE_LastName NVARCHAR(50) yes Indexed
CPE_Suffix NVARCHAR(10) yes

Last edited Feb 8, 2011 at 5:54 AM by mbulava, version 1

Comments

No comments yet.