Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met legesexportregels: wordt opgesteld via wizard MaakLegesExportLijst
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
dnkey |
serial |
|
nextval('tblegesexport_dnkey_seq'::regclass) |
De primary key van de exportregel |
|||
|
dnkeylegesregels |
integer |
|
|
|
|
Foreign key naar tblegesregels.dnkey |
|
|
dnkeylegessoort |
integer |
|
|
|
|
Foreign key naar tblegessoort.dnkey |
|
|
dnkeycontactadres |
integer |
|
|
|
|
Foreign key naar tbcontactadressen.dnkey |
|
|
|
dvinuit |
char(1) |
|
|
|
|
(I)nkomsten of (U)itgaven. |
|
|
dvid |
varchar(40) |
|
|
|
|
Dvmodule || dnkeymodule unieke waarde voor de onderliggende zaak |
|
dnkeycompartiment |
integer |
|
|
|
|
Foreign key naar tbcompartiment.dnkey |
|
|
|
ddbeschikking |
timestamp |
|
|
|
|
Verzenddatum besluit voor de zaak waaronder de legesregel is aangemaakt |
|
|
ddaccgiroverzonden |
timestamp |
|
|
|
|
Datum waarop leges verzonden kunnen worden |
|
|
dvcontrole |
char(1) |
|
|
|
|
Controle op aanvrager of debiteurengegevens? Waarde is A(anvrager) of D(ebiteur) |
|
|
dlpergemeente |
char(1) |
|
|
|
'F'::bpchar |
Export per gemeente? true or false |
|
|
dvgemeenteid |
varchar(4) |
|
|
|
|
De gemeentecode van de gekozen gemeente waarvoor de legesexportlijst is opgesteld |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
cfk_tblegesexport_keycomp |
dnkeycompartiment |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_tblegesexport_keycontact |
dnkeycontactadres |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tblegesexport_keylegregel |
dnkeylegesregels |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tblegesexport_keylegsoort |
dnkeylegessoort |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
---|---|---|
chk_tblegesexport_dlpergemeente |
dlpergemeente = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tblegesexport_dvcontrole |
dvcontrole = ANY (ARRAY['A'::bpchar, 'D'::bpchar]) |
|
chk_tblegesexport_dvinuit |
dvinuit = ANY (ARRAY['I'::bpchar, 'U'::bpchar]) |
|
cnn_tblegesexport_dvcontrole |
dvcontrole IS NOT NULL |
|
cnn_tblegesexport_keylegregel |
dnkeylegesregels IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
cpk_tblegesexport |
btree |
|
dnkey |
|
Triggers
There are no triggers for table tblegesexport
Rules
There are no rules for table tblegesexport
Referenced
There are no tables referenced by table tblegesexport
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tblegesexport (
dnkey SERIAL,
dnkeylegesregels INTEGER,
dnkeylegessoort INTEGER,
dnkeycontactadres INTEGER,
dvinuit CHAR(1),
dvid VARCHAR(40),
dnkeycompartiment INTEGER,
ddbeschikking TIMESTAMP WITHOUT TIME ZONE,
ddaccgiroverzonden TIMESTAMP WITHOUT TIME ZONE,
dvcontrole CHAR(1),
dlpergemeente CHAR(1) DEFAULT 'F'::bpchar,
dvgemeenteid VARCHAR(4),
CONSTRAINT cpk_tblegesexport PRIMARY KEY(dnkey),
CONSTRAINT chk_tblegesexport_dlpergemeente CHECK (dlpergemeente = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_tblegesexport_dvcontrole CHECK (dvcontrole = ANY (ARRAY['A'::bpchar, 'D'::bpchar])),
CONSTRAINT chk_tblegesexport_dvinuit CHECK (dvinuit = ANY (ARRAY['I'::bpchar, 'U'::bpchar])),
CONSTRAINT cnn_tblegesexport_dvcontrole CHECK (dvcontrole IS NOT NULL),
CONSTRAINT cnn_tblegesexport_keylegregel CHECK (dnkeylegesregels IS NOT NULL),
CONSTRAINT cfk_tblegesexport_keycomp FOREIGN KEY (dnkeycompartiment)
REFERENCES public.tbcompartiment(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tblegesexport_keycontact FOREIGN KEY (dnkeycontactadres)
REFERENCES public.tbcontactadressen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tblegesexport_keylegregel FOREIGN KEY (dnkeylegesregels)
REFERENCES public.tblegesregels(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tblegesexport_keylegsoort FOREIGN KEY (dnkeylegessoort)
REFERENCES public.tblegessoort(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tblegesexport
IS 'Tabel met legesexportregels: wordt opgesteld via wizard MaakLegesExportLijst';
COMMENT ON COLUMN public.tblegesexport.dnkey
IS 'De primary key van de exportregel';
COMMENT ON COLUMN public.tblegesexport.dnkeylegesregels
IS 'Foreign key naar tblegesregels.dnkey';
COMMENT ON COLUMN public.tblegesexport.dnkeylegessoort
IS 'Foreign key naar tblegessoort.dnkey';
COMMENT ON COLUMN public.tblegesexport.dnkeycontactadres
IS 'Foreign key naar tbcontactadressen.dnkey';
COMMENT ON COLUMN public.tblegesexport.dvinuit
IS '(I)nkomsten of (U)itgaven.';
COMMENT ON COLUMN public.tblegesexport.dvid
IS 'Dvmodule || dnkeymodule unieke waarde voor de onderliggende zaak';
COMMENT ON COLUMN public.tblegesexport.dnkeycompartiment
IS 'Foreign key naar tbcompartiment.dnkey';
COMMENT ON COLUMN public.tblegesexport.ddbeschikking
IS 'Verzenddatum besluit voor de zaak waaronder de legesregel is aangemaakt';
COMMENT ON COLUMN public.tblegesexport.ddaccgiroverzonden
IS 'Datum waarop leges verzonden kunnen worden';
COMMENT ON COLUMN public.tblegesexport.dvcontrole
IS 'Controle op aanvrager of debiteurengegevens? Waarde is A(anvrager) of D(ebiteur)';
COMMENT ON COLUMN public.tblegesexport.dlpergemeente
IS 'Export per gemeente? true or false';
COMMENT ON COLUMN public.tblegesexport.dvgemeenteid
IS 'De gemeentecode van de gekozen gemeente waarvoor de legesexportlijst is opgesteld';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-9-2021 14:10 |
![]() ![]() ![]() |