Datadictionary OpenWave 3.1.25 |
|
Table: tbmilravbwl
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilravbwl
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel wordt gebruikt om mogelijke combinaties tussen stal/diergroepcode en BWL-codering te beperken tot alleen geldige combinaties
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilravbwl_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodestaldier |
integer |
|
|
|
|
Foreign key naar tbmilcodestaldier.dnkey |
|
|
dnkeymilcodebwl |
integer |
|
|
|
|
Foreign key naar tbmilcodebwl.dnkey |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum dat combinatie vervallen is |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilravbwl_dnkeymlcdbwl |
dnkeymilcodebwl |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmilravbwl_dnkeymlcdstdi |
dnkeymilcodestaldier |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmilravbwl_dnkeymlcdbwl |
dnkeymilcodebwl IS NOT NULL |
|
cnn_tbmilravbwl_dnkeymlcdstdi |
dnkeymilcodestaldier IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilravbwl |
btree |
|
dnkey |
|
|
|
idu_tbmilravbwl_dnkeybwlstldr |
btree |
|
dnkeymilcodestaldier, dnkeymilcodebwl |
|
|
|
Triggers
There are no triggers for table tbmilravbwl
Rules
There are no rules for table tbmilravbwl
Policies
There are no policies for table tbmilravbwl
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbmilcdstdr_dnkeymlravbwl |
dnkeymilravbwl |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodestaldier INTEGER,
dnkeymilcodebwl INTEGER,
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmilravbwl PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmilravbwl_dnkeymlcdbwl CHECK (dnkeymilcodebwl IS NOT NULL),
CONSTRAINT cnn_tbmilravbwl_dnkeymlcdstdi CHECK (dnkeymilcodestaldier IS NOT NULL),
CONSTRAINT cfk_tbmilravbwl_dnkeymlcdbwl FOREIGN KEY (dnkeymilcodebwl)
REFERENCES public.tbmilcodebwl(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilravbwl_dnkeymlcdstdi FOREIGN KEY (dnkeymilcodestaldier)
REFERENCES public.tbmilcodestaldier(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilravbwl
IS 'Tabel wordt gebruikt om mogelijke combinaties tussen stal/diergroepcode en BWL-codering te beperken tot alleen geldige combinaties ';
COMMENT ON COLUMN public.tbmilravbwl.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilravbwl.dnkeymilcodestaldier
IS 'Foreign key naar tbmilcodestaldier.dnkey';
COMMENT ON COLUMN public.tbmilravbwl.dnkeymilcodebwl
IS 'Foreign key naar tbmilcodebwl.dnkey';
COMMENT ON COLUMN public.tbmilravbwl.ddvervaldatum
IS 'Datum dat combinatie vervallen is';
CREATE UNIQUE INDEX idu_tbmilravbwl_dnkeybwlstldr ON public.tbmilravbwl
USING btree (dnkeymilcodestaldier, dnkeymilcodebwl);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|