package com.b2lmobitech.spottest.sql.tables;

import android.provider.BaseColumns;

/**
 * Created by home on 2/13/2018.
 */

public class OptionTable implements BaseColumns {

    public static String TABLENAME="option";
    public static String QUESTIONID="question_id";
    public static String OPTIONID="option_id";
    public static String OPTIONNAME="option_name";
    public static String ASSIGNID="exam_schedule_id";

    public static final String CREATE_TABLE =
            "CREATE TABLE IF NOT EXISTS "+ OptionTable.TABLENAME
                    +"("
                    +OptionTable._ID+" INTEGER PRIMARY KEY,"
                    +OptionTable.QUESTIONID+" TEXT,"
                    +OptionTable.OPTIONID+" TEXT,"
                    +OptionTable.OPTIONNAME+" TEXT,"
                    +OptionTable.ASSIGNID+" TEXT,"
                    + "CONSTRAINT name_unique UNIQUE ("+OPTIONID+","+ASSIGNID+"));";

}
