Datadictionary OpenWave 3.1.25 |
|
Table: tbmilivb
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilivb
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel van ROB-categorieen (voorheen ivb): tbmilcodeivb en inrichting
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilivb_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodeivb |
integer |
|
|
|
|
Foreign key naar TbMilCodeIvb.dnkey |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilInrichtingen.dnkey |
|
|
dvopmerking |
varchar(2000) |
|
|
|
|
Extra opmerking. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_milivb_milcodeivb |
dnkeymilcodeivb |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_milivb_milinricht |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milivb_keycodeivb |
dnkeymilcodeivb IS NOT NULL |
|
cnn_milivb_keyinricht |
dnkeymilinrichtingen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilivb |
btree |
|
dnkey |
|
|
|
idx_milivb_milcodeivb |
btree |
|
dnkeymilcodeivb |
|
|
|
idx_milivb_milinricht |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbmilivb
Rules
There are no rules for table tbmilivb
Policies
There are no policies for table tbmilivb
Referenced
There are no tables referenced by table tbmilivb
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodeivb INTEGER,
dnkeymilinrichtingen INTEGER,
dvopmerking VARCHAR(2000),
CONSTRAINT cpk_tbmilivb PRIMARY KEY(dnkey),
CONSTRAINT cnn_milivb_keycodeivb CHECK (dnkeymilcodeivb IS NOT NULL),
CONSTRAINT cnn_milivb_keyinricht CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cfk_milivb_milcodeivb FOREIGN KEY (dnkeymilcodeivb)
REFERENCES public.tbmilcodeivb(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milivb_milinricht FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilivb
IS 'Koppeltabel van ROB-categorieen (voorheen ivb): tbmilcodeivb en inrichting';
COMMENT ON COLUMN public.tbmilivb.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilivb.dnkeymilcodeivb
IS 'Foreign key naar TbMilCodeIvb.dnkey';
COMMENT ON COLUMN public.tbmilivb.dnkeymilinrichtingen
IS 'Foreign key naar TbMilInrichtingen.dnkey';
COMMENT ON COLUMN public.tbmilivb.dvopmerking
IS 'Extra opmerking.';
CREATE INDEX idx_milivb_milcodeivb ON public.tbmilivb
USING btree (dnkeymilcodeivb);
CREATE INDEX idx_milivb_milinricht ON public.tbmilivb
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|