package com.b2lmobitech.spottest.sql.tables;

import android.provider.BaseColumns;

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

public class SectionTable implements BaseColumns {

    public static String TABLENAME="section";

    public static String PAPERID="question_paper_id";
    public static String SECTIONID="section_id";
    public static String NAME="section_name";
    public static String DESCRIPTION="description";
    public static String ANSWERED="answered";
    public static String COUNT="count";

    public static final String CREATE_TABLE =
            "CREATE TABLE IF NOT EXISTS "+ TABLENAME
                    +"("
                    +_ID+" INTEGER PRIMARY KEY,"
                    +PAPERID+" TEXT,"
                    +NAME+" TEXT,"
                    +SECTIONID+" TEXT,"
                    +DESCRIPTION+" TEXT DEFAULT 'null',"
                    +ANSWERED+" INTEGER,"
                    +COUNT+" INTEGER,"
                    + "CONSTRAINT name_unique UNIQUE ("+PAPERID+","+SECTIONID+"));";




}
