Datadictionary OpenWave 3.1.11 |
|
Table: tbchkitwerk
Datadictionary OpenWave 3.1.11 |
|
Table: tbchkitwerk
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met checklijstitems per vergunning naar termijnbewakingsproces, inspectietraject of contactpersoon
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbchkitwerk_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyprocedure |
integer |
|
|
|
|
Foreign Key naar Tbprocedures.DnKey. |
|
|
dnkeyinspecties |
integer |
|
|
|
|
Foreign Key naar Tbprocedures.DnKey. |
|
|
dnkeychecklistnaam |
integer |
|
|
|
|
Foreign Key naar TbChecklistnaam.DnKey. |
|
|
dvgroepitem |
varchar(30) |
|
|
|
|
De checklistitems kunnen worden gegroepeerd in deze kolom. |
|
|
dvitem |
varchar(100) |
|
|
|
|
Omschrijving van checklistitems. |
|
|
dnvolgnritem |
integer |
|
|
|
|
Volgorde nummer. |
|
|
dnkeyhandhavingen |
integer |
|
|
|
|
Foreign key naar TbHandhavingen.dnkey |
|
|
dnkeybouwvergunningen |
integer |
|
|
|
|
Foreign key naar TbBouwvergunningen.dnkey |
|
|
dnkeyovvergunningen |
integer |
|
|
|
|
Foreign key naar TbOvVergunningen.dnkey |
|
|
dnkeyhorecavergunningen |
integer |
|
|
|
|
Foreign key naar TbHorecaVergunningen.dnkey |
|
|
dnkeybestemmingsplannen |
integer |
|
|
|
|
Foreign key naar TbBestemmingsplannen.dnkey |
|
|
dnkeyinfoaanvragen |
integer |
|
|
|
|
Foreign key naar TbInfoAanvragen.dnkey |
|
|
dvcodemedewerkers |
char(5) |
|
|
|
|
Foreignkey naar TbMedewerkers.dvcode |
|
|
ddlaatstemutatie |
timestamp |
|
|
|
|
Datum dat checklistitem voor het laatst is gemuteerd. |
|
|
dlstatus |
char(1) |
|
|
|
'N'::bpchar |
Aleen de waardes N = weet niet T = OK, F = Niet OK. Default de waarde N. |
|
|
dnkeycontactadressen |
integer |
|
|
|
|
Foreign key naar TbContactadressen.dnkey |
|
|
dvnotities |
varchar(2000) |
|
|
|
|
Memoveldje. LET OP! Wordt gecomprimeerd opgeslagen. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilInrichtingen.dnkey |
|
|
dnkeymilvergunningen |
integer |
|
|
|
|
Foreign key naar TbMilVergunningen.dnkey |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar tbomgvergunning.dnkey |
|
|
dnkeytermijnbewstappen |
integer |
|
|
|
|
Foreign key naar tbtermijnbewstappen.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_chkitwerk_keyterm |
dnkeytermijnbewstappen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_keycont |
dnkeycontactadressen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_keyinsp |
dnkeyinspecties |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbbest |
dnkeybestemmingsplannen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbbouw |
dnkeybouwvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbcheck |
dnkeychecklistnaam |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbhandh |
dnkeyhandhavingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbhor |
dnkeyhorecavergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbinfo |
dnkeyinfoaanvragen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbmedew |
dvcodemedewerkers |
dvcode |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbmilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbmilverg |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbomgverg |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbov |
dnkeyovvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbchkitwerk_tbproc |
dnkeyprocedure |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_chkitwerk_dlstatus |
dlstatus = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar]) |
|
cnn_chkitwerk_keyprocinsp |
((((((dnkeyprocedure IS NOT NULL) AND (dnkeyinspecties IS NULL)) AND (dnkeytermijnbewstappen IS NULL)) AND (dnkeycontactadressen IS NULL)) OR ((((dnkeyinspecties IS NOT NULL) AND (dnkeyprocedure IS NULL)) AND (dnkeytermijnbewstappen IS NULL)) AND (dnkeycontactadressen IS NULL))) OR ((((dnkeyinspecties IS NULL) AND (dnkeyprocedure IS NULL)) AND (dnkeytermijnbewstappen IS NOT NULL)) AND (dnkeycontactadressen IS NULL))) OR ((((dnkeyinspecties IS NULL) AND (dnkeytermijnbewstappen IS NULL)) AND (dnkeyprocedure IS NULL)) AND (dnkeycontactadressen IS NOT NULL)) |
|
cnn_chkitwerk_keyverg |
((((((((((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL)) OR (((((((((dnkeyovvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeyhandhavingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeybestemmingsplannen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeyomgvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeyinfoaanvragen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbchkitwerk |
btree |
|
dnkey |
|
|
|
idx_chkitwerk_codemw |
btree |
|
dvcodemedewerkers |
|
|
|
idx_chkitwerk_keybest |
btree |
|
dnkeybestemmingsplannen |
|
|
|
idx_chkitwerk_keybouw |
btree |
|
dnkeybouwvergunningen |
|
|
|
idx_chkitwerk_keycheck |
btree |
|
dnkeychecklistnaam |
|
|
|
idx_chkitwerk_keycont |
btree |
|
dnkeycontactadressen |
|
|
|
idx_chkitwerk_keyhandh |
btree |
|
dnkeyhandhavingen |
|
|
|
idx_chkitwerk_keyhor |
btree |
|
dnkeyhorecavergunningen |
|
|
|
idx_chkitwerk_keyinfo |
btree |
|
dnkeyinfoaanvragen |
|
|
|
idx_chkitwerk_keyinsp |
btree |
|
dnkeyinspecties |
|
|
|
idx_chkitwerk_keymilinr |
btree |
|
dnkeymilinrichtingen |
|
|
|
idx_chkitwerk_keymilverg |
btree |
|
dnkeymilvergunningen |
|
|
|
idx_chkitwerk_keyomgverg |
btree |
|
dnkeyomgvergunningen |
|
|
|
idx_chkitwerk_keyovverg |
btree |
|
dnkeyovvergunningen |
|
|
|
idx_chkitwerk_keyproc |
btree |
|
dnkeyprocedure |
|
|
|
idx_chkitwerk_keyterm |
btree |
|
dnkeytermijnbewstappen |
|
|
|
idx_chkitwerk_volgnr |
btree |
|
dnvolgnritem |
|
|
|
Triggers
There are no triggers for table tbchkitwerk
Rules
There are no rules for table tbchkitwerk
Referenced
There are no tables referenced by table tbchkitwerk
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyprocedure INTEGER,
dnkeyinspecties INTEGER,
dnkeychecklistnaam INTEGER,
dvgroepitem VARCHAR(30),
dvitem VARCHAR(100),
dnvolgnritem INTEGER,
dnkeyhandhavingen INTEGER,
dnkeybouwvergunningen INTEGER,
dnkeyovvergunningen INTEGER,
dnkeyhorecavergunningen INTEGER,
dnkeybestemmingsplannen INTEGER,
dnkeyinfoaanvragen INTEGER,
dvcodemedewerkers CHAR(5),
ddlaatstemutatie TIMESTAMP WITHOUT TIME ZONE,
dlstatus CHAR(1) DEFAULT 'N'::bpchar,
dnkeycontactadressen INTEGER,
dvnotities VARCHAR(2000),
dnkeymilinrichtingen INTEGER,
dnkeymilvergunningen INTEGER,
dnkeyomgvergunningen INTEGER,
dnkeytermijnbewstappen INTEGER,
CONSTRAINT cpk_tbchkitwerk PRIMARY KEY(dnkey),
CONSTRAINT chk_chkitwerk_dlstatus CHECK (dlstatus = ANY (ARRAY['T'::bpchar, 'F'::bpchar, 'N'::bpchar])),
CONSTRAINT cnn_chkitwerk_keyprocinsp CHECK (((((((dnkeyprocedure IS NOT NULL) AND (dnkeyinspecties IS NULL)) AND (dnkeytermijnbewstappen IS NULL)) AND (dnkeycontactadressen IS NULL)) OR ((((dnkeyinspecties IS NOT NULL) AND (dnkeyprocedure IS NULL)) AND (dnkeytermijnbewstappen IS NULL)) AND (dnkeycontactadressen IS NULL))) OR ((((dnkeyinspecties IS NULL) AND (dnkeyprocedure IS NULL)) AND (dnkeytermijnbewstappen IS NOT NULL)) AND (dnkeycontactadressen IS NULL))) OR ((((dnkeyinspecties IS NULL) AND (dnkeytermijnbewstappen IS NULL)) AND (dnkeyprocedure IS NULL)) AND (dnkeycontactadressen IS NOT NULL))),
CONSTRAINT cnn_chkitwerk_keyverg CHECK (((((((((((((((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL)) OR (((((((((dnkeyovvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyhandhavingen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeyhandhavingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeyhorecavergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeybestemmingsplannen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeymilinrichtingen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeymilvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeyomgvergunningen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyinfoaanvragen IS NULL))) OR (((((((((dnkeyinfoaanvragen IS NOT NULL) AND (dnkeyhandhavingen IS NULL)) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyovvergunningen IS NULL)) AND (dnkeyhorecavergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) AND (dnkeybestemmingsplannen IS NULL))),
CONSTRAINT cfk_chkitwerk_keyterm FOREIGN KEY (dnkeytermijnbewstappen)
REFERENCES public.tbtermijnbewstappen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_keycont FOREIGN KEY (dnkeycontactadressen)
REFERENCES public.tbcontactadressen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_keyinsp FOREIGN KEY (dnkeyinspecties)
REFERENCES public.tbinspecties(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbbest FOREIGN KEY (dnkeybestemmingsplannen)
REFERENCES public.tbbestemmingsplannen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbbouw FOREIGN KEY (dnkeybouwvergunningen)
REFERENCES public.tbbouwvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbcheck FOREIGN KEY (dnkeychecklistnaam)
REFERENCES public.tbchecklistnaam(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbhandh FOREIGN KEY (dnkeyhandhavingen)
REFERENCES public.tbhandhavingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbhor FOREIGN KEY (dnkeyhorecavergunningen)
REFERENCES public.tbhorecavergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbinfo FOREIGN KEY (dnkeyinfoaanvragen)
REFERENCES public.tbinfoaanvragen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbmedew FOREIGN KEY (dvcodemedewerkers)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbmilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbmilverg FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbomgverg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbov FOREIGN KEY (dnkeyovvergunningen)
REFERENCES public.tbovvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbchkitwerk_tbproc FOREIGN KEY (dnkeyprocedure)
REFERENCES public.tbprocedures(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbchkitwerk
IS 'Tabel met checklijstitems per vergunning naar termijnbewakingsproces, inspectietraject of contactpersoon';
COMMENT ON COLUMN public.tbchkitwerk.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbchkitwerk.dnkeyprocedure
IS 'Foreign Key naar Tbprocedures.DnKey.';
COMMENT ON COLUMN public.tbchkitwerk.dnkeyinspecties
IS 'Foreign Key naar Tbprocedures.DnKey.';
COMMENT ON COLUMN public.tbchkitwerk.dnkeychecklistnaam
IS 'Foreign Key naar TbChecklistnaam.DnKey.';
COMMENT ON COLUMN public.tbchkitwerk.dvgroepitem
IS 'De checklistitems kunnen worden gegroepeerd in deze kolom.';
COMMENT ON COLUMN public.tbchkitwerk.dvitem
IS 'Omschrijving van checklistitems.';
COMMENT ON COLUMN public.tbchkitwerk.dnvolgnritem
IS 'Volgorde nummer.';
COMMENT ON COLUMN public.tbchkitwerk.dnkeyhandhavingen
IS 'Foreign key naar TbHandhavingen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dnkeybouwvergunningen
IS 'Foreign key naar TbBouwvergunningen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dnkeyovvergunningen
IS 'Foreign key naar TbOvVergunningen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dnkeyhorecavergunningen
IS 'Foreign key naar TbHorecaVergunningen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dnkeybestemmingsplannen
IS 'Foreign key naar TbBestemmingsplannen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dnkeyinfoaanvragen
IS 'Foreign key naar TbInfoAanvragen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dvcodemedewerkers
IS 'Foreignkey naar TbMedewerkers.dvcode';
COMMENT ON COLUMN public.tbchkitwerk.ddlaatstemutatie
IS 'Datum dat checklistitem voor het laatst is gemuteerd.';
COMMENT ON COLUMN public.tbchkitwerk.dlstatus
IS 'Aleen de waardes N = weet niet T = OK, F = Niet OK. Default de waarde N.';
COMMENT ON COLUMN public.tbchkitwerk.dnkeycontactadressen
IS 'Foreign key naar TbContactadressen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dvnotities
IS 'Memoveldje. LET OP! Wordt gecomprimeerd opgeslagen.';
COMMENT ON COLUMN public.tbchkitwerk.dnkeymilinrichtingen
IS 'Foreign key naar TbMilInrichtingen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dnkeymilvergunningen
IS 'Foreign key naar TbMilVergunningen.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dnkeyomgvergunningen
IS 'Foreign key naar tbomgvergunning.dnkey';
COMMENT ON COLUMN public.tbchkitwerk.dnkeytermijnbewstappen
IS 'Foreign key naar tbtermijnbewstappen.dnkey';
CREATE INDEX idx_chkitwerk_codemw ON public.tbchkitwerk
USING btree (dvcodemedewerkers COLLATE pg_catalog."default");
CREATE INDEX idx_chkitwerk_keybest ON public.tbchkitwerk
USING btree (dnkeybestemmingsplannen);
CREATE INDEX idx_chkitwerk_keybouw ON public.tbchkitwerk
USING btree (dnkeybouwvergunningen);
CREATE INDEX idx_chkitwerk_keycheck ON public.tbchkitwerk
USING btree (dnkeychecklistnaam);
CREATE INDEX idx_chkitwerk_keycont ON public.tbchkitwerk
USING btree (dnkeycontactadressen);
CREATE INDEX idx_chkitwerk_keyhandh ON public.tbchkitwerk
USING btree (dnkeyhandhavingen);
CREATE INDEX idx_chkitwerk_keyhor ON public.tbchkitwerk
USING btree (dnkeyhorecavergunningen);
CREATE INDEX idx_chkitwerk_keyinfo ON public.tbchkitwerk
USING btree (dnkeyinfoaanvragen);
CREATE INDEX idx_chkitwerk_keyinsp ON public.tbchkitwerk
USING btree (dnkeyinspecties);
CREATE INDEX idx_chkitwerk_keymilinr ON public.tbchkitwerk
USING btree (dnkeymilinrichtingen);
CREATE INDEX idx_chkitwerk_keymilverg ON public.tbchkitwerk
USING btree (dnkeymilvergunningen);
CREATE INDEX idx_chkitwerk_keyomgverg ON public.tbchkitwerk
USING btree (dnkeyomgvergunningen);
CREATE INDEX idx_chkitwerk_keyovverg ON public.tbchkitwerk
USING btree (dnkeyovvergunningen);
CREATE INDEX idx_chkitwerk_keyproc ON public.tbchkitwerk
USING btree (dnkeyprocedure);
CREATE INDEX idx_chkitwerk_keyterm ON public.tbchkitwerk
USING btree (dnkeytermijnbewstappen);
CREATE INDEX idx_chkitwerk_volgnr ON public.tbchkitwerk
USING btree (dnvolgnritem);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|