Romber

Database tables

romber_file.types

• Purpose
• Definition
• Constraints
• Load

Purpose

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

Definition

Source romber_file_types_tbl.sql

create table romber_file.types (
  file_type_code        romber_base.generic_code        not null,
  file_type_id          romber_file.type_id             not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  file_type_name        romber_base.generic_name        not null );

Constraints

Source romber_file_types_pk.sql

alter table romber_file.types
  add constraint romber_file_types_pk
    primary key ( file_type_id );

Source romber_file_types_uk1.sql

alter table romber_file.types
  add constraint romber_file_types_uk1
    unique ( file_type_code );

Load

Source romber_file_types_load.sql

insert into romber_file.types ( file_type_code, file_type_id, file_type_name )
  values ( '', 0, '' );

insert into romber_file.types ( file_type_code, file_type_name )
  values ( 'DATASTOREAREA', 'Data Store Area' );

insert into romber_file.types ( file_type_code, file_type_name )
  values ( 'DOCUMENT', 'Document' );

insert into romber_file.types ( file_type_code, file_type_name )
  values ( 'GENERIC', 'Generic' );