AudioFerret/v2/cut x file

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

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:

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>