Romber

Database tables

romber_meta.object__versions

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid meta object__versions. This information hightly dynamic, but doesn't need a data entry page.

Definition

Source romber_meta_object__versions_tbl.sql

create table romber_meta.object__versions (
  meta_object_id                romber_meta.object_id                   not null,
  meta_security_model_id        romber_meta.security_model_id           not null,
  meta_transaction_id           romber_meta.transaction_id              not null,
  valid_begin_timestamp         romber_base.generic_timestamp           not null,
  valid_end_timestamp           romber_base.generic_timestamp           not null,
  version_begin_timestamp       romber_base.generic_timestamp           not null,
  version_end_timestamp         romber_base.generic_timestamp           not null );

Constraints

Source romber_meta_object__versions_pk.sql

alter table romber_meta.object__versions
  add constraint romber_meta_object__versions_pk
    primary key (
      meta_object_id,
      meta_transaction_id );

Source romber_meta_object__versions_fk1.sql

alter table romber_meta.object__versions
  add constraint romber_meta_object__versions_fk1
    foreign key ( meta_object_id )
    references romber_meta.objects ( meta_object_id );

Source romber_meta_object__versions_fk2.sql

alter table romber_meta.object__versions
  add constraint romber_meta_object__versions_fk2
    foreign key ( meta_security_model_id )
    references romber_meta.security_models ( meta_security_model_id );

Source romber_meta_object__versions_fk3.sql

alter table romber_meta.object__versions
  add constraint romber_meta_object__versions_fk3
    foreign key ( meta_transaction_id )
    references romber_meta.transactions ( meta_transaction_id );

Source romber_meta_object__versions_ck1.sql

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

Load

Source romber_meta_object__versions_load.sql

insert into romber_meta.object__versions (
    meta_object_id,
    meta_security_model_id,
    meta_transaction_id,
    valid_begin_timestamp,
    valid_end_timestamp,
    version_begin_timestamp,
    version_end_timestamp )
  values (
    0,
    0,
    0,
    timestamp '1858-11-17 00:00:00.00',
    timestamp '9999-12-13 00:00:00.00',
    timestamp '1858-11-17 00:00:00.00',
    timestamp '9999-12-13 00:00:00.00' );