pears.TempRateScript
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
Contains the code of each Rate Script - used to process shifts into rates.
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| TempRateScriptID | char(20) | NOT NULL | ||
| Description | char(50) | NOT NULL | ||
| Script | long varchar | NULL |
Primary Key
- TempRateScriptID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
| Table | Constraint | Columns | Referenced columns |
|---|---|---|---|
| pears.TempJobType | TempRateScript | TempRateScriptID | TempRateScriptID |
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."TempRateScript" -- Table comment: Contains the code of each Rate Script - used to process shifts into rates. -- Statement count: 2 CREATE TABLE "pears"."TempRateScript" ( "TempRateScriptID" CHAR(20) NOT NULL ,"Description" CHAR(50) NOT NULL ,"Script" long VARCHAR NULL ,PRIMARY KEY ("TempRateScriptID" ASC) ) GO COMMENT ON TABLE "pears"."TempRateScript" IS 'Contains the code of each Rate Script - used to process shifts into rates.' GO