package com.b2lmobitech.spottest.sql.tables;

import android.provider.BaseColumns;

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

public class AnswerTable implements BaseColumns {

    public static String TABLENAME="answer";

    public static String ASSIGNID="exam_schedule_id";

    public static String QUESTIONID="questionId";
    public static String OPTIONID="option_id";
    public static String OPTION="option";
    public static String SECTIONID="section_id";
    public static String IAMGE="image";

    public static String ISIMAGE="isimage";
    public static String INSERTED="inserted";
    public static String DATETIME="datetime";

    public static final String CREATE_TABLE =
            "CREATE TABLE IF NOT EXISTS "+ TABLENAME
                    +"("
                    +_ID+" INTEGER PRIMARY KEY,"
                    +QUESTIONID+" TEXT,"
                    +ASSIGNID+" TEXT,"
                    +SECTIONID+" TEXT,"
                    +OPTIONID+" TEXT DEFAULT 'null',"
                    +OPTION+" TEXT DEFAULT 0,"
                    +IAMGE+" BLOB,"
                    +ISIMAGE+" TEXT DEFAULT 'no',"
                    +DATETIME+" TEXT DEFAULT '0000-00-00 00:00:00',"
                    +INSERTED+" TEXT DEFAULT 'no',"
                    + "CONSTRAINT name_unique UNIQUE ("+QUESTIONID+","+ASSIGNID+"));";



}
