id |
integer |
Yes |
Yes |
nextval('inventory_promo_codes_id_seq'::regclass) |
Unique identifier |
promo_code |
character varying(25) |
No |
No |
|
Promotional or price reason code |
description |
character varying(35) |
No |
No |
|
Description of promotion |
color_text |
bigint |
No |
No |
|
Text colour code for display |
color_back |
bigint |
No |
No |
|
Backround colour code for display |
cumulative |
boolean |
No |
No |
|
Price 'Cumulative' flag; FALSE = No TRUE = Yes |
_dbversion |
integer |
No |
No |
|
Program version that last modified this record |
_created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
_created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
_modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
_modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |