This topic describes the columns in the mf_coupon_codes 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 |
| coupon_code_guid |
uniqueidentifier |
1 |
0 |
1 |
|
0 |
|
| company_guid |
uniqueidentifier |
0 |
0 |
2 |
|
0 |
|
| catalog_guid |
uniqueidentifier |
0 |
1 |
3 |
|
0 |
|
| order_guid |
uniqueidentifier |
0 |
1 |
4 |
|
0 |
|
| coupon_guid |
uniqueidentifier |
0 |
0 |
5 |
|
0 |
mf_coupons.coupon_guid |
| coupon_code_id |
varchar (100) |
0 |
1 |
6 |
|
0 |
|
| coupon_code_void |
tinyint |
0 |
0 |
7 |
|
0 |
|
| coupon_code_closed |
tinyint |
0 |
0 |
8 |
|
0 |
|
| lu_dt |
datetime |
0 |
0 |
9 |
|
0 |
|
| cr_dt |
datetime |
0 |
0 |
10 |
|
0 |
|
| lu_guid |
uniqueidentifier |
0 |
1 |
11 |
|
0 |
|
| cr_guid |
uniqueidentifier |
0 |
1 |
12 |
|
0 |
|
Return to index of tables