Romber

Database tables

romber_meta.class_operations

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid meta class operations. This information is static and doesn't need a data entry page.

Definition

Source romber_meta_class_operations_tbl.sql

create table romber_meta.class_operations (
  meta_class_id                 romber_meta.class_id            not null,
  meta_operation_id             romber_meta.operation_id        not null,
  meta_security_model_id        romber_meta.security_model_id   not null );

Constraints

Source romber_meta_class_operations_pk.sql

alter table romber_meta.class_operations
  add constraint romber_meta_class_operations_pk
    primary key (
      meta_class_id,
      meta_operation_id );

Source romber_meta_class_operations_fk1.sql

alter table romber_meta.class_operations
  add constraint romber_meta_class_operations_fk1
    foreign key ( meta_class_id )
    references romber_meta.classes ( meta_class_id );

Source romber_meta_class_operations_fk2.sql

alter table romber_meta.class_operations
  add constraint romber_meta_class_operations_fk2
    foreign key ( meta_operation_id )
    references romber_meta.operations ( meta_operation_id );

Source romber_meta_class_operations_fk3.sql

alter table romber_meta.class_operations
  add constraint romber_meta_class_operations_fk3
    foreign key ( meta_security_model_id )
    references romber_meta.security_models ( meta_security_model_id );