package com.b2lmobitech.spottest.sql.tables;

import android.provider.BaseColumns;

public class DontknowAnswerTable implements BaseColumns {

    public static String TABLENAME="DontknowAnswerTable";

    public static String QUESTION_ID="question_id";
    public static String DATETIME="datetime";
    public static String STUDENT_ID="student_id";
    public static String EXAM_SCHEDULE_ID="exam_schedule_id";
    public static String SECTION_ID="section_id";

    public static final String CREATE_TABLE =
            "CREATE TABLE IF NOT EXISTS "+ TABLENAME
                    +"("
                    +_ID+" INTEGER PRIMARY KEY,"
                    +QUESTION_ID+" TEXT,"
                    +DATETIME+" TEXT,"
                    +STUDENT_ID+" TEXT,"
                    +EXAM_SCHEDULE_ID+" TEXT,"
                    +SECTION_ID+" TEXT,"
                    + "CONSTRAINT name_unique UNIQUE ("+QUESTION_ID+","+STUDENT_ID+","+EXAM_SCHEDULE_ID+"));";




}
