Datadictionary OpenWave 3.1.25 |
|
Table: tbaudit
Datadictionary OpenWave 3.1.25 |
|
Table: tbaudit
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met audit-trail
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbaudit_dnkey_seq'::regclass) |
Primary key. |
|
|
ddtimestamp |
timestamp |
|
|
|
|
Datum en tijd |
|
|
dvcodemw |
char(5) |
|
|
|
|
Medewerker: tbmedewerkers.dvcode |
|
|
dvtablename |
varchar(30) |
|
|
|
|
Tabelnaam |
|
|
dvpointer |
varchar(50) |
|
|
|
|
Primary key van tabelnaam |
|
|
dvaction |
char(1) |
|
|
|
|
(Edit), (I)nsert of (D)elete |
|
|
dvfieldname |
varchar(30) |
|
|
|
|
Veldnaam uit tabelnaam |
|
|
dvvalue |
varchar(4000) |
|
|
|
|
Nieuwe waarde van veldnaam |
|
|
dvlocation |
varchar(1000) |
|
|
|
|
Devicelocatie waarvanuit de wijziging s gemaakt |
Foreign Keys
There are no foreign keys for table tbaudit
Check Constraints
There are no check constraints for table tbaudit
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbaudit |
btree |
|
dnkey |
|
|
|
idx_audit_ddtimestamp |
btree |
|
ddtimestamp |
|
|
|
idx_audit_dvcodemw |
btree |
|
dvcodemw |
|
|
|
Triggers
There are no triggers for table tbaudit
Rules
There are no rules for table tbaudit
Policies
There are no policies for table tbaudit
Referenced
There are no tables referenced by table tbaudit
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
ddtimestamp TIMESTAMP WITHOUT TIME ZONE,
dvcodemw CHAR(5),
dvtablename VARCHAR(30),
dvpointer VARCHAR(50),
dvaction CHAR(1),
dvfieldname VARCHAR(30),
dvvalue VARCHAR(4000),
dvlocation VARCHAR(1000),
CONSTRAINT cpk_tbaudit PRIMARY KEY(dnkey)
) ;
COMMENT ON TABLE public.tbaudit
IS 'Tabel met audit-trail';
COMMENT ON COLUMN public.tbaudit.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbaudit.ddtimestamp
IS 'Datum en tijd';
COMMENT ON COLUMN public.tbaudit.dvcodemw
IS 'Medewerker: tbmedewerkers.dvcode';
COMMENT ON COLUMN public.tbaudit.dvtablename
IS 'Tabelnaam';
COMMENT ON COLUMN public.tbaudit.dvpointer
IS 'Primary key van tabelnaam';
COMMENT ON COLUMN public.tbaudit.dvaction
IS '(Edit), (I)nsert of (D)elete';
COMMENT ON COLUMN public.tbaudit.dvfieldname
IS 'Veldnaam uit tabelnaam';
COMMENT ON COLUMN public.tbaudit.dvvalue
IS 'Nieuwe waarde van veldnaam';
COMMENT ON COLUMN public.tbaudit.dvlocation
IS 'Devicelocatie waarvanuit de wijziging s gemaakt';
CREATE INDEX idx_audit_ddtimestamp ON public.tbaudit
USING btree (ddtimestamp);
CREATE INDEX idx_audit_dvcodemw ON public.tbaudit
USING btree (dvcodemw COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|