Romber

Database tables

romber_member.suppliers

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid suppliers.

Definition

Source romber_suppliers_tbl.sql

create table romber_member.suppliers (
  supplier_id           romber_member.relationship_id           not null );

Constraints

Source romber_suppliers_pk.sql

alter table romber_member.suppliers
  add constraint romber_suppliers_pk
    primary key ( supplier_id );

Source romber_suppliers_fk1.sql

alter table romber_member.suppliers
  add constraint romber_suppliers_fk1
    foreign key ( supplier_id )
    references romber_member.relationships ( member_relationship_id );

Load

Source romber_suppliers_load.sql

insert into romber_member.suppliers ( supplier_id )
  values ( 0 );