Datadictionary OpenWave 3.1.25 |
|
Table: tbmilcertificaten
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilcertificaten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van certificaten geregistreerd per inrichting
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilcertificaten_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodecertif |
integer |
|
|
|
|
Foreign key naar TbMilCodeCertif.dnkey. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilInrichtingen.dnkey. |
|
|
dvopmerking |
varchar(60) |
|
|
|
|
Bijv: GvZ heeft op 2 jan. bemonsterd. Ok. (BG). |
|
|
dddatum |
timestamp |
|
|
|
|
Datum dat opmerking is geplaatst |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_milcertificaten_milcdcert |
dnkeymilcodecertif |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_milcertificaten_milinricht |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milcertificaten_keycdcert |
dnkeymilcodecertif IS NOT NULL |
|
cnn_milcertificaten_keyinricht |
dnkeymilinrichtingen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilcertificaten |
btree |
|
dnkey |
|
|
|
idx_milcertificaten_milcdcert |
btree |
|
dnkeymilcodecertif |
|
|
|
idx_milcertificaten_milinricht |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbmilcertificaten
Rules
There are no rules for table tbmilcertificaten
Policies
There are no policies for table tbmilcertificaten
Referenced
There are no tables referenced by table tbmilcertificaten
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodecertif INTEGER,
dnkeymilinrichtingen INTEGER,
dvopmerking VARCHAR(60),
dddatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmilcertificaten PRIMARY KEY(dnkey),
CONSTRAINT cnn_milcertificaten_keycdcert CHECK (dnkeymilcodecertif IS NOT NULL),
CONSTRAINT cnn_milcertificaten_keyinricht CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cfk_milcertificaten_milcdcert FOREIGN KEY (dnkeymilcodecertif)
REFERENCES public.tbmilcodecertif(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milcertificaten_milinricht FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilcertificaten
IS 'Tabel van certificaten geregistreerd per inrichting';
COMMENT ON COLUMN public.tbmilcertificaten.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilcertificaten.dnkeymilcodecertif
IS 'Foreign key naar TbMilCodeCertif.dnkey.';
COMMENT ON COLUMN public.tbmilcertificaten.dnkeymilinrichtingen
IS 'Foreign key naar TbMilInrichtingen.dnkey.';
COMMENT ON COLUMN public.tbmilcertificaten.dvopmerking
IS 'Bijv: GvZ heeft op 2 jan. bemonsterd. Ok. (BG).';
COMMENT ON COLUMN public.tbmilcertificaten.dddatum
IS 'Datum dat opmerking is geplaatst';
CREATE INDEX idx_milcertificaten_milcdcert ON public.tbmilcertificaten
USING btree (dnkeymilcodecertif);
CREATE INDEX idx_milcertificaten_milinricht ON public.tbmilcertificaten
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|