Datadictionary OpenWave 3.1.21 |
|
Table: tbrestflexfuncties
Datadictionary OpenWave 3.1.21 |
|
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
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)
)
WITH (oids = false);
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 2-10-2020 12:10 |
|