Datadictionary OpenWave 3.1.32 |
|
Table: tbmilzwemlabanalyseregels
Datadictionary OpenWave 3.1.32 |
|
Table: tbmilzwemlabanalyseregels
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Detailregels van de laboratoria zwemanalyses
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilzwemlabanalyseregels_dnkey_seq'::regclass) |
|
|
|
dnkeyanalysekop |
integer |
|
|
|
|
|
|
|
dnkeyparameter |
integer |
|
|
|
|
|
|
|
dfmonsterwaarde |
double precision |
|
|
|
|
|
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilzwemlabanalyseregels_dnkeyanalysekop |
dnkeyanalysekop |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilzwemlabanalyseregels_dnkeyparameter |
dnkeyparameter |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmilzwemlabanalyseregels_dnkeyanalysekop |
dnkeyanalysekop IS NOT NULL |
|
cnn_tbmilzwemlabanalyseregels_dnkeyparameter |
dnkeyparameter IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilzwemlabanalyseregels |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbmilzwemlabanalyseregels
Rules
There are no rules for table tbmilzwemlabanalyseregels
Policies
There are no policies for table tbmilzwemlabanalyseregels
Referenced
There are no tables referenced by table tbmilzwemlabanalyseregels
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyanalysekop INTEGER,
dnkeyparameter INTEGER,
dfmonsterwaarde DOUBLE PRECISION,
CONSTRAINT cpk_tbmilzwemlabanalyseregels PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmilzwemlabanalyseregels_dnkeyanalysekop CHECK (dnkeyanalysekop IS NOT NULL),
CONSTRAINT cnn_tbmilzwemlabanalyseregels_dnkeyparameter CHECK (dnkeyparameter IS NOT NULL),
CONSTRAINT cfk_tbmilzwemlabanalyseregels_dnkeyanalysekop FOREIGN KEY (dnkeyanalysekop)
REFERENCES public.tbmilzwemlabanalysekop(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilzwemlabanalyseregels_dnkeyparameter FOREIGN KEY (dnkeyparameter)
REFERENCES public.tbmilzwemparameters(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilzwemlabanalyseregels
IS 'Detailregels van de laboratoria zwemanalyses';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|