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
Referenced
There are no tables referenced by table tbhoraardbsrtzaak
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tbhoraardbsrtzaak (
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
)
WITH (oids = false);
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 10-5-2021 13:56 |
![]() ![]() ![]() |