Romber

Database tables

romber_meta.table_columns

• Purpose
• Definition
• Constraints

Purpose

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

Definition

Source romber_meta_table_columns_tbl.sql

create table romber_meta.table_columns (
  meta_table_id         romber_meta.table_id            not null,
  meta_column_code      romber_base.generic_code        not null );

Constraints

Source romber_meta_table_columns_pk.sql

alter table romber_meta.table_columns
  add constraint romber_meta_table_columns_pk
    primary key (
      meta_table_id,
      meta_column_code );