Romber

Database tables

romber_base.businesses

• Purpose
• Definition
• Constraints
• Load

Purpose

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

Most dynamic tables such as usernames are associated with a given business.

Definition

Source romber_businesses_tbl.sql

create table romber_base.businesses (
  meta_virtual_enterprise_id    romber_meta.virtual_enterprise_id       not null,
  business_code                 romber_base.generic_code                not null,
  business_id                   romber_base.business_id                 not null,
  business_name                 romber_base.generic_name                not null );

Constraints

Source romber_businesses_pk.sql

alter table romber_base.businesses
  add constraint romber_businesses_pk
    primary key ( business_id );

Source romber_businesses_uk1.sql

alter table romber_base.businesses
  add constraint romber_businesses_uk1
    unique ( business_code );

Source romber_businesses_fk1.sql

alter table romber_base.businesses
  add constraint romber_businesses_fk1
    foreign key ( meta_virtual_enterprise_id )
    references romber_meta.virtual_enterprises ( meta_virtual_enterprise_id );

Source romber_businesses_fk2.sql

alter table romber_base.businesses
  add constraint romber_businesses_fk2
    foreign key ( business_id )
    references romber_member.relationships ( member_relationship_id );

Load

Source romber_businesses_load.sql

insert into romber_base.businesses (
    meta_virtual_enterprise_id, business_code, business_id, business_name )
  values ( 0, '', 0, '' );