Datadictionary OpenWave 3.1.25 |
|
Table: tbinspaanlonderwerp
Datadictionary OpenWave 3.1.25 |
|
Table: tbinspaanlonderwerp
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tbinspaanleiding en tbinsponderwerpen: welke inspectie-onderwerpen zijn verbonden aan een inspectie-aanleiding
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbinspaanlonderwerp_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyinspaanleiding |
integer |
|
|
|
|
Foreign key naar tbinspaanleiding.dnkey |
|
|
dnkeyinsponderwerp |
integer |
|
|
|
|
Foreign key naar tbinsponderwerpen.dnkey |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum dat combinatie inspectie-aanleiding en in inspectie-onderwerp is komen te vervallen |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_inspalondwrp_keyinspal |
dnkeyinspaanleiding |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_inspalondwrp_keyinspondwrp |
dnkeyinsponderwerp |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_inspalondwrp_keyinspal |
dnkeyinspaanleiding IS NOT NULL |
|
cnn_inspalondwrp_keyinspondwrp |
dnkeyinsponderwerp IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbinspaanlondwrp |
btree |
|
dnkey |
|
|
|
idu_inspalondwrp_keys |
btree |
|
dnkeyinspaanleiding, dnkeyinsponderwerp |
|
|
|
idx_inspalondwrp_keyinspal |
btree |
|
dnkeyinspaanleiding |
|
|
|
idx_inspalondwrp_keyinspondwrp |
btree |
|
dnkeyinsponderwerp |
|
|
|
Triggers
There are no triggers for table tbinspaanlonderwerp
Rules
There are no rules for table tbinspaanlonderwerp
Policies
There are no policies for table tbinspaanlonderwerp
Referenced
There are no tables referenced by table tbinspaanlonderwerp
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyinspaanleiding INTEGER,
dnkeyinsponderwerp INTEGER,
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbinspaanlondwrp PRIMARY KEY(dnkey),
CONSTRAINT cnn_inspalondwrp_keyinspal CHECK (dnkeyinspaanleiding IS NOT NULL),
CONSTRAINT cnn_inspalondwrp_keyinspondwrp CHECK (dnkeyinsponderwerp IS NOT NULL),
CONSTRAINT cfk_inspalondwrp_keyinspal FOREIGN KEY (dnkeyinspaanleiding)
REFERENCES public.tbinspaanleiding(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_inspalondwrp_keyinspondwrp FOREIGN KEY (dnkeyinsponderwerp)
REFERENCES public.tbinsponderwerpen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbinspaanlonderwerp
IS 'Koppeltabel tussen tbinspaanleiding en tbinsponderwerpen: welke inspectie-onderwerpen zijn verbonden aan een inspectie-aanleiding';
COMMENT ON COLUMN public.tbinspaanlonderwerp.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbinspaanlonderwerp.dnkeyinspaanleiding
IS 'Foreign key naar tbinspaanleiding.dnkey';
COMMENT ON COLUMN public.tbinspaanlonderwerp.dnkeyinsponderwerp
IS 'Foreign key naar tbinsponderwerpen.dnkey';
COMMENT ON COLUMN public.tbinspaanlonderwerp.ddvervaldatum
IS 'Datum dat combinatie inspectie-aanleiding en in inspectie-onderwerp is komen te vervallen';
CREATE UNIQUE INDEX idu_inspalondwrp_keys ON public.tbinspaanlonderwerp
USING btree (dnkeyinspaanleiding, dnkeyinsponderwerp);
CREATE INDEX idx_inspalondwrp_keyinspal ON public.tbinspaanlonderwerp
USING btree (dnkeyinspaanleiding);
CREATE INDEX idx_inspalondwrp_keyinspondwrp ON public.tbinspaanlonderwerp
USING btree (dnkeyinsponderwerp);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|