Romber

Database tables

romber_network.architectures

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid architectures. This information is static and doesn't need a data entry page.

Definition

Source romber_architectures_tbl.sql

create table romber_network.architectures (
  architecture_code     romber_base.generic_code        not null,
  architecture_id       romber_network.architecture_id  not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  architecture_name     romber_base.generic_name        not null,
  endian                char(1)                         not null
                          check ( endian in ( '', 'B', 'L' )),
  num_bits              smallint                        not null );

Constraints

Source romber_architectures_pk.sql

alter table romber_network.architectures
  add constraint romber_architectures_pk
    primary key ( architecture_id );

Source romber_architectures_uk1.sql

alter table romber_network.architectures
  add constraint romber_architectures_uk1
    unique ( architecture_code );

Load

Source romber_architectures_load.sql

insert into romber_network.architectures (
    architecture_code,
    architecture_id,
    architecture_name,
    endian,
    num_bits )
  values (
    '',
    0,
    '',
    '',
    0 );