Datadictionary OpenWave 3.1.11 |
|
Table: tbmilivb
Datadictionary OpenWave 3.1.11 |
|
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
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
)
WITH (oids = false);
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 22-2-2017 10:50 |
|