Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel met wagens /plekken waar een bepaald brandweer-aanvalsplan fysiek aanwezig hoort te zijn
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
dnkey |
serial |
|
nextval('tbavpkopwagens_dnkey_seq'::regclass) |
Primary key. |
|||
|
dnkeyaanvalsplannen |
integer |
|
|
|
|
Foreign key naar TbAanvalsplannen.dnkey |
|
|
dnkeywagens |
integer |
|
|
|
|
Foreign key naar TbWagens.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
cfk_tbavpkopwagens_keyaanvalsp |
dnkeyaanvalsplannen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbavpkopwagens_keywagens |
dnkeywagens |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
---|---|---|
cnn_tbavpkopwagens_keyaanvalsp |
dnkeyaanvalsplannen IS NOT NULL |
|
cnn_tbavpkopwagens_keywagens |
dnkeywagens IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
cpk_tbavpkopwagens |
btree |
|
dnkey |
|
||
idx_tbavpkopwagens_keyaanvalsp |
btree |
|
dnkeyaanvalsplannen |
|
|
|
idx_tbavpkopwagens_keywagens |
btree |
|
dnkeywagens |
|
|
|
Triggers
There are no triggers for table tbavpkopwagens
Rules
There are no rules for table tbavpkopwagens
Policies
There are no policies for table tbavpkopwagens
Referenced
There are no tables referenced by table tbavpkopwagens
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
Definition
CREATE TABLE public.tbavpkopwagens (
dnkey SERIAL,
dnkeyaanvalsplannen INTEGER,
dnkeywagens INTEGER,
CONSTRAINT cpk_tbavpkopwagens PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbavpkopwagens_keyaanvalsp CHECK (dnkeyaanvalsplannen IS NOT NULL),
CONSTRAINT cnn_tbavpkopwagens_keywagens CHECK (dnkeywagens IS NOT NULL),
CONSTRAINT cfk_tbavpkopwagens_keyaanvalsp FOREIGN KEY (dnkeyaanvalsplannen)
REFERENCES public.tbaanvalsplannen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbavpkopwagens_keywagens FOREIGN KEY (dnkeywagens)
REFERENCES public.tbwagens(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbavpkopwagens
IS 'Koppeltabel met wagens /plekken waar een bepaald brandweer-aanvalsplan fysiek aanwezig hoort te zijn';
COMMENT ON COLUMN public.tbavpkopwagens.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbavpkopwagens.dnkeyaanvalsplannen
IS 'Foreign key naar TbAanvalsplannen.dnkey';
COMMENT ON COLUMN public.tbavpkopwagens.dnkeywagens
IS 'Foreign key naar TbWagens.dnkey';
CREATE INDEX idx_tbavpkopwagens_keyaanvalsp ON public.tbavpkopwagens
USING btree (dnkeyaanvalsplannen);
CREATE INDEX idx_tbavpkopwagens_keywagens ON public.tbavpkopwagens
USING btree (dnkeywagens);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
![]() ![]() ![]() |