package com.b2lmobitech.spottest.sql.tables;

import android.provider.BaseColumns;

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

public class ReferenceTable implements BaseColumns {

    public static String TABLENAME="reference";


    public static String QUESTIONID="questionId";
    public static String OPTIONID="option_id";
    public static String OPTION="option";
    public static String ASSIGNID="assignId";

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


}
