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 |