Romber

Database tables

romber_network.applications

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid applications.

An application is software.

Definition

Source romber_applications_tbl.sql

create table romber_network.applications (
  application_code              romber_base.generic_code        not null,
  application_id                romber_network.application_id   not null,
  application_name              romber_base.generic_name        not null,
  customer_id                   romber_member.relationship_id   not null );

Constraints

Source romber_applications_pk.sql

alter table romber_network.applications
  add constraint romber_applications_pk
    primary key ( application_id );

Source romber_applications_uk1.sql

alter table romber_network.applications
  add constraint romber_applications_uk1
    unique ( application_code );

Source romber_applications_fk1.sql

alter table romber_network.applications
  add constraint romber_applications_fk1
    foreign key ( application_id )
    references romber_meta.objects ( meta_object_id );

Source romber_applications_fk2.sql

alter table romber_network.applications
  add constraint romber_applications_fk2
    foreign key ( customer_id )
    references romber_member.customers ( customer_id );

Load

Source romber_applications_load.sql