Romber

Database tables

romber_meta.class_properties

• Purpose
• Definition
• Constraints

Purpose

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

Definition

Source romber_meta_class_properties_tbl.sql

create table romber_meta.class_properties (
  meta_class_id         romber_meta.class_id    not null,
  meta_property_id      romber_meta.property_id not null );

Constraints

Source romber_meta_class_properties_pk.sql

alter table romber_meta.class_properties
  add constraint romber_meta_class_properties_pk
    primary key (
      meta_class_id,
      meta_property_id );

Source romber_meta_class_properties_fk1.sql

alter table romber_meta.class_properties
  add constraint romber_meta_class_properties_fk1
    foreign key ( meta_class_id )
    references romber_meta.classes ( meta_class_id );

Source romber_meta_class_properties_fk2.sql

alter table romber_meta.class_properties
  add constraint romber_meta_class_properties_fk2
    foreign key ( meta_property_id )
    references romber_meta.properties ( meta_property_id );