View source for 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''': {{l/same|cuts}}, {{l/same|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 {{l/same|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_File`)
) ENGINE = MYISAM;</mysql>