package com.satsumasoftware.timetable.db;

import android.provider.BaseColumns;

import com.satsumasoftware.timetable.db.util.SchemaUtilsKt;

/**
 * The schema for the 'assignments' table, containing constants for the column names and the SQLite
 * create statement.
 */
public final class AssignmentsSchema implements BaseColumns {

    public static final String TABLE_NAME = "assignments";
    public static final String COL_TIMETABLE_ID = "timetable_id";
    public static final String COL_CLASS_ID = "class_id";
    public static final String COL_TITLE = "title";
    public static final String COL_DETAIL = "detail";
    public static final String COL_DUE_DATE_DAY_OF_MONTH = "due_date_day_of_month";
    public static final String COL_DUE_DATE_MONTH = "due_date_month";
    public static final String COL_DUE_DATE_YEAR = "due_date_year";
    public static final String COL_COMPLETION_PROGRESS = "completion_progress";

    /**
     * The SQLite statement which creates the 'assignments' table upon execution
     */
    static final String SQL_CREATE = "CREATE TABLE " + TABLE_NAME + "( " +
            _ID + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.PRIMARY_KEY_AUTOINCREMENT + SchemaUtilsKt.COMMA_SEP +
            COL_TIMETABLE_ID + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_CLASS_ID + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_TITLE + SchemaUtilsKt.TEXT_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_DETAIL + SchemaUtilsKt.TEXT_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_DUE_DATE_DAY_OF_MONTH + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_DUE_DATE_MONTH + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_DUE_DATE_YEAR + SchemaUtilsKt.INTEGER_TYPE + SchemaUtilsKt.COMMA_SEP +
            COL_COMPLETION_PROGRESS + SchemaUtilsKt.INTEGER_TYPE +
            " )";

}

@@ -260,16 +260,78 @@
 tement.%0A
+ *%0A * @see com.satsumasoftware.timetable.framework.Assignment%0A
  */%0Apubl
@@ -996,19 +996,18 @@
 %0A     * 
-The
+An
  SQLite 
@@ -1068,16 +1068,54 @@
 xecution
+.%0A     *%0A     * @see TimetableDbHelper
 %0A     */

Improve documentation in AssignmentsSchema