This topic describes the columns in the mf_customer_types table.
- Column Name: The name of the column.
- Data Type: The data type of the column.
- Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
- Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
- Column ID: The ID number of the column.
- Comment: Text describing the column data (if available).
- Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
- Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.
| Column Name |
Data Type |
Primary Key |
Is Nullable |
Column ID |
Comment |
Reference Count |
Reference To |
|---|
| customer_type_id |
smallint |
1 |
0 |
1 |
|
1 |
|
| customer_type_label |
varchar (50) |
0 |
1 |
2 |
|
0 |
|
| customer_type_label_short |
varchar (50) |
0 |
1 |
3 |
|
0 |
|
| customer_type_description |
varchar (255) |
0 |
1 |
4 |
|
0 |
|
Return to index of tables