Datadictionary OpenWave 3.1.25 |
|
Table: tbproductklanten
Datadictionary OpenWave 3.1.25 |
|
Table: tbproductklanten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met klanten (betalers) zoals gemeentes waarvoor een product is uitgeveord. In de tabel tbprodwkpklant ligt de samenhang tussen tbproducten en tbproducwerkpakketten en tbproducklanten
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbproductklanten_dnkey_seq'::regclass) |
Primary key. |
|
|
dvklantoms |
varchar(200) |
|
|
|
|
Beschrijving van klant. |
|
|
dvklantcode |
varchar(40) |
|
|
|
|
Codering in tijdscrijf/financeel systeem voor de betalende klant |
|
|
ddvervallen |
timestamp |
|
|
|
|
Datum dat klant is komen te vervallen. |
Foreign Keys
There are no foreign keys for table tbproductklanten
Check Constraints
There are no check constraints for table tbproductklanten
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbproductklanten |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbproductklanten
Rules
There are no rules for table tbproductklanten
Policies
There are no policies for table tbproductklanten
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_handh_keyproductklanten |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
||
public |
cfk_horverg_keyproductklanten |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
||
public |
cfk_infoavrg_keyproductklanten |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
||
public |
cfk_milverg_keyproductklanten |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
||
public |
cfk_omgverg_keyproductklanten |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
||
public |
cfk_ovverg_keyproductklanten |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
||
public |
cfk_prodwkpklant_keyprodklant |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
||
public |
cfk_zaakprod_keyproductklanten |
dnkeyproductklanten |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvklantoms VARCHAR(200),
dvklantcode VARCHAR(40),
ddvervallen TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbproductklanten PRIMARY KEY(dnkey)
) ;
COMMENT ON TABLE public.tbproductklanten
IS 'Tabel met klanten (betalers) zoals gemeentes waarvoor een product is uitgeveord. In de tabel tbprodwkpklant ligt de samenhang tussen tbproducten en tbproducwerkpakketten en tbproducklanten';
COMMENT ON COLUMN public.tbproductklanten.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbproductklanten.dvklantoms
IS 'Beschrijving van klant.';
COMMENT ON COLUMN public.tbproductklanten.dvklantcode
IS 'Codering in tijdscrijf/financeel systeem voor de betalende klant';
COMMENT ON COLUMN public.tbproductklanten.ddvervallen
IS 'Datum dat klant is komen te vervallen.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|