Table Data dictionary report - payroll_schedules

Generated: 9/23/2016 2:56:16 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('payroll_schedules_id_seq'::regclass)
frequency integer Yes No Frequency for the schedule. Number of times per year.
dates date[] Yes No ARRAY[]::date[] An array field containing the dates for each pay period
descriptions character varying[] Yes No ARRAY[]::character varying[] An array field containing spelled out dates for each pay period. (ie: January 01, 2016 - January 15, 2016)
_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
payroll_schedules_pkey Primary key (id)

Report generated by pgAdmin III