Datadictionary OpenWave 3.1.25 |
|
Table: tbhoraardbsrtzaak
Datadictionary OpenWave 3.1.25 |
|
Table: tbhoraardbsrtzaak
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tbsoorthorverg en tbhoraardbesluit net bewaartermijnen
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhoraardbsrtzaak_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcodehoraardbesuit |
char(1) |
|
|
|
|
Foreign key naar tbhoraardbesluit.dvcode. |
|
|
dnkeysoorthorverg |
integer |
|
|
|
|
Foreign key naar tbsoorthorverg.dnkey |
|
|
dnbewaartermijndagen |
integer |
|
|
|
|
Bewaartermijn in dagen bij deze combinatie zaaktype en resultaattype |
|
|
dnkeybesluittype |
integer |
|
|
|
|
Foreign key naar tbbesluittypes.dnkey |
|
|
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_horaardbsrtzk_codehoraard |
dvcodehoraardbesuit |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_horaardbsrtzk_keybesltype |
dnkeybesluittype |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_horaardbsrtzk_keysrthor |
dnkeysoorthorverg |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_horaardbsrtzk_dvbewvanaf |
dvbewarenvanaf = ANY (ARRAY['A'::bpchar, 'E'::bpchar]) |
|
cnn_horaardbsrtzk_codehoraard |
dvcodehoraardbesuit IS NOT NULL |
|
cnn_horaardbsrtzk_dvbewvanaf |
dvbewarenvanaf IS NOT NULL |
|
cnn_horaardbsrtzk_keysrthor |
dnkeysoorthorverg IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhoraardbsrtzaak |
btree |
|
dnkey |
|
|
|
idu_horaardbsrtzk_keys |
btree |
|
dnkeysoorthorverg, dvcodehoraardbesuit |
|
|
|
Triggers
There are no triggers for table tbhoraardbsrtzaak
Rules
There are no rules for table tbhoraardbsrtzaak
Policies
There are no policies for table tbhoraardbsrtzaak
Referenced
There are no tables referenced by table tbhoraardbsrtzaak
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcodehoraardbesuit CHAR(1),
dnkeysoorthorverg INTEGER,
dnbewaartermijndagen INTEGER,
dnkeybesluittype INTEGER,
dvbewarenvanaf CHAR(1) DEFAULT 'A'::bpchar,
CONSTRAINT cpk_tbhoraardbsrtzaak PRIMARY KEY(dnkey),
CONSTRAINT chk_horaardbsrtzk_dvbewvanaf CHECK (dvbewarenvanaf = ANY (ARRAY['A'::bpchar, 'E'::bpchar])),
CONSTRAINT cnn_horaardbsrtzk_codehoraard CHECK (dvcodehoraardbesuit IS NOT NULL),
CONSTRAINT cnn_horaardbsrtzk_dvbewvanaf CHECK (dvbewarenvanaf IS NOT NULL),
CONSTRAINT cnn_horaardbsrtzk_keysrthor CHECK (dnkeysoorthorverg IS NOT NULL),
CONSTRAINT cfk_horaardbsrtzk_codehoraard FOREIGN KEY (dvcodehoraardbesuit)
REFERENCES public.tbhoraardbesluit(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_horaardbsrtzk_keybesltype FOREIGN KEY (dnkeybesluittype)
REFERENCES public.tbbesluittypes(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_horaardbsrtzk_keysrthor FOREIGN KEY (dnkeysoorthorverg)
REFERENCES public.tbsoorthorverg(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbhoraardbsrtzaak
IS 'Koppeltabel tussen tbsoorthorverg en tbhoraardbesluit net bewaartermijnen';
COMMENT ON COLUMN public.tbhoraardbsrtzaak.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhoraardbsrtzaak.dvcodehoraardbesuit
IS 'Foreign key naar tbhoraardbesluit.dvcode.';
COMMENT ON COLUMN public.tbhoraardbsrtzaak.dnkeysoorthorverg
IS 'Foreign key naar tbsoorthorverg.dnkey';
COMMENT ON COLUMN public.tbhoraardbsrtzaak.dnbewaartermijndagen
IS 'Bewaartermijn in dagen bij deze combinatie zaaktype en resultaattype';
COMMENT ON COLUMN public.tbhoraardbsrtzaak.dnkeybesluittype
IS 'Foreign key naar tbbesluittypes.dnkey';
COMMENT ON COLUMN public.tbhoraardbsrtzaak.dvbewarenvanaf
IS 'A of E. Bewaartermijn geldt vanaf (A)anvraag cq startdatum of vanaf (E)inddatum';
CREATE UNIQUE INDEX idu_horaardbsrtzk_keys ON public.tbhoraardbsrtzaak
USING btree (dnkeysoorthorverg, dvcodehoraardbesuit COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|