Romber

Database tables

romber_member.usernames

• Purpose
• Definition
• Constraints
• Load

Purpose

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

Definition

Source romber_usernames_tbl.sql

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

Constraints

Source romber_usernames_pk.sql

alter table romber_member.usernames
  add constraint romber_usernames_pk
    primary key ( username_id );

Source romber_usernames_fk1.sql

alter table romber_member.usernames
  add constraint romber_usernames_fk1
    foreign key ( username_id )
    references romber_meta.objects ( meta_object_id );

Source romber_usernames_fk2.sql

alter table romber_member.usernames
  add constraint romber_usernames_fk2
    foreign key ( username_type_id )
    references romber_member.username_types ( username_type_id );

Load

Source romber_usernames_load.sql

insert into romber_member.usernames (
    username_id,
    username_type_id )
  values (
    0,
    0 );