Romber

Database tables

romber_meta.session_data

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid session data. This information is managed in association with webservices and doesn't need a data entry page.

Definition

Source romber_meta_session_data_tbl.sql

create table romber_meta.session_data (
  meta_session_id               romber_meta.session_id          not null,
  session_data_code             romber_base.generic_code        not null,
  session_data_value_number     int                             not null,
  session_data_value_text       varchar(511)                    not null );

Constraints

Source romber_meta_session_data_pk.sql

alter table romber_meta.session_data
  add constraint romber_meta_session_data_pk
    primary key (
      meta_session_id,
      session_data_code );

Source romber_meta_session_data_fk1.sql

alter table romber_meta.session_data
  add constraint romber_meta_session_data_fk1
    foreign key ( meta_session_id )
    references romber_meta.sessions ( meta_session_id );