Romber

Database tables

romber_meta.object__audits

• Purpose
• Definition
• Constraints

Purpose

This table contains meta object audits. This information hightly dynamic, but doesn't need a data entry page.

Definition

Source romber_meta_object__audits_tbl.sql

create table romber_meta.object__audits (
  audit_data                    varchar(4094)                           not null,
  meta_audit_type_id            romber_meta.audit_type_id               not null,
  meta_object_id                romber_meta.object_id                   not null,
  meta_transaction_id           romber_meta.transaction_id              not null );

Constraints

Source romber_meta_object__audits_pk.sql

alter table romber_meta.object__audits
  add constraint romber_meta_object__audits_pk
    primary key (
      meta_object_id,
      meta_transaction_id,
      meta_audit_type_id );

Source romber_meta_object__audits_fk1.sql

alter table romber_meta.object__audits
  add constraint romber_meta_object__audits_fk1
    foreign key ( meta_object_id )
    references romber_meta.objects ( meta_object_id );

Source romber_meta_object__audits_fk2.sql

alter table romber_meta.object__audits
  add constraint romber_meta_object__audits_fk2
    foreign key ( meta_transaction_id )
    references romber_meta.transactions ( meta_transaction_id );

Source romber_meta_object__audits_fk3.sql

alter table romber_meta.object__audits
  add constraint romber_meta_object__audits_fk3
    foreign key ( meta_audit_type_id )
    references romber_meta.audit_types ( meta_audit_type_id );

Source romber_meta_object__audits_ck1.sql

alter table romber_meta.object__audits
  add constraint romber_meta_object__audits_ck1
    check ( not ( meta_object_id = 0 and meta_transaction_id <> 0 ));