Table Data dictionary report - cash_out_payment_methods

Generated: 2018-10-17 7:41:19 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Payment Methods selected in Cash Outs

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('cash_out_payment_methods_id_seq'::regclass) Unique identifier
cash_out_id integer No No Cash outs record identifier - links to cash_outs.id
payment_method_id integer No No Payment method record identifier - links to payment_methods.id
amount numeric(15,5) Yes No Payment amount for this method
_dbversion integer No No Program version that last modified this record
_created_by character varying(3) No No User initials that created this record
_created timestamp without time zone No No UTC Date and time record was created
_modified_by character varying(3) No No User initials that modified this record
_modified timestamp without time zone No No UTC Date and time record was last modified

Constraints

Name Type Definition Comment
cash_out_payment_methods_pkey Primary key (id)
cash_out_payment_methods_cash_out_id_fkey Foreign key (cash_out_id) REFERENCES public.cash_outs (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
cash_out_payment_methods_payment_method_id_fkey Foreign key (payment_method_id) REFERENCES public.payment_methods (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION

Report generated by pgAdmin3 LTS by BigSQL