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