Database Reference
In-Depth Information
Table 4.17 Basic customer information table.
Field name
Field type
Field description
Customer_ID
Int
Customer identification number
VAT_Num
Char
VAT number
ID_Num
Char
ID number
ID_Type_Code
Int
ID type - code number
Gender_Code
Int
Gender - code number
Marital_Status_Code
Int
Marital status - code number
Children_Num
Int
Number of children
House_Owner
Bit
House owner flag
Educational_Status_Code
Int
Educational status - code number
Occupation_Code
Int
Occupation - code number
Annual_Income_Code
Int
Annual income band - code number
Birth_Date
Datetime
Date of birth
Death_Date
Datetime
Date of death, otherwise a control date
Registration_Date
Datetime
First registration date
Closure_Date
Datetime
Date of customer relationship closure
First_Name
Char
First name
Last_Name
Char
Last name
Middle_Name
Char
Middle name
Home_Street
Char
Home street name
Home_Num
Char
Home street number
Home_City
Char
Home city
Home_State
Char
Home state
Home_ZIP
Char
Home ZIP code
Home_Country
Char
Home country
Work_Company
Char
Name of company where customer works
Work_Street
Char
Work street name
Work_Num
Char
Work street number
Work_City
Char
Work city
Work_State
Char
Work state
Work_ZIP
Char
Work ZIP code
Work_Country
Char
Work country
Home_Phone
Nchar
Home phone number
Work_Phone
Nchar
Work phone number
Home_Email
Char
Home e-mail
Work_Email
Char
Work e-mail
Last_Update
Datetime
Last date of customer record update
Customer_ID is the primary key (PK) of this table.
Search WWH ::




Custom Search