Reminders.java

package com.realtrackandroid.models.reminders;

import android.database.sqlite.SQLiteDatabase;

import com.realtrackandroid.models.activities.Activities;

/**
 * *************************************************************************************************
 * ******************* Models the representation of activity reminders
 * ******************************
 * **************************************************************************************
 */
public class Reminders {
  // Instance properties
  private int id;

  private int activityid; // which activity this reminder is for. This is a foreign key that points
                          // to Activities.id

  private long remindTime;

  // Database table
  public static final String REMINDERS_TABLE = "reminders";

  public static final String COLUMN_ID = "_id";

  public static final String COLUMN_ACTIVITYID = "_activityid"; // foreign key referencing
                                                                // Activity.id

  public static final String COLUMN_UPDATED = "updated";

  public static final String COLUMN_REMINDTIME = "remindtime";

  // Database creation SQL statement
  private static final String DATABASE_CREATE = "create table if not exists " + REMINDERS_TABLE
          + "(" + COLUMN_ID + " integer primary key autoincrement, " + COLUMN_UPDATED
          + " integer not null default (strftime('%s','now')), " + COLUMN_REMINDTIME
          + " integer not null, " + COLUMN_ACTIVITYID + " integer not null references "
          + Activities.ACTIVITIES_TABLE + " (" + Activities.COLUMN_ID + ") ON DELETE CASCADE "
          + ");";

  // used to create the table
  public static void onCreate(SQLiteDatabase database) {
    database.execSQL(DATABASE_CREATE);
  }

  // used to upgrade the table
  public static void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
    database.execSQL("drop table if exists " + REMINDERS_TABLE);
    onCreate(database);
  }

  // Getters and Setters follow
  public int getActivityid() {
    return activityid;
  }

  public void setActivityid(int activityid) {
    this.activityid = activityid;
  }

  public long getRemindTime() {
    return remindTime;
  }

  public void setRemindTime(long remindTime) {
    this.remindTime = remindTime;
  }

  public int getId() {
    return id;
  }

  public void setId(int id) {
    this.id = id;
  }

  public Reminders() {
    super();
  }
}