====== pears.IQacYear ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Description =====
REDUNDANT
===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **YearID** | char(12) | NOT NULL | | |
| StartDate | date | NOT NULL | | |
| EndDate | date | NOT NULL | | |
===== Primary Key =====
* YearID
===== 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"."IQacYear"
-- Table comment: REDUNDANT
-- Statement count: 2
CREATE TABLE "pears"."IQacYear" (
"YearID" char(12) NOT NULL
,"StartDate" date NOT NULL
,"EndDate" date NOT NULL
,PRIMARY KEY ("YearID" ASC)
)
go
COMMENT ON TABLE "pears"."IQacYear" IS
'REDUNDANT'
go