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 +
            " )";

}

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.
 *
 * @see com.satsumasoftware.timetable.framework.Assignment
 */
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";

    /**
     * An SQLite statement which creates the 'assignments' table upon execution.
     *
     * @see TimetableDbHelper
     */
    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 +
            " )";

}

Improve documentation in AssignmentsSchema