Romber

Database tables

romber_meta.schemas

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of schemas. This information doesn't need a data entry page as it should only be populated by update scripts.

A schema is a set of metadata.

Definition

Source romber_meta_schemas_tbl.sql

create table romber_meta.schemas (
  meta_package_id       romber_meta.package_id          not null,
  meta_schema_code      romber_base.generic_code        not null,
  meta_schema_id        romber_meta.schema_id           not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  meta_schema_name      romber_base.generic_name        not null );

Constraints

Source romber_meta_schemas_pk.sql

alter table romber_meta.schemas
  add constraint romber_meta_schemas_pk
    primary key ( meta_schema_id );

Source romber_meta_schemas_uk1.sql

alter table romber_meta.schemas
  add constraint romber_meta_schemas_uk1
    unique ( meta_schema_code );

Source romber_meta_schemas_fk1.sql

alter table romber_meta.schemas
  add constraint romber_meta_schemas_fk1
    foreign key ( meta_package_id )
    references romber_meta.packages ( meta_package_id );

Load

Source romber_meta_schemas_load.sql

insert into romber_meta.schemas (
    meta_package_id,
    meta_schema_code,
    meta_schema_id,
    meta_schema_name )
  values (
    0,
    '',
    0,
    '' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values ( 0, 'PUBLIC', 'Public' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_ASSET',
    'Romber assets' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_BASE',
    'Romber base' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_COMMUNICATION',
    'Romber communications' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_FILE',
    'Romber files' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_FINANCIAL',
    'Romber finacials' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_ITEM',
    'Romber items' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_LEGACY',
    'Romber legacy data' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_LOCATION',
    'Romber locations' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_MEMBER',
    'Romber members' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_META',
    'Romber meta' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_NETWORK',
    'Romber networks' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_PAGE',
    'Romber pages' );

insert into romber_meta.schemas ( meta_package_id, meta_schema_code, meta_schema_name )
  values (
    ( select meta_package_id from romber_meta.packages where meta_package_code = 'ROMBER' ),
    'ROMBER_TELECOMM',
    'Romber telecommunications' );