Romber

Database tables

romber_communication.lists

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of communication lists.

Definition

Source romber_communication_lists_tbl.sql

create table romber_communication.lists (
  communication_list_code       romber_base.generic_code                not null,
  communication_list_id         romber_communication.list_id            not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  communication_list_name       romber_base.generic_name                not null,
  communication_list_status_id  romber_communication.list_status_id     not null,
  communication_list_type_id    romber_communication.list_type_id       not null );

Constraints

Source romber_communication_lists_pk.sql

alter table romber_communication.lists
  add constraint romber_communication_lists_pk
    primary key ( communication_list_id );

Source romber_communication_lists_uk1.sql

alter table romber_communication.lists
  add constraint romber_communication_lists_uk1
    unique ( communication_list_code );

Source romber_communication_lists_fk1.sql

alter table romber_communication.lists
  add constraint romber_communication_lists_fk1
    foreign key ( communication_list_id )
    references romber_meta.objects ( meta_object_id );

Source romber_communication_lists_fk2.sql

alter table romber_communication.lists
  add constraint romber_communication_lists_fk2
    foreign key ( communication_list_status_id )
    references romber_communication.list_statuses ( communication_list_status_id );

Source romber_communication_lists_fk3.sql

alter table romber_communication.lists
  add constraint romber_communication_lists_fk3
    foreign key ( communication_list_type_id )
    references romber_communication.list_types ( communication_list_type_id );

Load

Source romber_communication_lists_load.sql