Romber

Database tables

romber_file.files

• Purpose
• Definition
• Constraints
• Load

Purpose

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

Definition

Source romber_files_tbl.sql

create table romber_file.files (
  file_id                       romber_file.file_id             not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  file_modified_timestamp       romber_base.generic_timestamp   not null,
  file_name                     romber_base.generic_file_path   not null,
  file_type_id                  romber_file.type_id             not null );

Constraints

Source romber_files_pk.sql

alter table romber_file.files
  add constraint romber_files_pk
    primary key ( file_id );

Source romber_files_fk1.sql

alter table romber_file.files
  add constraint romber_files_fk1
    foreign key ( file_type_id )
    references romber_file.types ( file_type_id );

Load

Source romber_files_load.sql

insert into romber_file.files (
    file_id,
    file_modified_timestamp,
    file_name,
    file_type_id )
  values (
    0,
    timestamp '1970-01-01 00:00:00.00',
    '',
    0 );