Table Data dictionary report - cash_outs

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

Table for Cash Outs performed

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('cash_outs_id_seq'::regclass) Unique identifier
till character varying(20) No No User entered till name or description
start_date date Yes No Start date for reports
end_date date Yes No End date for reports
coin_count smallint[] Yes No Number of coins for each denomination, .01, .05, .10, .25, .50, 1.00, 2.00
coin_total numeric(15,2)[] Yes No Value of coins for each denomination, .01, .05, .10, .25, .50, 1.00, 2.00
bill_count smallint[] Yes No Number of bills for each denomination, $1.00, $2.00, $5.00, $10.00, $20.00, $50.00, $100.00
bill_total numeric(15,2)[] Yes No Value of bills for each denomination, $1.00, $2.00, $5.00, $10.00, $20.00, $50.00, $100.00
other_total numeric(15,5) Yes No Total value of all other payment methods
_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
location character varying(24) No No Location for this Cash count

Constraints

Name Type Definition Comment
cash_outs_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL