AudioFerret/v2/cut x file

About

• Purpose: maps correspondence between cuts and files. Most of the time this will be 1:1, but frequently a single file will contain multiple cuts; a single cut can also be represented by different files (e.g. different encodings, or different analogue sources).
• Relates to: cuts, files
• Fields:
  • SampSta: sequence number of first sample in the cut; NULL means beginning of file
  • SampFin: sequence number of final sample in the cut; NULL means end of file
• History:
  • 2012-12-24 adapted from cut_x_topic

SQL

<mysql>CREATE TABLE `cut_x_file` (

 `ID_Cut` INT NOT NULL COMMENT "cuts.ID",
 `ID_File` INT NOT NULL COMMENT "files.ID",
 `SampSta` INT DEFAULT NULL COMMENT "where the cut starts",
 `SampFin` INT DEFAULT NULL COMMENT "where the cut ends",
 PRIMARY KEY(`ID_Cut`,`ID_Topic`)

) ENGINE = MYISAM;</mysql>