Datadictionary OpenWave 3.1.11 |
|
Table: tbhandhinvorderingen
Datadictionary OpenWave 3.1.11 |
|
Table: tbhandhinvorderingen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met invorderingen n.a.v. een handhavingszaak
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbhandhinvorderingen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyhandhavingen |
integer |
|
|
|
|
Foreign key naar TbHandhavingen. |
|
|
dnkeysoortinvordering |
integer |
|
|
|
|
Foreign key naar TbSoortInvorderingen. |
|
|
dvomschrijving |
varchar(50) |
|
|
|
|
Omschrijving van de invordering. |
|
|
dddatum |
timestamp |
|
|
|
|
Datum van invordering. |
|
|
dfbedrag |
double precision |
|
|
|
|
Bedrag in Euro van invordering. |
|
|
ddafgehandeld |
timestamp |
|
|
|
|
Datum dat invordering is afgehandeld. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbhhinv_handh |
dnkeyhandhavingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbhhinv_soortinv |
dnkeysoortinvordering |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_handhinv_dnkeyhandh |
dnkeyhandhavingen IS NOT NULL |
|
cnn_handhinv_dnkeysrtinv |
dnkeysoortinvordering IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbhandhinvorderingen |
btree |
|
dnkey |
|
|
|
idx_handhinvord_ddafgehandeld |
btree |
|
ddafgehandeld |
|
|
|
idx_tbhhinvord_handh |
btree |
|
dnkeyhandhavingen |
|
|
|
idx_tbhhinvord_soort |
btree |
|
dnkeysoortinvordering |
|
|
|
Triggers
There are no triggers for table tbhandhinvorderingen
Rules
There are no rules for table tbhandhinvorderingen
Referenced
There are no tables referenced by table tbhandhinvorderingen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyhandhavingen INTEGER,
dnkeysoortinvordering INTEGER,
dvomschrijving VARCHAR(50),
dddatum TIMESTAMP WITHOUT TIME ZONE,
dfbedrag DOUBLE PRECISION,
ddafgehandeld TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbhandhinvorderingen PRIMARY KEY(dnkey),
CONSTRAINT cnn_handhinv_dnkeyhandh CHECK (dnkeyhandhavingen IS NOT NULL),
CONSTRAINT cnn_handhinv_dnkeysrtinv CHECK (dnkeysoortinvordering IS NOT NULL),
CONSTRAINT cfk_tbhhinv_handh FOREIGN KEY (dnkeyhandhavingen)
REFERENCES public.tbhandhavingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbhhinv_soortinv FOREIGN KEY (dnkeysoortinvordering)
REFERENCES public.tbsoortinvordering(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbhandhinvorderingen
IS 'Tabel met invorderingen n.a.v. een handhavingszaak';
COMMENT ON COLUMN public.tbhandhinvorderingen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dnkeyhandhavingen
IS 'Foreign key naar TbHandhavingen.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dnkeysoortinvordering
IS 'Foreign key naar TbSoortInvorderingen.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dvomschrijving
IS 'Omschrijving van de invordering.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dddatum
IS 'Datum van invordering.';
COMMENT ON COLUMN public.tbhandhinvorderingen.dfbedrag
IS 'Bedrag in Euro van invordering.';
COMMENT ON COLUMN public.tbhandhinvorderingen.ddafgehandeld
IS 'Datum dat invordering is afgehandeld.';
CREATE INDEX idx_handhinvord_ddafgehandeld ON public.tbhandhinvorderingen
USING btree (ddafgehandeld);
CREATE INDEX idx_tbhhinvord_handh ON public.tbhandhinvorderingen
USING btree (dnkeyhandhavingen);
CREATE INDEX idx_tbhhinvord_soort ON public.tbhandhinvorderingen
USING btree (dnkeysoortinvordering);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|