Romber

Database tables

romber_network.operating_system_families

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid operating system families.

Definition

Source romber_operating_system_families_tbl.sql

create table romber_network.operating_system_families (
  operating_system_family_code  romber_base.generic_code                        not null,
  operating_system_family_id    romber_network.operating_system_family_id       not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  operating_system_family_name  romber_base.generic_name                        not null );

Constraints

Source romber_operating_system_families_pk.sql

alter table romber_network.operating_system_families
  add constraint romber_operating_system_families_pk
    primary key ( operating_system_family_id );

Source romber_operating_system_families_uk1.sql

alter table romber_network.operating_system_families
  add constraint romber_operating_system_families_uk1
    unique ( operating_system_family_code );

Source romber_operating_system_families_fk1.sql

alter table romber_network.operating_system_families
  add constraint romber_operating_system_families_fk1
    foreign key ( operating_system_family_id )
    references romber_meta.objects ( meta_object_id );

Load

Source romber_operating_system_families_load.sql