Photo.java

package com.mysite.models;

public class Photo
{
    public static final String TABLE = "photos";
    public static final String COLUMN_ID = "_id";
    public static final String COLUMN_TRIBID = "tribid";
    public static final String COLUMN_CAPTION = "caption";
    public static final String COLUMN_HEIGHT = "height";
    public static final String COLUMN_WIDTH = "width";
    public static final String COLUMN_FILEPATH = "filepath";
    public static final String COLUMN_MODIFIED = "modified";
    public static final String COLUMN_ARTICLETRIBID = "articletribid";

    public long id;
    public String tribid;
    public String caption;
    public String filepath;
    public int height;
    public int width;
    public String articletribid;
    public String modified;

    //Database creation sql statement
    public static final String TABLE_CREATE = "CREATE TABLE "
        + Photo.TABLE + "( "
            + Photo.COLUMN_ID + " INTEGER primary key autoincrement, "
            + Photo.COLUMN_TRIBID + " TEXT, "
            + Photo.COLUMN_CAPTION + " TEXT, "
            + Photo.COLUMN_FILEPATH + " TEXT, "
            + Photo.COLUMN_HEIGHT + " INTEGER, "
            + Photo.COLUMN_WIDTH + " INTEGER, "
            + Photo.COLUMN_ARTICLETRIBID + " TEXT, "
            + Photo.COLUMN_MODIFIED + " TEXT"
        + ");";

    @Override
    public String toString() { return this.filepath; }
}