Romber

Database tables

romber_file.directories

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of directories. This information is a base class and doesn't needs a load script or data entry page.

Definition

Source romber_directories_tbl.sql

create table romber_file.directories (
  directory_id          romber_file.directory_id        not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  directory_path        romber_base.generic_file_path   not null );

Constraints

Source romber_directories_pk.sql

alter table romber_file.directories
  add constraint romber_directories_pk
    primary key ( directory_id );

Source romber_directories_uk1.sql

alter table romber_file.directories
  add constraint romber_directories_uk1 unique ( directory_path );

Load

Source romber_directories_load.sql

insert into romber_file.directories (
    directory_id,
    directory_path )
  values (
    0,
    '' );