Datadictionary OpenWave 3.1.25 |
|
Table: tbsubproducten
Datadictionary OpenWave 3.1.25 |
|
Table: tbsubproducten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met subproductdefinities (code en omschrijving)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbsubproducten_dnkey_seq'::regclass) |
Primary key. |
|
|
dvsubproductoms |
varchar(200) |
|
|
|
|
Omschrijving van subproduct |
|
|
dvsubproductcode |
varchar(40) |
|
|
|
|
Codering van subproduct |
|
|
ddvervallen |
timestamp |
|
|
|
|
Datum dat subproduct is komen te vervallen. |
Foreign Keys
There are no foreign keys for table tbsubproducten
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbsubproducten_dvcode |
dvsubproductcode IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbsubproducten |
btree |
|
dnkey |
|
|
|
idu_subproducten_code |
btree |
|
dvsubproductcode |
|
|
|
Triggers
There are no triggers for table tbsubproducten
Rules
There are no rules for table tbsubproducten
Policies
There are no policies for table tbsubproducten
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbhandh_keysubprod |
dnkeysubproducten |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbhorverg_keysubprod |
dnkeysubproducten |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbinfoav_keysubprod |
dnkeysubproducten |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbmilverg_keysubprod |
dnkeysubproducten |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbomgverg_keysubprod |
dnkeysubproducten |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbovverg_keysubprod |
dnkeysubproducten |
dnkey |
No Action |
No Action |
|
Immediate |
|
||
public |
cfk_tbprodwkpklant_keysubpr |
dnkeysubproducten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_tbsubproddef_keysubprod |
dnkeysubproducten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_tbzaakprod_keysubprod |
dnkeysubproducten |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvsubproductoms VARCHAR(200),
dvsubproductcode VARCHAR(40),
ddvervallen TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbsubproducten PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbsubproducten_dvcode CHECK (dvsubproductcode IS NOT NULL)
) ;
COMMENT ON TABLE public.tbsubproducten
IS 'Tabel met subproductdefinities (code en omschrijving)';
COMMENT ON COLUMN public.tbsubproducten.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbsubproducten.dvsubproductoms
IS 'Omschrijving van subproduct';
COMMENT ON COLUMN public.tbsubproducten.dvsubproductcode
IS 'Codering van subproduct';
COMMENT ON COLUMN public.tbsubproducten.ddvervallen
IS 'Datum dat subproduct is komen te vervallen.';
CREATE UNIQUE INDEX idu_subproducten_code ON public.tbsubproducten
USING btree (dvsubproductcode COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|