Tabellen

PLANUNGSMATRIX

Beschreibung

Planungstabelle der DABiS Newscloud.

Felder

Trigger

Indizes

Referenziert

Referenziert von

(Es gibt keine Referenzen zu Tabelle PLANUNGSMATRIX)

Definition

CREATE TABLE PLANUNGSMATRIX (
    PMID              LONGINT_DOM NOT NULL,
    PMPTID            LONGINT_DOM,
    PMNAME            CHAR(100) NOT NULL COLLATE PXW_INTL850,
    PMVIEW            SHORTINT_DOM DEFAULT 0 NOT NULL,
    PMCOLCOUNT1       SHORTINT_DOM DEFAULT 5 NOT NULL,
    PMSTARTINDEX1     SHORTINT_DOM DEFAULT 1 NOT NULL,
    PMKUID            LONGINT_DOM,
    PMCOLCOUNT2       SHORTINT_DOM DEFAULT 5 NOT NULL,
    PMSTARTINDEX2     SHORTINT_DOM DEFAULT 0 NOT NULL,
    PMCOLCOUNT3       SHORTINT_DOM DEFAULT 5 NOT NULL,
    PMSTARTINDEX3     SHORTINT_DOM DEFAULT 0 NOT NULL,
    PMSLID            LONGINT_DOM,
    PMMSGDLGLOCATION  CHAR(13) DEFAULT '0;0' NOT NULL,
    PMMSGDLGSIZE      CHAR(13) DEFAULT '480;520' NOT NULL,
    PMATTRVISIBLE     BOOLEAN_DOM DEFAULT 0 NOT NULL,
    PMZOOMFACTOR      SINGLE_DOM DEFAULT 1.0 NOT NULL,
    PMLOCATION        CHAR(13) DEFAULT '0;0' NOT NULL,
    PMSIZE            CHAR(13) DEFAULT '800;600' NOT NULL,
    PMWINDOWSTATE     SHORTINT_DOM DEFAULT 0 NOT NULL,
    PMLAYOUT          BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    PMERSTELLDATUM    DATE_DOM DEFAULT 'NOW' NOT NULL,
    PMERSTELLER       SHORTUSERNAME_DOM DEFAULT '' NOT NULL,
    PMRECORDVERSION   LONGINT_DOM DEFAULT 1 NOT NULL
);


ALTER TABLE PLANUNGSMATRIX ADD CONSTRAINT PK_PLANUNGSMATRIX PRIMARY KEY (PMID);
ALTER TABLE PLANUNGSMATRIX ADD CONSTRAINT FK_PMKUNDE FOREIGN KEY (PMKUID) REFERENCES KUNDEN (KUID);
ALTER TABLE PLANUNGSMATRIX ADD CONSTRAINT FK_PMSCHICHTVORLAGE FOREIGN KEY (PMSLID) REFERENCES SCHICHTVORLAGEN (SLID);
ALTER TABLE PLANUNGSMATRIX ADD CONSTRAINT FK_PRESETS1 FOREIGN KEY (PMPTID) REFERENCES PRESETS (PTID);