Datadictionary OpenWave 3.1.32 |
|
Table: tbkopadviescorresp
Datadictionary OpenWave 3.1.32 |
|
Table: tbkopadviescorresp
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tbadviezen en tbcorrespondentie (geregistreerde documenten)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbkopadviescorresp_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyadviezen |
integer |
|
|
|
|
Foreign Key naar TbAdviezen.dnkey. |
|
|
dnkeycorrespondentie |
integer |
|
|
|
|
Foreign Key naar Tbcorrespondentie.dnkey. |
|
|
dladviesdocbeoordeling |
char(1) |
|
|
|
'N'::bpchar |
T of F of N. Beoordeling van adviesdocument. Indien de waarde T dan is het positief, F is negatief. N wil zeggen onbekend. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbkopadviescorresp_keyadviezen |
dnkeyadviezen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbkopadviescorresp_keycorrespondentie |
dnkeycorrespondentie |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbkopadviescorresp_dladviesdocbeoordeling |
dladviesdocbeoordeling = ANY (ARRAY['F'::bpchar, 'T'::bpchar, 'N'::bpchar]) |
|
cnn_tbkopadviescorresp_dladviesdocbeoordeling |
dladviesdocbeoordeling IS NOT NULL |
|
cnn_tbkopadviescorresp_keyadviezen |
dnkeyadviezen IS NOT NULL |
|
cnn_tbkopadviescorresp_keycorrespondentie |
dnkeycorrespondentie IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkopadviescorresp |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbkopadviescorresp
Rules
There are no rules for table tbkopadviescorresp
Policies
There are no policies for table tbkopadviescorresp
Referenced
There are no tables referenced by table tbkopadviescorresp
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyadviezen INTEGER,
dnkeycorrespondentie INTEGER,
dladviesdocbeoordeling CHAR(1) DEFAULT 'N'::bpchar,
CONSTRAINT cpk_tbkopadviescorresp PRIMARY KEY(dnkey),
CONSTRAINT chk_tbkopadviescorresp_dladviesdocbeoordeling CHECK (dladviesdocbeoordeling = ANY (ARRAY['F'::bpchar, 'T'::bpchar, 'N'::bpchar])),
CONSTRAINT cnn_tbkopadviescorresp_dladviesdocbeoordeling CHECK (dladviesdocbeoordeling IS NOT NULL),
CONSTRAINT cnn_tbkopadviescorresp_keyadviezen CHECK (dnkeyadviezen IS NOT NULL),
CONSTRAINT cnn_tbkopadviescorresp_keycorrespondentie CHECK (dnkeycorrespondentie IS NOT NULL),
CONSTRAINT cfk_tbkopadviescorresp_keyadviezen FOREIGN KEY (dnkeyadviezen)
REFERENCES public.tbadviezen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkopadviescorresp_keycorrespondentie FOREIGN KEY (dnkeycorrespondentie)
REFERENCES public.tbcorrespondentie(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbkopadviescorresp
IS 'Koppeltabel tussen tbadviezen en tbcorrespondentie (geregistreerde documenten)';
COMMENT ON COLUMN public.tbkopadviescorresp.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbkopadviescorresp.dnkeyadviezen
IS 'Foreign Key naar TbAdviezen.dnkey.';
COMMENT ON COLUMN public.tbkopadviescorresp.dnkeycorrespondentie
IS 'Foreign Key naar Tbcorrespondentie.dnkey.';
COMMENT ON COLUMN public.tbkopadviescorresp.dladviesdocbeoordeling
IS 'T of F of N. Beoordeling van adviesdocument. Indien de waarde T dan is het positief, F is negatief. N wil zeggen onbekend.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|