Romber

Database tables

romber_member.username_virtuals

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid virtual usernames. This information is dynamic and does need a data entry page.

Definition

Source romber_username_virtuals_tbl.sql

create table romber_member.username_virtuals (
  username_id           romber_member.username_id       not null,
  username_virtual_id   romber_member.username_id       not null
                          default nextval ( 'romber_base.generic_id_seq' ) );

Constraints

Source romber_username_virtuals_pk.sql

alter table romber_member.username_virtuals
  add constraint romber_username_virtuals_pk
    primary key (
      username_virtual_id );

Source romber_username_virtuals_fk1.sql

alter table romber_member.username_virtuals
  add constraint romber_username_virtuals_fk1
    foreign key ( username_virtual_id )
    references romber_meta.objects ( meta_object_id );

Source romber_username_virtuals_fk2.sql

alter table romber_member.username_virtuals
  add constraint romber_username_virtuals_fk2
    foreign key ( username_id )
    references romber_member.usernames ( username_id );

Source romber_username_virtuals_ck1.sql

alter table romber_member.username_virtuals
  add constraint romber_username_virtuals_ck1
    check ( username_virtual_id > 0 );