Datadictionary OpenWave 3.1.11 |
|
Table: tbaudit
Datadictionary OpenWave 3.1.11 |
|
Table: tbaudit
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met audittrail
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
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)
)
WITH (oids = false);
COMMENT ON TABLE public.tbaudit
IS 'Tabel met audittrail';
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 22-2-2017 10:50 |
|