====== 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