Table Data dictionary report - ap_batch_items

Generated: 09/23/2016 2:00:45 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadictionary
Schema: public

Columns

Name	Data type	Not Null?	Primary key?	Default	Comment
id	integer	Yes	Yes	nextval('ap_batch_items_id_seq'::regclass)
batch_id	integer	No	No		Batch number - Links to ap_batches field 'id'
transaction_id	integer	No	No
pay	boolean	No	No		Being paid? TRUE = Yes FALSE = No
take_discount	boolean	No	No		Taking Discount? TRUE = Yes FALSE = No
discount	numeric(15,2)	No	No		Discount Amount
total	numeric(15,2)	No	No		Total transaction amount being paid
_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
ap_batch_items_pkey	Primary key	(id)
ap_batch_items_batch_id_fkey	Foreign key	(batch_id) REFERENCES ap_batches (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION

Report generated by pgAdmin III