Romber

Database tables

romber_member.customers

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid customers.

Definition

Source romber_customers_tbl.sql

create table romber_member.customers (
  customer_id           romber_member.relationship_id           not null );

Constraints

Source romber_customers_pk.sql

alter table romber_member.customers
  add constraint romber_customers_pk
    primary key ( customer_id );

Source romber_customers_fk1.sql

alter table romber_member.customers
  add constraint romber_customers_fk1
    foreign key ( customer_id )
    references romber_member.relationships ( member_relationship_id );

Load

Source romber_customers_load.sql

insert into romber_member.customers ( customer_id )
  values ( 0 );