Datadictionary OpenWave 3.1.25 |
|
Table: tbmilsbi
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilsbi
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel van sbi-coderingen (tbmilcodesbi) en inrichting
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilsbi_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodesbi |
integer |
|
|
|
|
Foreign key naar TbMilCodeSbi.dnkey. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilInrichtingen.dnkey. |
|
|
dlhoofdsbi |
char(1) |
|
|
|
'F'::bpchar |
T of F. Is deze SBI de belangrijkste codering voor de bereffende inrichting |
|
|
dnafwafstgeur |
integer |
|
|
|
|
Afwijking Afstand geur . |
|
|
dnafwafststof |
integer |
|
|
|
|
Afwijking Afstand stof. |
|
|
dnafwafstgeluid |
integer |
|
|
|
|
Afwijking Afstand Geluid. |
|
|
dnafwafsttril |
integer |
|
|
|
|
Afwijking Afstand Tril. |
|
|
dnafwafstgevaar |
integer |
|
|
|
|
Afwijking Afstand gevaar. |
|
|
dvopmerking |
varchar(60) |
|
|
|
|
Extra opmerking. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_milsbi_milcodesbi |
dnkeymilcodesbi |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_milsbi_milinricht |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_milsbi_hoofdsbi |
dlhoofdsbi = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
cnn_milsbi_keycodesbi |
dnkeymilcodesbi IS NOT NULL |
|
cnn_milsbi_keyinricht |
dnkeymilinrichtingen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilsbi |
btree |
|
dnkey |
|
|
|
idx_milsbi_milcodesbi |
btree |
|
dnkeymilcodesbi |
|
|
|
idx_milsbi_milinricht |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbmilsbi
Rules
There are no rules for table tbmilsbi
Policies
There are no policies for table tbmilsbi
Referenced
There are no tables referenced by table tbmilsbi
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodesbi INTEGER,
dnkeymilinrichtingen INTEGER,
dlhoofdsbi CHAR(1) DEFAULT 'F'::bpchar,
dnafwafstgeur INTEGER,
dnafwafststof INTEGER,
dnafwafstgeluid INTEGER,
dnafwafsttril INTEGER,
dnafwafstgevaar INTEGER,
dvopmerking VARCHAR(60),
CONSTRAINT cpk_tbmilsbi PRIMARY KEY(dnkey),
CONSTRAINT chk_milsbi_hoofdsbi CHECK (dlhoofdsbi = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT cnn_milsbi_keycodesbi CHECK (dnkeymilcodesbi IS NOT NULL),
CONSTRAINT cnn_milsbi_keyinricht CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cfk_milsbi_milcodesbi FOREIGN KEY (dnkeymilcodesbi)
REFERENCES public.tbmilcodesbi(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milsbi_milinricht FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilsbi
IS 'Koppeltabel van sbi-coderingen (tbmilcodesbi) en inrichting';
COMMENT ON COLUMN public.tbmilsbi.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilsbi.dnkeymilcodesbi
IS 'Foreign key naar TbMilCodeSbi.dnkey.';
COMMENT ON COLUMN public.tbmilsbi.dnkeymilinrichtingen
IS 'Foreign key naar TbMilInrichtingen.dnkey.';
COMMENT ON COLUMN public.tbmilsbi.dlhoofdsbi
IS 'T of F. Is deze SBI de belangrijkste codering voor de bereffende inrichting';
COMMENT ON COLUMN public.tbmilsbi.dnafwafstgeur
IS 'Afwijking Afstand geur .';
COMMENT ON COLUMN public.tbmilsbi.dnafwafststof
IS 'Afwijking Afstand stof.';
COMMENT ON COLUMN public.tbmilsbi.dnafwafstgeluid
IS 'Afwijking Afstand Geluid.';
COMMENT ON COLUMN public.tbmilsbi.dnafwafsttril
IS 'Afwijking Afstand Tril.';
COMMENT ON COLUMN public.tbmilsbi.dnafwafstgevaar
IS 'Afwijking Afstand gevaar.';
COMMENT ON COLUMN public.tbmilsbi.dvopmerking
IS 'Extra opmerking.';
CREATE INDEX idx_milsbi_milcodesbi ON public.tbmilsbi
USING btree (dnkeymilcodesbi);
CREATE INDEX idx_milsbi_milinricht ON public.tbmilsbi
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|