docs/database/amarokTables.dot

   1 graph AmarokTables {
   2   ranksep = 2.5;
   3   node [shape=record];
   4
   5   admin [label="{admin | <key> key : textColumnType() | <version> version : INTEGER }"];
   6
   7   devices [label="{devices | <id> id : idType() | <type> type : textColumnType() | <label> label : textColumnType() | <lastmountpoint> lastmountpoint : textColumnType() | <uuid> uuid : textColumnType() | <servername> servername : textColumnType() | <sharename> sharename : textColumnType() | INDEX ON type, uuid, (servername, sharename)}"];
   8
   9   urls [label="{urls | <id> id : idType() | <deviceid> deviceid : INTEGER | <rpath> rpath : exactTextColumnType() | UNIQUE (deviceid, rpath)}"];
  10   urls:deviceid -- devices:id;
  11
  12   artists [label="{artists | <id> id : idType() | <name> name : textColumnType() NOT NULL | UNIQUE name}"];
  13
  14   albums [label="{albums | <id> id : idType() | <name> name : textColumnType() NOT NULL | <artist> artist : INTEGER | UNIQUE (name, artist) | INDEX ON name, artist}"];
  15   albums:artist -- artists:id;
  16
  17   genres [label="{genres | <id> id : idType() | <name> name : textColumnType() NOT NULL | UNIQUE name}"];
  18
  19   composers [label="{composers | <id> id : idType() | <name> name : textColumnType() NOT NULL | UNIQUE name}"];
  20
  21   years [label="{years | <id> id : idType() | <name> name : textColumnType() NOT NULL | UNIQUE name}"];
  22
  23   tracks [label="{tracks | <id> id : idType() | <url> url : INTEGER | <artist> artist : INTEGER | <album> album : INTEGER | <genre> genre : INTEGER | <composer> composer : INTEGER | <year> year : INTEGER | <title> title : textColumnType() | <comment> comment : textColumnType() | <track> track : INTEGER | <discnumber> discnumber : INTEGER | <bitrate> bitrate : INTEGER | <length> length : INTEGER | <samplerate> samplerate : INTEGER | <filesize> filesize : INTEGER | <filetype> filetype : INTEGER | <bpm> bpm : FLOAT | <createdate> createdate : INTEGER | <modifydate> modifydate : INTEGER | UNIQUE url}"];
  24   tracks:url -- urls:id;
  25   tracks:artist -- artists:id;
  26   tracks:album -- albums:id;
  27   tracks:genre -- genres:id;
  28   tracks:composer -- composers:id;
  29   tracks:year -- years:id;
  30
  31   statistics [label="{statistics | <id> id : idType() | <url> url : INTEGER | <createdate> createdate : INTEGER | <accessdate> accessdate : INTEGER | <score> score : FLOAT | <rating> rating : INTEGER DEFAULT 0 | <playcount> playcount : INTEGER | INDEX ON url}"];
  32   statistics:url -- urls:id;
  33
  34   labels [label="{labels | <id> id : INTEGER | <label> label : textColumnType() | UNIQUE label}"];
  35
  36   urls_labels [label="{urls_labels | <url> url : INTEGER | <label> label : INTEGER | INDEX ON url, label}"];
  37   urls_labels:url -- urls:id;
  38   urls_labels:label -- labels:id;
  39 }