Romber

Database tables

Node Incarnations

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of node incarnations.

Definition

Source romber_node_incarnations_tbl.sql

create table romber_network.node_incarnations (
  node_incarnation_id                   romber_network.node_incarnation_id      not null
                                          default nextval ( 'romber_base.generic_id_seq' ),
  node_incarnation_begin_timestamp      romber_base.generic_timestamp           not null,
  node_incarnation_end_timestamp        romber_base.generic_timestamp           not null,
  node_instance_id                      romber_network.node_instance_id         not null );

Constraints

Source romber_node_incarnations_pk.sql

alter table romber_network.node_incarnations
  add constraint romber_node_incarnations_pk
    primary key ( node_incarnation_id );

Source romber_node_incarnations_uk1.sql

alter table romber_network.node_incarnations
  add constraint romber_node_incarnations_uk1
    unique (
      node_instance_id,
      node_incarnation_begin_timestamp );

Source romber_node_incarnations_fk1.sql

alter table romber_network.node_incarnations
  add constraint romber_node_incarnations_fk1
    foreign key ( node_instance_id )
    references romber_network.node_instances ( node_instance_id );