package com.b2lmobitech.spottest.sql.tables;

import android.provider.BaseColumns;

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

public class QuestionTable implements BaseColumns {

    public static String TABLENAME="question";
    public static String QUESTIONID="question_id";
    public static String TESTID="question_paper_id";
    public static String SECTIONID="section_id";
    public static String QUESTIONNAME="question";
    public static String QUESTIONTYPE="question_type";
    public static String ASSIGNID="exam_schedule_id";
    public static String MARK="mark";

    /*public static String LABEL="label";
    public static String FORMAT="format";
    public static String ERRORMESSAGE="errorMessage";
    public static String LIMITMIN="limitMin";
    public static String LIMITMAX="limitMax";
    public static String ORDERNUMBER="orderNumber";
    public static String OPTIONAL="optional";
    public static String CREATEDDATIME="createdDateTime";
    public static String MODIFIEDDATETIME="modeifiedDateTime";*/

    public static final String CREATE_TABLE =
            "CREATE TABLE  IF NOT EXISTS "+ QuestionTable.TABLENAME
                    +"("
                    +QuestionTable._ID+" INTEGER PRIMARY KEY,"
                    +QuestionTable.QUESTIONID+" TEXT,"
                    +QuestionTable.TESTID+" TEXT,"
                    +QuestionTable.SECTIONID+" TEXT,"
                    +QuestionTable.QUESTIONNAME+" TEXT,"
                    +QuestionTable.QUESTIONTYPE+" TEXT,"
                    +QuestionTable.MARK+" TEXT,"
                    +QuestionTable.ASSIGNID+" TEXT,"
                    + "CONSTRAINT name_unique UNIQUE ("+QUESTIONID+","+ASSIGNID+"));";


}
