Datadictionary OpenWave 3.1.25 |
|
Table: tbcorafschriften
Datadictionary OpenWave 3.1.25 |
|
Table: tbcorafschriften
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen een uitgaande correspondentiekaart en een lijst van afschriften (cobtacadressen die cc per mail moeten ontvangen bij uigaande correspondentie
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbcorafschriften_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeycorrespondentie |
integer |
|
|
|
|
Foreign key naar TbCorrespondentie.dnkey |
|
|
dnkeydefafschriften |
integer |
|
|
|
|
Foreign key naar TbDefAfschriften.dnkey |
|
|
dnkeycontactadressen |
integer |
|
|
|
|
Foreign key naar Tbcontactadressen.dnkey |
|
|
ddemailverzonden |
timestamp |
|
|
|
|
Datum dat document behorend bij dnkeycorrespondentie naar dnkeycontactadres per mail is verzonden |
|
|
ddemailmislukt |
timestamp |
|
|
|
|
Datum dat verzending document behorend bij dnkeycorrespondentie naar dnkeycontactadres per mail is mislukt |
|
|
dvredenemailmislukt |
varchar(200) |
|
|
|
|
Reden mislukking verzending per email |
|
|
dlbcc |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien true wordt de email verstuurd als bcc |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_corafschr_keycontact |
dnkeycontactadressen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbcorafschr_keycorresp |
dnkeycorrespondentie |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbcorafschr_keydefaf |
dnkeydefafschriften |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbcorafschriften_dlbcc |
dlbcc = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_corafschr_keycontact |
dnkeycontactadressen IS NOT NULL |
|
cnn_corafschr_keycorresp |
dnkeycorrespondentie IS NOT NULL |
|
cnn_tbcorafschriften_ddlbcc |
dlbcc IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbcorafschriften |
btree |
|
dnkey |
|
|
|
idx_corafschr_keycorresp |
btree |
|
dnkeycorrespondentie |
|
|
|
idx_corafschr_keydefafschr |
btree |
|
dnkeydefafschriften |
|
|
|
Triggers
There are no triggers for table tbcorafschriften
Rules
There are no rules for table tbcorafschriften
Policies
There are no policies for table tbcorafschriften
Referenced
There are no tables referenced by table tbcorafschriften
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeycorrespondentie INTEGER,
dnkeydefafschriften INTEGER,
dnkeycontactadressen INTEGER,
ddemailverzonden TIMESTAMP WITHOUT TIME ZONE,
ddemailmislukt TIMESTAMP WITHOUT TIME ZONE,
dvredenemailmislukt VARCHAR(200),
dlbcc CHAR(1) DEFAULT 'F'::bpchar,
CONSTRAINT cpk_tbcorafschriften PRIMARY KEY(dnkey),
CONSTRAINT chk_tbcorafschriften_dlbcc CHECK (dlbcc = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_corafschr_keycontact CHECK (dnkeycontactadressen IS NOT NULL),
CONSTRAINT cnn_corafschr_keycorresp CHECK (dnkeycorrespondentie IS NOT NULL),
CONSTRAINT cnn_tbcorafschriften_ddlbcc CHECK (dlbcc IS NOT NULL),
CONSTRAINT cfk_corafschr_keycontact FOREIGN KEY (dnkeycontactadressen)
REFERENCES public.tbcontactadressen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbcorafschr_keycorresp FOREIGN KEY (dnkeycorrespondentie)
REFERENCES public.tbcorrespondentie(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbcorafschr_keydefaf FOREIGN KEY (dnkeydefafschriften)
REFERENCES public.tbdefafschriften(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbcorafschriften
IS 'Koppeltabel tussen een uitgaande correspondentiekaart en een lijst van afschriften (cobtacadressen die cc per mail moeten ontvangen bij uigaande correspondentie';
COMMENT ON COLUMN public.tbcorafschriften.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbcorafschriften.dnkeycorrespondentie
IS 'Foreign key naar TbCorrespondentie.dnkey';
COMMENT ON COLUMN public.tbcorafschriften.dnkeydefafschriften
IS 'Foreign key naar TbDefAfschriften.dnkey';
COMMENT ON COLUMN public.tbcorafschriften.dnkeycontactadressen
IS 'Foreign key naar Tbcontactadressen.dnkey';
COMMENT ON COLUMN public.tbcorafschriften.ddemailverzonden
IS 'Datum dat document behorend bij dnkeycorrespondentie naar dnkeycontactadres per mail is verzonden';
COMMENT ON COLUMN public.tbcorafschriften.ddemailmislukt
IS 'Datum dat verzending document behorend bij dnkeycorrespondentie naar dnkeycontactadres per mail is mislukt';
COMMENT ON COLUMN public.tbcorafschriften.dvredenemailmislukt
IS 'Reden mislukking verzending per email';
COMMENT ON COLUMN public.tbcorafschriften.dlbcc
IS 'T of F. Indien true wordt de email verstuurd als bcc';
CREATE INDEX idx_corafschr_keycorresp ON public.tbcorafschriften
USING btree (dnkeycorrespondentie);
CREATE INDEX idx_corafschr_keydefafschr ON public.tbcorafschriften
USING btree (dnkeydefafschriften);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|