Return to:
Database Reference Home Page
Return to:
Table Definitions Master List
*Table Name*
report_master
*Description*
Reporting Tables
*Schema*
CREATE TABLE report_master (
"report_id" serial
PRIMARY KEY, -- Primary Key
"company_id" integer
NOT NULL -- Company ID
REFERENCES company_master (company_id),
"created_by" varchar(16), -- Who Created this report
"request_name" varchar(75)
NOT NULL, -- Reference to PHP Report include file
"date_range_start" timestamp, -- Start of Report Date Range
"date_range_end" timestamp, -- End of Report Date Range
"overwrite_data" BOOLEAN, -- Flag to overwrite data if it exists
"last_run_date" timestamp, -- Show date when report was last run
"last_run_by" varchar(16), -- Last User to run this report
"report_data" text, -- Free-form text field to store CSV-style data
"report_output" varchar(15), -- Default Output Type. HTML|PDF (CSV is implied)
"user_report_id" integer -- References user_reports.user_repor
);
There are no comments on this page. [Add comment]