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, 'I'::character varying, 'H'::character varying, '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
Referenced
There are no tables referenced by table tbmilafvalvervoerders
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tbmilafvalvervoerders (
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, 'I'::character varying, 'H'::character varying, '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
)
WITH (oids = false);
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 2-9-2021 14:10 |
![]() ![]() ![]() |