Difference between revisions of "AudioFerret/v2/cut x file"
< AudioFerret | v2
Jump to navigation
Jump to search
(Created page with "==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...") |
m |
||
| Line 13: | Line 13: | ||
`SampSta` INT DEFAULT NULL COMMENT "where the cut starts", | `SampSta` INT DEFAULT NULL COMMENT "where the cut starts", | ||
`SampFin` INT DEFAULT NULL COMMENT "where the cut ends", | `SampFin` INT DEFAULT NULL COMMENT "where the cut ends", | ||
| − | PRIMARY KEY(`ID_Cut`,` | + | PRIMARY KEY(`ID_Cut`,`ID_File`) |
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
Latest revision as of 22:27, 25 August 2013
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>