Romber

Database tables

romber_network.operating_system_versions

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of operating system versions.

Definition

Source romber_operating_system_versions_tbl.sql

create table romber_network.operating_system_versions (
  operating_system_distribution_id      romber_network.operating_system_distribution_id not null,
  operating_system_version_id           romber_network.operating_system_version_id      not null
                                          default nextval ( 'romber_base.generic_id_seq' ),
  version_major                         smallint                                        not null,
  version_minor                         smallint                                        not null,
  version_update                        smallint                                        not null );

Constraints

Source romber_operating_system_versions_pk.sql

alter table romber_network.operating_system_versions
  add constraint romber_operating_system_versions_pk
    primary key ( operating_system_version_id );

Source romber_operating_system_versions_uk1.sql

alter table romber_network.operating_system_versions
  add constraint romber_operating_system_versions_uk1
    unique (
      operating_system_distribution_id,
      version_major,
      version_minor,
      version_update );

Source romber_operating_system_versions_fk1.sql

alter table romber_network.operating_system_versions
  add constraint romber_operating_system_versions_fk1
    foreign key ( operating_system_version_id )
    references romber_meta.objects ( meta_object_id );

Source romber_operating_system_versions_fk2.sql

alter table romber_network.operating_system_versions
  add constraint romber_operating_system_versions_fk2
    foreign key ( operating_system_distribution_id )
    references romber_network.operating_system_distributions ( operating_system_distribution_id );

Load

Source romber_operating_system_versions_load.sql