pears.BroadbeanRejectionReason
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
List of reasons candidates not imported from BB
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| BroadbeanRejectionReasonID | char(20) | NOT NULL | ||
| Name | char(100) | NOT NULL | ||
| SortOrder | smallint | NULL | ||
| Defunct | tinyint | NULL | 0 |
Primary Key
- BroadbeanRejectionReasonID
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"."BroadbeanRejectionReason" -- Table comment: List of reasons candidates not imported from BB -- Statement count: 2 CREATE TABLE "pears"."BroadbeanRejectionReason" ( "BroadbeanRejectionReasonID" CHAR(20) NOT NULL ,"Name" CHAR(100) NOT NULL ,"SortOrder" SMALLINT NULL ,"Defunct" tinyint NULL DEFAULT 0 ,PRIMARY KEY ("BroadbeanRejectionReasonID" ASC) ) GO COMMENT ON TABLE "pears"."BroadbeanRejectionReason" IS 'List of reasons candidates not imported from BB' GO