
CREATE TABLE AkariIrc (
        objID           INTEGER           NOT NULL,
        objName         CHARACTER(14)     NOT NULL,
        ra              DOUBLE PRECISION  NOT NULL,
        dec             DOUBLE PRECISION  NOT NULL,
        posErrMj        REAL              NOT NULL,
        posErrMi        REAL              NOT NULL,
        posErrPA        REAL              NOT NULL,
        flux_09         REAL,
        flux_18         REAL,
        fErr_09         REAL,
        fErr_18         REAL,
        fQual_09        SMALLINT          NOT NULL,
        fQual_18        SMALLINT          NOT NULL,
        flags_09        SMALLINT,
        flags_18        SMALLINT,
        nScanC_09       SMALLINT          NOT NULL,
        nScanC_18       SMALLINT          NOT NULL,
        nScanP_09       SMALLINT          NOT NULL,
        nScanP_18       SMALLINT          NOT NULL,
        mConf_09        SMALLINT,
        mConf_18        SMALLINT,
        nDens_09        SMALLINT,
        nDens_18        SMALLINT,
        extended_09     SMALLINT,
        extended_18     SMALLINT,
        meanAB_09       REAL,
        meanAB_18       REAL,
        nDataPos        SMALLINT          NOT NULL,
        nData_09        SMALLINT          NOT NULL,
        nData_18        SMALLINT          NOT NULL,
        cx              DOUBLE PRECISION  NOT NULL,
        cy              DOUBLE PRECISION  NOT NULL,
        cz              DOUBLE PRECISION  NOT NULL,
        CONSTRAINT akariirc_pkey PRIMARY KEY(objid),
        CONSTRAINT akariirc_objname UNIQUE(objname)
);

