Datadictionary OpenWave 3.1.25 |
|
Table: tbrestflexfuncties
Datadictionary OpenWave 3.1.25 |
|
Table: tbrestflexfuncties
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met (flex) functies aan te roepen door REST-service
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbrestflexfuncties_dnkey_seq'::regclass) |
Primary key |
|
|
dvcode |
varchar(40) |
|
|
|
|
Unieke code die de aanroep defineert bijv TrackNTraceW |
|
|
dvaanroep |
varchar(2000) |
|
|
|
|
De flexfunctie die de Restservice zal aanroepen bijv getFlexDetail(SysStandardDetail,{strDecrypt(arg1)},rest_trackandtrace_W) |
Foreign Keys
There are no foreign keys for table tbrestflexfuncties
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_restflexfuncties_dvcode |
dvcode IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbrestflexfuncties |
btree |
|
dnkey |
|
|
|
idu_tbrestflexfuncties_code |
btree |
|
(lower((dvcode)::text)) |
|
|
|
Triggers
There are no triggers for table tbrestflexfuncties
Rules
There are no rules for table tbrestflexfuncties
Policies
There are no policies for table tbrestflexfuncties
Referenced
There are no tables referenced by table tbrestflexfuncties
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcode VARCHAR(40),
dvaanroep VARCHAR(2000),
CONSTRAINT cpk_tbrestflexfuncties PRIMARY KEY(dnkey),
CONSTRAINT cnn_restflexfuncties_dvcode CHECK (dvcode IS NOT NULL)
) ;
COMMENT ON TABLE public.tbrestflexfuncties
IS 'Tabel met (flex) functies aan te roepen door REST-service';
COMMENT ON COLUMN public.tbrestflexfuncties.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbrestflexfuncties.dvcode
IS 'Unieke code die de aanroep defineert bijv TrackNTraceW';
COMMENT ON COLUMN public.tbrestflexfuncties.dvaanroep
IS 'De flexfunctie die de Restservice zal aanroepen bijv getFlexDetail(SysStandardDetail,{strDecrypt(arg1)},rest_trackandtrace_W)';
CREATE UNIQUE INDEX idu_tbrestflexfuncties_code ON public.tbrestflexfuncties
USING btree ((lower((dvcode)::text)) COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|