Datadictionary OpenWave 3.1.25 |
|
Table: tblegesexport
Datadictionary OpenWave 3.1.25 |
|
Table: tblegesexport
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
Policies
There are no policies 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
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
) ;
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 5-1-2022 14:13 |
|