aboutsummaryrefslogtreecommitdiff
path: root/src/uk/org/ury/library/LibraryItemProperty.java
blob: 154e4052a2b3171ad5c8a9283a116f70ed4f09c4 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
package uk.org.ury.library;

/**
 * The parameters that are stored in the LibraryItem.
 * 
 * @author  Matt Windsor
 */

public enum LibraryItemProperty
  {
    // Constant     SQL identifier       
    TITLE           ("title"),
    ALBUM           ("album"),
    ARTIST          ("artist"),
    LABEL           ("label"),
    STATUS          ("status"),
    MEDIUM          ("medium"),
    FORMAT          ("format"),
    DATE_RELEASED   ("datereleased"),
    DATE_ADDED      ("dateadded"),
    DATE_EDITED     ("dateedited"),
    SHELF_LETTER    ("shelfletter"),
    SHELF_NUMBER    ("shelfnumber"),
    CD_ID           ("cdid"),
    ADD_MEMBER_ID   ("memberid_add"),
    EDIT_MEMBER_ID  ("memberid_lastedit"),
    ADD_FORENAME    ("fnameadd"),
    ADD_SURNAME     ("snameadd"),
    EDIT_FORENAME   ("fnameedit"),
    EDIT_SURNAME    ("snameedit"),
    IS_DIGITISED    ("digitised"),
    IS_CLEAN        ("clean");
    
    
    public final String sql;
    
    
    private
    LibraryItemProperty (String sql)
    {
      this.sql = sql;
    }
  };