Romber

Database tables

romber_network.operating_system_distributions

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid operating system distributions.

Definition

Source romber_operating_system_distributions_tbl.sql

create table romber_network.operating_system_distributions (
  operating_system_distribution_code    romber_base.generic_code                        not null,
  operating_system_distribution_id      romber_network.operating_system_distribution_id not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  operating_system_distribution_name    romber_base.generic_name                        not null,
  operating_system_family_id            romber_network.operating_system_family_id       not null );

Constraints

Source romber_operating_system_distributions_pk.sql

alter table romber_network.operating_system_distributions
  add constraint romber_operating_system_distributions_pk
    primary key ( operating_system_distribution_id );

Source romber_operating_system_distributions_uk1.sql

alter table romber_network.operating_system_distributions
  add constraint romber_operating_system_distributions_uk1
    unique ( operating_system_distribution_code );

Source romber_operating_system_distributions_fk1.sql

alter table romber_network.operating_system_distributions
  add constraint romber_operating_system_distributions_fk1
    foreign key ( operating_system_distribution_id )
    references romber_meta.objects ( meta_object_id );

Source romber_operating_system_distributions_fk2.sql

alter table romber_network.operating_system_distributions
  add constraint romber_operating_system_distributions_fk2
    foreign key ( operating_system_family_id )
    references romber_network.operating_system_families ( operating_system_family_id );

Load

Source romber_operating_system_distributions_load.sql