Datadictionary OpenWave 3.1.25 |
|
Table: tbmilafvalvervoerders
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilafvalvervoerders
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tbmilafvalstoffen en tbmilvervoerders. De afvalvervoerder(s) en hun rol worden hier vastgelegd voor de afvalstofregistratie
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilafvalvervoerders_dnkey_seq'::regclass) |
Primary key van de tabel |
|
|
dnkeymilafvalstof |
integer |
|
|
|
|
Foreign key naar tbmilafvalstoffen.dnkey |
|
|
dnkeymilvervoerders |
integer |
|
|
|
|
Foreign key naar tbmilvervoerders.dnkey |
|
|
dvcodevihb |
varchar(1) |
|
|
|
|
Code van rol afvalstofvervoerder (V,I,H of B) |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilafvalvervoerders_keymilafvalstof |
dnkeymilafvalstof |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmilafvalvervoerders_keymilvervoerders |
dnkeymilvervoerders |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbmilafvalvervoerders_dvcodevihb |
(dvcodevihb)::text = ANY (ARRAY[('V'::character varying)::text, ('I'::character varying)::text, ('H'::character varying)::text, ('B'::character varying)::text]) |
|
cnn_keymilafvalstof |
dnkeymilafvalstof IS NOT NULL |
|
cnn_keymilvervoerders |
dnkeymilvervoerders IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilafvalvervoerders |
btree |
|
dnkey |
|
|
|
idu_tbmilafvalvervoerders_keyafvvervvihb |
btree |
|
dnkeymilafvalstof, dnkeymilvervoerders, (COALESCE(dvcodevihb, ''::character varying)) |
|
|
|
Triggers
There are no triggers for table tbmilafvalvervoerders
Rules
There are no rules for table tbmilafvalvervoerders
Policies
There are no policies for table tbmilafvalvervoerders
Referenced
There are no tables referenced by table tbmilafvalvervoerders
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilafvalstof INTEGER,
dnkeymilvervoerders INTEGER,
dvcodevihb VARCHAR(1),
CONSTRAINT cpk_tbmilafvalvervoerders PRIMARY KEY(dnkey),
CONSTRAINT chk_tbmilafvalvervoerders_dvcodevihb CHECK ((dvcodevihb)::text = ANY (ARRAY[('V'::character varying)::text, ('I'::character varying)::text, ('H'::character varying)::text, ('B'::character varying)::text])),
CONSTRAINT cnn_keymilafvalstof CHECK (dnkeymilafvalstof IS NOT NULL),
CONSTRAINT cnn_keymilvervoerders CHECK (dnkeymilvervoerders IS NOT NULL),
CONSTRAINT cfk_tbmilafvalvervoerders_keymilafvalstof FOREIGN KEY (dnkeymilafvalstof)
REFERENCES public.tbmilafvalstoffen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilafvalvervoerders_keymilvervoerders FOREIGN KEY (dnkeymilvervoerders)
REFERENCES public.tbmilvervoerders(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilafvalvervoerders
IS 'Koppeltabel tussen tbmilafvalstoffen en tbmilvervoerders. De afvalvervoerder(s) en hun rol worden hier vastgelegd voor de afvalstofregistratie';
COMMENT ON COLUMN public.tbmilafvalvervoerders.dnkey
IS 'Primary key van de tabel';
COMMENT ON COLUMN public.tbmilafvalvervoerders.dnkeymilafvalstof
IS 'Foreign key naar tbmilafvalstoffen.dnkey';
COMMENT ON COLUMN public.tbmilafvalvervoerders.dnkeymilvervoerders
IS 'Foreign key naar tbmilvervoerders.dnkey';
COMMENT ON COLUMN public.tbmilafvalvervoerders.dvcodevihb
IS 'Code van rol afvalstofvervoerder (V,I,H of B)';
CREATE UNIQUE INDEX idu_tbmilafvalvervoerders_keyafvvervvihb ON public.tbmilafvalvervoerders
USING btree (dnkeymilafvalstof, dnkeymilvervoerders, (COALESCE(dvcodevihb, ''::character varying)) COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|