db.java

        sqLiteDatabase.execSQL(
                "CREATE TABLE IF NOT EXISTS " + TABLE_USER +
                        "(" + COLUMN_USER_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
                        "," + COLUMN_USER_NAME + " TEXT" +
                        "," + COLUMN_USER_EMAIL + " TEXT" +
                        "," + COLUMN_USER_PASSWORD + " TEXT" +
                        "," + COLUMN_USER_IS_ADMIN + " TEXT" +
                        "," + COLUMN_USER_SECURE_NUM + " INTEGER)");
        sqLiteDatabase.execSQL(
                "CREATE TABLE IF NOT EXISTS " + TABLE_LOCATION +
                        "(" + COLUMN_LOCATION_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
                        "," + COLUMN_LOCATION_NAME + " TEXT" +
                        "," + COLUMN_LOCATION_ADDRESS + " TEXT" +
                        "," + COLUMN_LOCATION_CITY + " TEXT)");
        sqLiteDatabase.execSQL(
                "CREATE TABLE IF NOT EXISTS " + TABLE_USER_LOCATIONS +
                        "(" + COLUMN_USER_LOCATION_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
                        "," + COLUMN_USER_ID_FK + " INTEGER" +
                        "," + COLUMN_LOCATION_ID_FK + " INTEGER" +
                        ",FOREIGN KEY (" + COLUMN_USER_ID_FK + ") " +
                        "REFERENCES " + TABLE_USER + "(" + COLUMN_USER_ID + ")" +
                        ",FOREIGN KEY (" + COLUMN_LOCATION_ID_FK + ") " +
                        "REFERENCES " + TABLE_LOCATION + "(" + COLUMN_LOCATION_ID + "))");
        sqLiteDatabase.execSQL(
                "CREATE TABLE IF NOT EXISTS " + TABLE_SHIFTS +
                        "(" + COLUMN_SHIFT_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
                        "," + COLUMN_SHIFT_DATE + " TEXT" +
                        "," + COLUMN_SHIFT_TIME + " TEXT" +
                        "," + COLUMN_SHIFT_END_TIME + " TEXT" +
                        "," + COLUMN_SHIFT_AVAILABLITY + " TEXT" +
                        "," + COLUMN_LOCATION_ID_FK + " INTEGER" +
                        ",FOREIGN KEY (" + COLUMN_LOCATION_ID_FK + ") " +
                        "REFERENCES " + TABLE_LOCATION + " (" + COLUMN_LOCATION_ID + "))");
        sqLiteDatabase.execSQL(
                "CREATE TABLE IF NOT EXISTS " + TABLE_USER_SHIFT +
                        "(" + COLUMN_USER_SHIFT_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
                        "," + COLUMN_USER_SHIFT_COMPLETED + " TEXT" +
                        "," + COLUMN_SHIFT_ID_FK + " INTEGER" +
                        "," + COLUMN_USER_ID_FK + " INTEGER" +
                        ",FOREIGN KEY (" + COLUMN_SHIFT_ID_FK + ") " +
                        "REFERENCES " + TABLE_SHIFTS + " (" + COLUMN_SHIFT_ID + ")" +
                        ",FOREIGN KEY (" + COLUMN_USER_ID_FK + ") " +
                        "REFERENCES " + TABLE_USER + " (" + COLUMN_USER_ID + "))");
        sqLiteDatabase.execSQL(
                "CREATE TABLE IF NOT EXISTS " + TABLE_ARRESTS +
                        "(" + COLUMN_ARREST_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
                        "," + COLUMN_ARREST_DATE + " TEXT" +
                        "," + COLUMN_ARREST_TIME + " TEXT" +
                        "," + COLUMN_ARREST_TYPE + " TEXT" +
                        "," + COLUMN_LOCATION_ID_FK + " INTEGER" +
                        "," + COLUMN_USER_ID_FK + " INTEGER" +
                        ",FOREIGN KEY (" + COLUMN_LOCATION_ID_FK + ") " +
                        "REFERENCES " + TABLE_LOCATION + " (" + COLUMN_LOCATION_ID + ")" +
                        ",FOREIGN KEY (" + COLUMN_USER_ID_FK + ") " +
                        "REFERENCES " + TABLE_USER + " (" + COLUMN_USER_ID + "))");
        sqLiteDatabase.execSQL(
                "CREATE TABLE IF NOT EXISTS " + TABLE_DESCRIPTION +
                        "(" + COLUMN_DESCRIPTION_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
                        "," + COLUMN_DESCRIPTION_NAME + " TEXT" +
                        "," + COLUMN_DESCRIPTION_HEIGHT + " TEXT" +
                        "," + COLUMN_DESCRIPTION_WEIGHT + " TEXT" +
                        "," + COLUMN_DESCRIPTION_HAIR_COLOR + " TEXT" +
                        "," + COLUMN_DESCRIPTION_EYE_COLOR + " TEXT" +
                        "," + COLUMN_DESCRIPTION_SKIN_COLOR + " TEXT" +
                        "," + COLUMN_DESCRIPTION_HAS_TATOO + " TEXT" +
                        "," + COLUMN_ARREST_ID_FK + " INTEGER" +
                        ",FOREIGN KEY (" + COLUMN_ARREST_ID_FK + ") " +
                        "REFERENCES " + TABLE_ARRESTS + " (" + COLUMN_ARREST_ID + "))");
        sqLiteDatabase.execSQL(
                "CREATE TABLE IF NOT EXISTS " + TABLE_TATOO +
                        "(" + COLUMN_TATOO_ID + " INTEGER PRIMARY KEY AUTOINCREMENT" +
                        "," + COLUMN_TATOO_SIZE + " TEXT" +
                        "," + COLUMN_TATOO_LOCATION + " TEXT" +
                        "," + COLUMN_TATOO_DESCRIPTION + " TEXT" +
                        "," + COLUMN_TATOO_COLOR_PRIMARY + " TEXT" +
                        "," + COLUMN_TATOO_COLOR_SECONDARY + " TEXT" +
                        "," + COLUMN_DESCRIPTION_ID_FK + " INTEGER" +
                        ",FOREIGN KEY (" + COLUMN_DESCRIPTION_ID_FK + ") " +
                        "REFERENCES " + TABLE_DESCRIPTION + " (" + COLUMN_DESCRIPTION_ID + "))");