Romber

Database tables

romber_file.directory_files

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of files within directories. This information is highly dynamic and does need a data entry page.

Definition

Source romber_directory_files_tbl.sql

create table romber_file.directory_files (
  file_id               romber_file.file_id                     not null,
  directory_id          romber_file.directory_id                not null,
  valid_begin_timestamp romber_base.generic_timestamp           not null,
  valid_end_timestamp   romber_base.generic_timestamp           not null );

Constraints

Source romber_directory_files_pk.sql

alter table romber_file.directory_files
  add constraint romber_directory_files_pk
    primary key (
      directory_id,
      file_id,
      valid_begin_timestamp );

Source romber_directory_files_fk1.sql

alter table romber_file.directory_files
  add constraint romber_directory_files_fk1
    foreign key ( file_id )
    references romber_file.files ( file_id );

Source romber_directory_files_fk2.sql

alter table romber_file.directory_files
  add constraint romber_directory_files_fk2
    foreign key ( directory_id )
    references romber_file.directories ( directory_id );