Table Data dictionary report - vendor_pricing

Generated: 9/23/2016 3:13:31 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('vendor_pricing_id_seq'::regclass)
uom character varying(10) No No Unit of measure
price numeric(15,5) No No Price
starting_date date No No Start date
ending_date date No No End Date
auto_erase_record boolean No No Remove record when expired TRUE = Yes FALSE = No
vendor_code character varying(34) No No Vendor's code
min_ord_qty numeric(15,5) No No Minimum quantity to purchase
updatecostprice boolean No No Update vendor cost when receioving PO
_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
inventory_id integer Yes No ID deom table inventory.id
vendor_id integer Yes No ID from table vendor.id
break_qty numeric(11)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Quantity break level
break_qty_price numeric(15,5)[] Yes No '{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}'::numeric[] Quantity break price

Constraints

Name Type Definition Comment
vendor_pricing_pkey Primary key (id)
vendor_pricing_inventory_id_fkey Foreign key (inventory_id) REFERENCES inventory (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
vendor_pricing_vendor_id_fkey Foreign key (vendor_id) REFERENCES vendors (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE

Report generated by pgAdmin III