Table Data dictionary report - inventory_promo_codes

Generated: 9/23/2016 2:48:32 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('inventory_promo_codes_id_seq'::regclass)
promo_code character varying(25) No No Promo or reason code
description character varying(35) No No Description of promo code
color_text bigint No No Test color. This color wil appear on the sales order line to make it stand out.
color_back bigint No No Backround color. This color wil appear on the sales order line to make it stand out.
cumulative boolean No No Is this price 'Cumulative' with other promo codes TRUE = Yes FALSE = No
_dbversion integer No No
_created timestamp without time zone No No
_created_by character varying(3) No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No

Constraints

Name Type Definition Comment
bve_promo_code_pkey Primary key (id)

Report generated by pgAdmin III