Datadictionary OpenWave 3.1.25
 Previous topic Chapter index Next topic

Table: tbmilalert

 

 

Schema

public

 

Owner

waveuser005

 

Tablespace

(default)

 

Descriptions

Tabel met waarschuwingen bij inrichting, handhaving-, apv/overig- of omgevingszaak bijv pas op: grote hond.

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

dnkey

serial

 

nextval('tbmilalert_dnkey_seq'::regclass)

Primary key.

 

 

ddmelddatum

timestamp

 

 

 

now()

Datum dat alert voor het eerst is genoteerd (of voor het laatst bevestigd).

 

 

dvmelding

varchar(60)

 

 

 

 

De waarschuwing zelf. Bijvoorbeeld groete bijtende hond.

 

dvcodemedewerker

char(5)

 

 

 

 

Foreign key naar tbmedewerkers.dvcode. Wie heeft alert gemaakt of voor het laatst bevestigd

 

 

dvomschrijving

varchar(2000)

 

 

 

 

Omschrijving van de waarschuwing.

 

dnkeymilinrichtingen

integer

 

 

 

 

Foreign key naar tbmilinrichtingen.dnkey.

 

dnkeyhandhaving

integer

 

 

 

 

Foreign key naar tbhandhavingen.dnkey

 

dnkeyovvergunningen

integer

 

 

 

 

Foreign key naar tbovvergunningen.dnkey

 

dnkeyomgvergunning

integer

 

 

 

 

Foreign key naar tbomgvergunning.dnkey

 

dnkeyhorecavergunning

integer

 

 

 

 

Foreign key naar tbhorecavergunningen.dnkey

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

cfk_milalert_codemw

dvcodemedewerker

public.tbmedewerkers

dvcode

Set Null

No Action

 

Immediate

 

cfk_milalert_keyhandhav

dnkeyhandhaving

public.tbhandhavingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_milalert_keyhorverg

dnkeyhorecavergunning

public.tbhorecavergunningen

dnkey

Cascade

No Action

 

Immediate

 

cfk_milalert_keymilinr

dnkeymilinrichtingen

public.tbmilinrichtingen

dnkey

Cascade

No Action

 

Immediate

 

cfk_milalert_keyomgverg

dnkeyomgvergunning

public.tbomgvergunning

dnkey

Cascade

No Action

 

Immediate

 

cfk_milalert_keyovverg

dnkeyovvergunningen

public.tbovvergunningen

dnkey

Cascade

No Action

 

Immediate

 

 

Check Constraints

Name

Condition

Description

cnn_milalert_keymilinr

((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhandhaving IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunning IS NULL) AND (dnkeyhorecavergunning IS NULL)) OR ((dnkeyhandhaving IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunning IS NULL) AND (dnkeyhorecavergunning IS NULL)) OR ((dnkeyovvergunningen IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyhandhaving IS NULL) AND (dnkeyomgvergunning IS NULL) AND (dnkeyhorecavergunning IS NULL)) OR ((dnkeyomgvergunning IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyhandhaving IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunning IS NULL)) OR ((dnkeyhorecavergunning IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyhandhaving IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunning IS NULL))

 

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cpk_tbmilalert

btree

 

dnkey

 

 

Triggers

There are no triggers for table tbmilalert

 

Rules

There are no rules for table tbmilalert

 

Policies

There are no policies for table tbmilalert

 

Referenced

There are no tables referenced by table tbmilalert

 

Properties

Property

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.tbmilalert (
 dnkey SERIAL,
 ddmelddatum TIMESTAMP WITHOUT TIME ZONE DEFAULT now(),
 dvmelding VARCHAR(60),
 dvcodemedewerker CHAR(5),
 dvomschrijving VARCHAR(2000),
 dnkeymilinrichtingen INTEGER,
 dnkeyhandhaving INTEGER,
 dnkeyovvergunningen INTEGER,
 dnkeyomgvergunning INTEGER,
 dnkeyhorecavergunning INTEGER,
 CONSTRAINT cpk_tbmilalert PRIMARY KEY(dnkey),
 CONSTRAINT cnn_milalert_keymilinr CHECK (((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhandhaving IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunning IS NULL) AND (dnkeyhorecavergunning IS NULL)) OR ((dnkeyhandhaving IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunning IS NULL) AND (dnkeyhorecavergunning IS NULL)) OR ((dnkeyovvergunningen IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyhandhaving IS NULL) AND (dnkeyomgvergunning IS NULL) AND (dnkeyhorecavergunning IS NULL)) OR ((dnkeyomgvergunning IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyhandhaving IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyhorecavergunning IS NULL)) OR ((dnkeyhorecavergunning IS NOT NULL) AND (dnkeymilinrichtingen IS NULL) AND (dnkeyhandhaving IS NULL) AND (dnkeyovvergunningen IS NULL) AND (dnkeyomgvergunning IS NULL))),
 CONSTRAINT cfk_milalert_codemw FOREIGN KEY (dvcodemedewerker)
   REFERENCES public.tbmedewerkers(dvcode)
   ON DELETE SET NULL
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_milalert_keyhandhav FOREIGN KEY (dnkeyhandhaving)
   REFERENCES public.tbhandhavingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_milalert_keyhorverg FOREIGN KEY (dnkeyhorecavergunning)
   REFERENCES public.tbhorecavergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_milalert_keymilinr FOREIGN KEY (dnkeymilinrichtingen)
   REFERENCES public.tbmilinrichtingen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_milalert_keyomgverg FOREIGN KEY (dnkeyomgvergunning)
   REFERENCES public.tbomgvergunning(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT cfk_milalert_keyovverg FOREIGN KEY (dnkeyovvergunningen)
   REFERENCES public.tbovvergunningen(dnkey)
   ON DELETE CASCADE
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) ;

COMMENT ON TABLE public.tbmilalert
IS 'Tabel met waarschuwingen bij inrichting, handhaving-, apv/overig- of omgevingszaak bijv pas op: grote hond.';

COMMENT ON COLUMN public.tbmilalert.dnkey
IS 'Primary key.';

COMMENT ON COLUMN public.tbmilalert.ddmelddatum
IS 'Datum dat alert voor het eerst is genoteerd (of voor het laatst bevestigd).';

COMMENT ON COLUMN public.tbmilalert.dvmelding
IS 'De waarschuwing zelf. Bijvoorbeeld groete bijtende hond.';

COMMENT ON COLUMN public.tbmilalert.dvcodemedewerker
IS 'Foreign key naar tbmedewerkers.dvcode. Wie heeft alert gemaakt of voor het laatst bevestigd';

COMMENT ON COLUMN public.tbmilalert.dvomschrijving
IS 'Omschrijving van de waarschuwing.';

COMMENT ON COLUMN public.tbmilalert.dnkeymilinrichtingen
IS 'Foreign key naar tbmilinrichtingen.dnkey.';

COMMENT ON COLUMN public.tbmilalert.dnkeyhandhaving
IS 'Foreign key naar tbhandhavingen.dnkey';

COMMENT ON COLUMN public.tbmilalert.dnkeyovvergunningen
IS 'Foreign key naar tbovvergunningen.dnkey';

COMMENT ON COLUMN public.tbmilalert.dnkeyomgvergunning
IS 'Foreign key naar tbomgvergunning.dnkey';

COMMENT ON COLUMN public.tbmilalert.dnkeyhorecavergunning
IS 'Foreign key naar tbhorecavergunningen.dnkey'; 


This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13
 Previous topic Chapter index Next topic