Table Data dictionary report - timecard_entries

Generated: 9/23/2016 3:11:39 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('timecard_entries_id_seq'::regclass)
timecard_id integer No No Timecard ID links to tmecards.id
sequence smallint No No Timecard sequence number starting from 1 to the number of timecard records
code character varying(1) No No
hours numeric(5,2) No No Number of hours
rate numeric(9,2) No No Rate
amount numeric(15,2) No No Amount
account character varying(24) No No GL account
_dbversion integer No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No
_created timestamp without time zone No No
_created_by character varying(3) No No
job_no character varying(10) No No Job number
job_acct_no character varying(10) No No Job account

Constraints

Name Type Definition Comment
timecard_entries_pkey Primary key (id)

Report generated by pgAdmin III