Romber

Database tables

romber_member.username_openvms

• Purpose
• Definition
• Constraints

Purpose

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

Definition

Source romber_username_openvms_tbl.sql

create table romber_member.username_openvms (
  username_id           romber_member.username_id               not null,
  username_uic          int                             not null );

Constraints

Source romber_username_openvms_pk.sql

alter table romber_member.username_openvms
  add constraint romber_username_openvms_pk
    primary key ( username_id );

Source romber_username_openvms_fk1.sql

alter table romber_member.username_openvms
  add constraint romber_username_openvms_fk1
    foreign key ( username_id )
    references romber_member.usernames ( username_id );