Ferret File System/v0.1/SQL/fideal: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
m (Woozle moved page FileFerret/SQL/fideals to FileFerret/SQL/fideal without leaving a redirect: singularizing)
(singularizing)
Line 1: Line 1:
==About==
==About==
"[[../terms/fideal|Fideal]]" is short for "ideal file". A fideal represents what the file is supposed to be, e.g. a perfect copy of a particular document or media clip. – i.e. it either ''is'' the original, or it is a perfect copy. ("Original file" might be as good a name, but in some cases the "original" may become corrupted and one of the copies may be more accurate; the "fideal" is how the file is ''supposed'' to be.)
"{{l/fileferret|terms/fideal|Fideal}}" is short for "ideal file". A fideal represents what the file is supposed to be, e.g. a perfect copy of a particular document or media clip. – i.e. it either ''is'' the original, or it is a perfect copy. ("Original file" might be as good a name, but in some cases the "original" may become corrupted and one of the copies may be more accurate; the "fideal" is how the file is ''supposed'' to be.)
===History===
===History===
* '''2012-12-25''' removed any firev-specific fields; reorganized documentation
* '''2012-12-25''' removed any firev-specific fields; reorganized documentation
* '''2016-02-27''' renamed "fideals" -> "fideal"
===Fields===
===Fields===
* '''Title''' will probably end up being some form of the filename, possibly with disambiguating text prepended.
* '''Title''' will probably end up being some form of the filename, possibly with disambiguating text prepended.
Line 11: Line 12:
** multiple copies of the same file are found
** multiple copies of the same file are found
** a user wants to record information about what the file is supposed to represent (the fideal). In other words: if you want to describe the contents of a file, you don't; you describe the fideal. Files are localized instances (possibly imperfect copies) of fideals.
** a user wants to record information about what the file is supposed to represent (the fideal). In other words: if you want to describe the contents of a file, you don't; you describe the fideal. Files are localized instances (possibly imperfect copies) of fideals.
* Any [[../terms/firev|firev]] which is believed to be a perfect representation of the fideal will be marked as such (method yet to be determined).
* Any {{l/fileferret|terms/firev|firev}} which is believed to be a perfect representation of the fideal will be marked as such (method yet to be determined).
==SQL==
==SQL==
<mysql>CREATE TABLE `fideals` (
<mysql>CREATE TABLE `fideal` (
   `ID`        INT NOT NULL AUTO_INCREMENT,
   `ID`        INT NOT NULL AUTO_INCREMENT,
   `Title`    VARCHAR(255) COMMENT "unique name for the file, wherever it may be found",
   `Title`    VARCHAR(255) COMMENT "unique name for the file, wherever it may be found",
Line 21: Line 22:
   PRIMARY KEY(`ID`)
   PRIMARY KEY(`ID`)
)
)
ENGINE = MYISAM;</mysql>
ENGINE = INNODB;</mysql>

Revision as of 23:05, 27 February 2016

About

"Fideal" is short for "ideal file". A fideal represents what the file is supposed to be, e.g. a perfect copy of a particular document or media clip. – i.e. it either is the original, or it is a perfect copy. ("Original file" might be as good a name, but in some cases the "original" may become corrupted and one of the copies may be more accurate; the "fideal" is how the file is supposed to be.)

History

  • 2012-12-25 removed any firev-specific fields; reorganized documentation
  • 2016-02-27 renamed "fideals" -> "fideal"

Fields

  • Title will probably end up being some form of the filename, possibly with disambiguating text prepended.
  • Descr: At some point I'll probably have some kind of syntax whereby this can refer to a wiki page for more info. Maybe just straight HTML? Or possibly we need a separate URL field.
  • AutoDescr can be generated by the application which first goes looking for the fideal and which therefore may have more understanding of the fideal's purpose in life

Rules

  • Fideal records are only created when:
    • multiple copies of the same file are found
    • a user wants to record information about what the file is supposed to represent (the fideal). In other words: if you want to describe the contents of a file, you don't; you describe the fideal. Files are localized instances (possibly imperfect copies) of fideals.
  • Any firev which is believed to be a perfect representation of the fideal will be marked as such (method yet to be determined).

SQL

<mysql>CREATE TABLE `fideal` (

 `ID`        INT NOT NULL AUTO_INCREMENT,
 `Title`     VARCHAR(255) COMMENT "unique name for the file, wherever it may be found",
 `Descr`     VARCHAR(255) COMMENT "description",
 `AutoTitle` VARCHAR(255) COMMENT "automatically-generated title",
 `AutoDescr` VARCHAR(255) COMMENT "automatically-generated description",
 PRIMARY KEY(`ID`)

) ENGINE = INNODB;</mysql>