Datadictionary OpenWave 3.1.32 |
|
Table: tbimportsleutels
Datadictionary OpenWave 3.1.32 |
|
Table: tbimportsleutels
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel waarmee foreignkeys tijdens bulkimport opgehaald kunnen worden
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbimportsleutels_dnkey_seq'::regclass) |
Primary key. |
|
|
dvtabelnaam |
varchar(50) |
|
|
|
|
Tabelnaam waarvan de foreign key waarde wordt gevraagd |
|
|
dvpointer |
varchar(50) |
|
|
|
|
De gevraagde foreignkeywaarde waarde |
|
|
dvimportsleutel |
varchar(200) |
|
|
|
|
De sleutel waarmee dvpointer gevonden kan worden in dvtabelnaam |
Foreign Keys
There are no foreign keys for table tbimportsleutels
Check Constraints
There are no check constraints for table tbimportsleutels
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbimportsleutels |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbimportsleutels
Rules
There are no rules for table tbimportsleutels
Policies
There are no policies for table tbimportsleutels
Referenced
There are no tables referenced by table tbimportsleutels
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvtabelnaam VARCHAR(50),
dvpointer VARCHAR(50),
dvimportsleutel VARCHAR(200),
CONSTRAINT cpk_tbimportsleutels PRIMARY KEY(dnkey)
) ;
COMMENT ON TABLE public.tbimportsleutels
IS 'Tabel waarmee foreignkeys tijdens bulkimport opgehaald kunnen worden';
COMMENT ON COLUMN public.tbimportsleutels.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbimportsleutels.dvtabelnaam
IS 'Tabelnaam waarvan de foreign key waarde wordt gevraagd';
COMMENT ON COLUMN public.tbimportsleutels.dvpointer
IS 'De gevraagde foreignkeywaarde waarde';
COMMENT ON COLUMN public.tbimportsleutels.dvimportsleutel
IS 'De sleutel waarmee dvpointer gevonden kan worden in dvtabelnaam';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|