<<

NAME

Koha::Schema::Result::MiscFile

TABLE: misc_files

ACCESSORS

file_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique id for the file record

table_tag

  data_type: 'varchar'
  is_nullable: 0
  size: 255

usually table name, or arbitrary unique tag

record_id

  data_type: 'integer'
  is_nullable: 0

record id from the table this file is associated to

file_name

  data_type: 'varchar'
  is_nullable: 0
  size: 255

file name

file_type

  data_type: 'varchar'
  is_nullable: 0
  size: 255

MIME type of the file

file_description

  data_type: 'varchar'
  is_nullable: 1
  size: 255

description given to the file

file_content

  data_type: 'longblob'
  is_nullable: 0

file content

date_uploaded

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

date and time the file was added

PRIMARY KEY

<<