pears.BroadbeanJobBoard
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
Old non-Hybrid tables. Contents not to be touched.
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| BroadbeanJobBoardID | char(20) | NOT NULL | ||
| Name | char(100) | NOT NULL | ||
| Code | char(100) | NOT NULL |
Primary Key
- BroadbeanJobBoardID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
| Table | Constraint | Columns | Referenced columns |
|---|---|---|---|
| pears.BroadbeanJobBoardAllocation | BroadbeanJobBoard | BroadBeanJobBoardID | BroadbeanJobBoardID |
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."BroadbeanJobBoard" -- Table comment: Old non-Hybrid tables. Contents not to be touched. -- Statement count: 2 CREATE TABLE "pears"."BroadbeanJobBoard" ( "BroadbeanJobBoardID" CHAR(20) NOT NULL ,"Name" CHAR(100) NOT NULL ,"Code" CHAR(100) NOT NULL ,PRIMARY KEY ("BroadbeanJobBoardID" ASC) ) GO COMMENT ON TABLE "pears"."BroadbeanJobBoard" IS 'Old non-Hybrid tables. Contents not to be touched.' GO