Datadictionary OpenWave 3.1.25 |
|
Table: tbmedewtiles
Datadictionary OpenWave 3.1.25 |
|
Table: tbmedewtiles
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel van medewerkers en tbportaltiles (OWB)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmedewtiles_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyportaltiles |
integer |
|
|
|
|
Foreign key naar tbportaltiles.dnkey. |
|
|
dvcodemedewerkers |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmedewtil_codemedew |
dvcodemedewerkers |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmedewtil_keyprtaltiles |
dnkeyportaltiles |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbmedewtiles
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmedewtiles |
btree |
|
dnkey |
|
|
|
idu_medewtiles_tilemew |
btree |
|
dvcodemedewerkers, dnkeyportaltiles |
|
|
|
Triggers
There are no triggers for table tbmedewtiles
Rules
There are no rules for table tbmedewtiles
Policies
There are no policies for table tbmedewtiles
Referenced
There are no tables referenced by table tbmedewtiles
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyportaltiles INTEGER,
dvcodemedewerkers CHAR(5),
CONSTRAINT cpk_tbmedewtiles PRIMARY KEY(dnkey),
CONSTRAINT cfk_tbmedewtil_codemedew FOREIGN KEY (dvcodemedewerkers)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmedewtil_keyprtaltiles FOREIGN KEY (dnkeyportaltiles)
REFERENCES public.tbportaltiles(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmedewtiles
IS 'Koppeltabel van medewerkers en tbportaltiles (OWB)';
COMMENT ON COLUMN public.tbmedewtiles.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmedewtiles.dnkeyportaltiles
IS 'Foreign key naar tbportaltiles.dnkey.';
COMMENT ON COLUMN public.tbmedewtiles.dvcodemedewerkers
IS 'Foreign key naar tbmedewerkers.dvcode.';
CREATE UNIQUE INDEX idu_medewtiles_tilemew ON public.tbmedewtiles
USING btree (dvcodemedewerkers COLLATE pg_catalog."default", dnkeyportaltiles);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|