====== pears.tempaidcompany ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Description ===== Next time sheet number for each TempAid payroll company. ===== Columns ===== ^ Column ^ Type ^ Null ^ Default ^ Comment ^ | **companyid** | char(1) | NOT NULL | | | | nexttimesheet | integer | NULL | | | ===== Primary Key ===== * companyid ===== Foreign Keys ===== * No outgoing foreign keys found. ===== Referenced By ===== * No incoming foreign keys found. ===== Indexes ===== * No indexes found. ===== Triggers ===== * No triggers found. ===== Original SQL ===== -- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."tempaidcompany" -- Table comment: Next time sheet number for each TempAid payroll company. -- Statement count: 2 CREATE TABLE "pears"."tempaidcompany" ( "companyid" char(1) NOT NULL ,"nexttimesheet" integer NULL ,PRIMARY KEY ("companyid" ASC) ) go COMMENT ON TABLE "pears"."tempaidcompany" IS 'Next time sheet number for each TempAid payroll company.' go