Romber

Database tables

romber_file.import_files

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of import files. This information is loaded by a script and doesn't need a data entry page.

Definition

Source romber_import_files_tbl.sql

create table romber_file.import_files (
  import_file_id                        romber_file.import_file_id      not null
                                          default nextval ( 'romber_base.generic_id_seq' ),
  import_file_modified_timestamp        romber_base.generic_timestamp   not null,
  import_file_path                      romber_base.generic_file_path   not null );

Constraints

Source romber_import_files_pk.sql

alter table romber_file.import_files
  add constraint romber_import_files_pk
    primary key ( import_file_id );

Source romber_import_files_uk1.sql

alter table romber_file.import_files
  add constraint romber_import_files_uk1
    unique (
      import_file_path,
      import_file_modified_timestamp );

Load

Source romber_import_files_load.sql

insert into romber_file.import_files (
    import_file_id,
    import_file_modified_timestamp,
    import_file_path )
  values (
    0,
    timestamp '1970-01-01 00:00:00.00',
    '' );