Show pageOld revisionsBacklinksExport to PDFFold/unfold allBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== pears.Semaphore ====== <WRAP center round info> Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. </WRAP> ===== 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 ===== <code 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 </code> database/tables/pears_semaphore.txt Last modified: 2026/08/07 19:24by 127.0.0.1