AudioFerret/v2/cut x file
< AudioFerret | v2
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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_File`)
) ENGINE = MYISAM;</mysql>