Romber

Database tables

romber_network.environment_types

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid environment types.

An environment type is a resource collection category.

Definition

Source romber_environment_types_tbl.sql

create table romber_network.environment_types (
  branch_or_not                 boolean                                 not null,
  default_environment_code      romber_base.generic_code                not null,
  environment_type_code         romber_base.generic_code                not null,
  environment_type_id           romber_network.environment_type_id      not null,
  environment_type_name         romber_base.generic_name                not null,
  scope_flags                   smallint                                not null
                                  check ( scope_flags between 0 and 3 ),
  variants_or_not               boolean                                 not null,
  versions_or_not               boolean                                 not null );

Constraints

Source romber_environment_types_pk.sql

alter table romber_network.environment_types
  add constraint romber_environment_types_pk
    primary key ( environment_type_id );

Source romber_environment_types_uk1.sql

alter table romber_network.environment_types
  add constraint romber_environment_types_uk1
    unique ( environment_type_code );

Source romber_environment_types_fk1.sql

alter table romber_network.environment_types
  add constraint romber_environment_types_fk1
    foreign key ( environment_type_id )
    references romber_meta.objects ( meta_object_id );

Load

Source romber_environment_types_load.sql