Datadictionary OpenWave 3.1.32 |
|
Table: tbtoestmbadetailsactiviteiten
Datadictionary OpenWave 3.1.32 |
|
Table: tbtoestmbadetailsactiviteiten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Dochtertabel van tbtoestemmingen gevuld met detailsactiviteiten (MBA) uit tbmbadetailsactiviteiten
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbtoestmbadetailsactiviteiten_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeytoestemmingen |
integer |
|
|
|
|
Foreign key naar tbtoestemmingen.dnkey |
|
|
dnkeymbadetailsactiviteiten |
integer |
|
|
|
|
Foreign key naar tbmbadetailsactiviteiten.dnkey |
|
|
dvopmerking |
varchar(2000) |
|
|
|
|
Opmerking bij de gekozen detailsactiviteit |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbtoestmbadetailsactiviteiten_dnkeymbadetailsactiviteiten |
dnkeymbadetailsactiviteiten |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbtoestmbadetailsactiviteiten_dnkeytoestemming |
dnkeytoestemmingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbtoestmbadetailsactiviteiten_dnkeymbadetailsactiviteiten |
dnkeymbadetailsactiviteiten IS NOT NULL |
|
cnn_tbtoestmbadetailsactiviteiten_dnkeytoestemming |
dnkeytoestemmingen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbtoestmbadetailsactiviteiten |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbtoestmbadetailsactiviteiten
Rules
There are no rules for table tbtoestmbadetailsactiviteiten
Policies
There are no policies for table tbtoestmbadetailsactiviteiten
Referenced
There are no tables referenced by table tbtoestmbadetailsactiviteiten
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeytoestemmingen INTEGER,
dnkeymbadetailsactiviteiten INTEGER,
dvopmerking VARCHAR(2000),
CONSTRAINT cpk_tbtoestmbadetailsactiviteiten PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbtoestmbadetailsactiviteiten_dnkeymbadetailsactiviteiten CHECK (dnkeymbadetailsactiviteiten IS NOT NULL),
CONSTRAINT cnn_tbtoestmbadetailsactiviteiten_dnkeytoestemming CHECK (dnkeytoestemmingen IS NOT NULL),
CONSTRAINT cfk_tbtoestmbadetailsactiviteiten_dnkeymbadetailsactiviteiten FOREIGN KEY (dnkeymbadetailsactiviteiten)
REFERENCES public.tbmbadetailsactiviteiten(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbtoestmbadetailsactiviteiten_dnkeytoestemming FOREIGN KEY (dnkeytoestemmingen)
REFERENCES public.tbtoestemmingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbtoestmbadetailsactiviteiten
IS 'Dochtertabel van tbtoestemmingen gevuld met detailsactiviteiten (MBA) uit tbmbadetailsactiviteiten';
COMMENT ON COLUMN public.tbtoestmbadetailsactiviteiten.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbtoestmbadetailsactiviteiten.dnkeytoestemmingen
IS 'Foreign key naar tbtoestemmingen.dnkey';
COMMENT ON COLUMN public.tbtoestmbadetailsactiviteiten.dnkeymbadetailsactiviteiten
IS 'Foreign key naar tbmbadetailsactiviteiten.dnkey';
COMMENT ON COLUMN public.tbtoestmbadetailsactiviteiten.dvopmerking
IS 'Opmerking bij de gekozen detailsactiviteit';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|