Datadictionary OpenWave 3.1.25 |
|
Table: tbqueries
Datadictionary OpenWave 3.1.25 |
|
Table: tbqueries
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met uitvoerbare SQL-ueries (OWB: vullen van tegelschermen)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbqueries_dnkey_seq'::regclass) |
Primary key. |
|
|
dvquery |
varchar(4000) |
|
|
|
|
SQL-statement |
|
|
dvauth_tablename |
varchar(40) |
|
|
|
|
Tabelnaam waar de authorisatie om de query uit te rollen staat |
|
|
dvauth_fieldname |
varchar(40) |
|
|
|
|
Veldnaam waar de authorisatie om de query uit te rollen staat |
|
|
dvcode |
varchar(40) |
|
|
|
|
Unieke code voor de query |
|
|
dlsystem |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan wordt de query verwijderd en opnieuw geleverd bij de updates van OpenWave database |
|
|
dnkeysysstandardcat |
integer |
|
|
|
|
Foreign key naar tbsysstandardcategorie. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_queries_keysysstcat |
dnkeysysstandardcat |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbqueries_dlsystem |
dlsystem = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
cnn_tbqueries_dlsystem |
dlsystem IS NOT NULL |
|
cnn_tbqueries_dvcode |
dvcode IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbqueries |
btree |
|
dnkey |
|
|
|
idu_tbqueries_dvcode |
btree |
|
dvcode |
|
|
|
idx_queries_keysysstcat |
btree |
|
dnkeysysstandardcat |
|
|
|
Triggers
There are no triggers for table tbqueries
Rules
There are no rules for table tbqueries
Policies
There are no policies for table tbqueries
Referenced
There are no tables referenced by table tbqueries
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvquery VARCHAR(4000),
dvauth_tablename VARCHAR(40),
dvauth_fieldname VARCHAR(40),
dvcode VARCHAR(40),
dlsystem CHAR(1) DEFAULT 'F'::bpchar,
dnkeysysstandardcat INTEGER,
CONSTRAINT cpk_tbqueries PRIMARY KEY(dnkey),
CONSTRAINT chk_tbqueries_dlsystem CHECK (dlsystem = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT cnn_tbqueries_dlsystem CHECK (dlsystem IS NOT NULL),
CONSTRAINT cnn_tbqueries_dvcode CHECK (dvcode IS NOT NULL),
CONSTRAINT cfk_queries_keysysstcat FOREIGN KEY (dnkeysysstandardcat)
REFERENCES public.tbsysstandardcategorie(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbqueries
IS 'Tabel met uitvoerbare SQL-ueries (OWB: vullen van tegelschermen)';
COMMENT ON COLUMN public.tbqueries.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbqueries.dvquery
IS 'SQL-statement';
COMMENT ON COLUMN public.tbqueries.dvauth_tablename
IS 'Tabelnaam waar de authorisatie om de query uit te rollen staat';
COMMENT ON COLUMN public.tbqueries.dvauth_fieldname
IS 'Veldnaam waar de authorisatie om de query uit te rollen staat';
COMMENT ON COLUMN public.tbqueries.dvcode
IS 'Unieke code voor de query';
COMMENT ON COLUMN public.tbqueries.dlsystem
IS 'T of F. Indien T dan wordt de query verwijderd en opnieuw geleverd bij de updates van OpenWave database ';
COMMENT ON COLUMN public.tbqueries.dnkeysysstandardcat
IS 'Foreign key naar tbsysstandardcategorie.';
CREATE UNIQUE INDEX idu_tbqueries_dvcode ON public.tbqueries
USING btree (dvcode COLLATE pg_catalog."default");
CREATE INDEX idx_queries_keysysstcat ON public.tbqueries
USING btree (dnkeysysstandardcat);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|