Tabellen

KUNDEN

Beschreibung

Tabelle wird für die DABiS Premium Module verwendet. Produktverwaltungs Service.

Felder

Trigger

Indizes

Referenziert

Referenziert von

Definition

CREATE TABLE KUNDEN (
    KUID                    LONGINT_DOM NOT NULL,
    KUNAME                  CHAR(50) NOT NULL COLLATE PXW_INTL850,
    KUKURZNAME              CHAR(50) DEFAULT '' NOT NULL COLLATE PXW_INTL850,
    KUKTID                  LONGINT_DOM,
    KUADRESSE1              CHAR(80) DEFAULT '' NOT NULL COLLATE PXW_INTL850,
    KUADRESSE2              CHAR(80) DEFAULT '' NOT NULL COLLATE PXW_INTL850,
    KUBUNDESLAND            CHAR(50) DEFAULT '' NOT NULL COLLATE PXW_INTL850,
    KUEMAILADDRESSE         CHAR(80) DEFAULT '' NOT NULL,
    KUEMAILSUBJECT          CHAR(80) DEFAULT '' NOT NULL COLLATE PXW_INTL850,
    KUEMAILBODYTEMPLATE     CHAR(250) DEFAULT '' NOT NULL,
    KUMINFUELLZEITMS        LONGINT_DOM DEFAULT 0 NOT NULL,
    KUMAXFUELLZEITMS        LONGINT_DOM DEFAULT 0 NOT NULL,
    KUMAXWIEDERHOLUNG       LONGINT_DOM DEFAULT 0 NOT NULL,
    KUAFID                  LONGINT_DOM,
    KUISEMAILALTERNATIVE    BOOLEAN_DOM DEFAULT 0 NOT NULL,
    KUDISTRIBUTION          VARCHAR(10000) DEFAULT '' NOT NULL,
    KUDISTRIBUTIONTYP       SHORTINT_DOM DEFAULT 0 NOT NULL,
    KULOGOFILENAME          VARCHAR(1000) DEFAULT '' NOT NULL,
    KUAUDIOSHARE            VARCHAR(1000) DEFAULT '' NOT NULL,
    KUERSTELLER             SHORTUSERNAME_DOM NOT NULL,
    KURECORDVERSION         LONGINT_DOM DEFAULT 1 NOT NULL,
    KUDISTRIBUTIONCONFIGID  LONGINT_DOM
);


ALTER TABLE KUNDEN ADD CONSTRAINT PK_KUNDEN PRIMARY KEY (KUID);
ALTER TABLE KUNDEN ADD CONSTRAINT FK1_KUNDENTYPEN FOREIGN KEY (KUKTID) REFERENCES LOOKUPVALUES (LUID);
ALTER TABLE KUNDEN ADD CONSTRAINT FK1_KU_DS FOREIGN KEY (KUDISTRIBUTIONCONFIGID) REFERENCES DISTRIBUTIONCONFIGURATION (DSID);
ALTER TABLE KUNDEN ADD CONSTRAINT FK_KUNDE_AUDIOFORMAT FOREIGN KEY (KUAFID) REFERENCES AUDIOFORMAT (AFID);
CREATE INDEX IDX_KURZNAME ON KUNDEN (KUKURZNAME);