Romber

Database tables

romber_base.languages

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid languages in which pages may be presented. This information is static and doesn't need a data entry page.

Definition

Source romber_languages_tbl.sql

create table romber_base.languages (
  language_code         romber_base.generic_code        not null,
  language_id           romber_base.language_id         not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  language_name         romber_base.generic_name        not null );

Constraints

Source romber_languages_pk.sql

alter table romber_base.languages
  add constraint romber_languages_pk
    primary key ( language_id );

Source romber_languages_uk1.sql

alter table romber_base.languages
  add constraint romber_languages_uk1
    unique ( language_code );

Source romber_languages_fk1.sql

alter table romber_base.languages
  add constraint romber_languages_fk1
    foreign key ( language_id )
    references romber_meta.objects ( meta_object_id );

Load

Source romber_languages_load.sql