pears.Semaphore
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
Used to police a locked section of code by using the db transaction mechanism. E.g. to make sure only one user is batch creating timesheets at a time.
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| Counter | integer | NULL |
Primary Key
- No primary key found in generated SQL.
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"."Semaphore" -- Table comment: Used to police a locked section of code by using the db transaction mechanism. E.g. to make sure only one user is batch creating timesheets at a time. -- Statement count: 2 CREATE TABLE "pears"."Semaphore" ( "Counter" INTEGER NULL ) GO COMMENT ON TABLE "pears"."Semaphore" IS 'Used to police a locked section of code by using the db transaction mechanism. E.g. to make sure only one user is batch creating timesheets at a time.' GO