Datadictionary OpenWave 3.1.25 |
|
Table: tbhhafrondsoortzaak
Datadictionary OpenWave 3.1.25 |
|
Table: tbhhafrondsoortzaak
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tbhandhafronding en de soorten zaak tbsoorthhzaak
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhhafrondsoortzaak_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcodehandhafrond |
char(1) |
|
|
|
|
Foreign key naar tbhandhafronding.dvcode. |
|
|
dnkeysoorthhzaak |
integer |
|
|
|
|
Foreign key naar tbsoorthhzaak.dnkey |
|
|
dnkeybesluittype |
integer |
|
|
|
|
Foreign key naar tbbesluittypes.dnkey |
|
|
dnbewaartermijndagen |
integer |
|
|
|
|
Bewaartermijn in dagen bij deze combinatie zaaktype en resultaattype |
|
|
dvbewarenvanaf |
char(1) |
|
|
|
'A'::bpchar |
A of E. Bewaartermijn geldt vanaf (A)anvraag cq startdatum of vanaf (E)inddatum |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_hhafrondsrtzk_keybesltype |
dnkeybesluittype |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbhhafrondsrtzk_codeafr |
dvcodehandhafrond |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbhhafrondsrtzk_keysrtzk |
dnkeysoorthhzaak |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_hafrndsrtzk_dvbewarenvanaf |
dvbewarenvanaf = ANY (ARRAY['A'::bpchar, 'E'::bpchar]) |
|
cnn_hafrndsrtzk_dvbewarenvanaf |
dvbewarenvanaf IS NOT NULL |
|
cnn_tbhhafrondsrtzk_codeafrond |
dvcodehandhafrond IS NOT NULL |
|
cnn_tbhhafrondsrtzk_keysrtzk |
dnkeysoorthhzaak IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhhafrondsoortzaak |
btree |
|
dnkey |
|
|
|
idu_hhafrondsrtzk_keysrtzk |
btree |
|
dnkeysoorthhzaak, dvcodehandhafrond |
|
|
|
Triggers
There are no triggers for table tbhhafrondsoortzaak
Rules
There are no rules for table tbhhafrondsoortzaak
Policies
There are no policies for table tbhhafrondsoortzaak
Referenced
There are no tables referenced by table tbhhafrondsoortzaak
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcodehandhafrond CHAR(1),
dnkeysoorthhzaak INTEGER,
dnkeybesluittype INTEGER,
dnbewaartermijndagen INTEGER,
dvbewarenvanaf CHAR(1) DEFAULT 'A'::bpchar,
CONSTRAINT cpk_tbhhafrondsoortzaak PRIMARY KEY(dnkey),
CONSTRAINT chk_hafrndsrtzk_dvbewarenvanaf CHECK (dvbewarenvanaf = ANY (ARRAY['A'::bpchar, 'E'::bpchar])),
CONSTRAINT cnn_hafrndsrtzk_dvbewarenvanaf CHECK (dvbewarenvanaf IS NOT NULL),
CONSTRAINT cnn_tbhhafrondsrtzk_codeafrond CHECK (dvcodehandhafrond IS NOT NULL),
CONSTRAINT cnn_tbhhafrondsrtzk_keysrtzk CHECK (dnkeysoorthhzaak IS NOT NULL),
CONSTRAINT cfk_hhafrondsrtzk_keybesltype FOREIGN KEY (dnkeybesluittype)
REFERENCES public.tbbesluittypes(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhhafrondsrtzk_codeafr FOREIGN KEY (dvcodehandhafrond)
REFERENCES public.tbhandhafronding(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhhafrondsrtzk_keysrtzk FOREIGN KEY (dnkeysoorthhzaak)
REFERENCES public.tbsoorthhzaak(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhhafrondsoortzaak
IS 'Koppeltabel tbhandhafronding en de soorten zaak tbsoorthhzaak';
COMMENT ON COLUMN public.tbhhafrondsoortzaak.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhhafrondsoortzaak.dvcodehandhafrond
IS 'Foreign key naar tbhandhafronding.dvcode.';
COMMENT ON COLUMN public.tbhhafrondsoortzaak.dnkeysoorthhzaak
IS 'Foreign key naar tbsoorthhzaak.dnkey';
COMMENT ON COLUMN public.tbhhafrondsoortzaak.dnkeybesluittype
IS 'Foreign key naar tbbesluittypes.dnkey';
COMMENT ON COLUMN public.tbhhafrondsoortzaak.dnbewaartermijndagen
IS 'Bewaartermijn in dagen bij deze combinatie zaaktype en resultaattype';
COMMENT ON COLUMN public.tbhhafrondsoortzaak.dvbewarenvanaf
IS 'A of E. Bewaartermijn geldt vanaf (A)anvraag cq startdatum of vanaf (E)inddatum';
CREATE UNIQUE INDEX idu_hhafrondsrtzk_keysrtzk ON public.tbhhafrondsoortzaak
USING btree (dnkeysoorthhzaak, dvcodehandhafrond COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|