Romber

Database tables

romber_member.username_unix

• Purpose
• Definition
• Constraints

Purpose

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

Definition

Source romber_username_unix_tbl.sql

create table romber_member.username_unix (
  username_id           romber_member.username_id       not null,
  username_gid          int                     not null,
  username_uid          int                     not null );

Constraints

Source romber_username_unix_pk.sql

alter table romber_member.username_unix
  add constraint romber_username_unix_pk
    primary key ( username_id );

Source romber_username_unix_fk1.sql

alter table romber_member.username_unix
  add constraint romber_username_unix_fk1
    foreign key ( username_id )
    references romber_member.usernames ( username_id );