适用于Android SDK的SQLite数据库

我正在编写一个似乎可以在没有外键的情况下进行测试的数据库，但是一旦我输入了外键，它似乎就混乱了。到目前为止，我正在测试一个用户表，并具有以下代码；

public static final String TABLE_USERS = "users";

public static final String COLUMN_USER_ID = "_id";
public static final String COLUMN_USER_NAME = "user_name";
public static final String COLUMN_USER_DOB = "DOB";
public static final String COLUMN_USER_PLAN_ID = COLUMN_PLAN_ID;

private static final String SQL_CREATE_TABLE_USER = "create table " + TABLE_USERS+ " ("
        + COLUMN_USER_ID + " INTEGER PRIMARY KEY NOT NULL, "
        + COLUMN_USER_NAME + " TEXT NOT NULL, "
        + COLUMN_USER_DOB + " TEXT NOT NULL, "
        + COLUMN_USER_PLAN_ID+ " INTEGER FOREIGN KEY ("+COLUMN_USER_PLAN_ID+") REFERENCES plan("+COLUMN_PLAN_ID+")"


        + ");";

我正在使用以下代码进行测试，但是它从未达到可以对其进行测试的阶段。

public long insertRow(String name, String DOB, int planId) {


    ContentValues initialValues = new ContentValues();
    initialValues.put(COLUMN_USER_NAME, name);
    initialValues.put(COLUMN_USER_DOB, DOB);
    initialValues.put(COLUMN_USER_PLAN_ID, planId);

    return db.insert(TABLE_USERS , null, initialValues);
}

我在某处或某处语法出错了吗？仿真器只是拒绝打开测试活动

计划表；

public static final String TABLE_PLAN = "plan";
public static final String COLUMN_PLAN_ID = "plan_id";
public static final String COLUMN_PLAN_DESCRIPTION = "description";
public static final String COLUMN_PLAN_DISTANCE = "distance";
public static final String COLUMN_PLAN_LEVEL = "level";
public static final String COLUMN_PLAN_COMPLETED = "completed";
public static final String COLUMN_PLAN_DATE = "date";


private static final String SQL_CREATE_TABLE_PLAN = "CREATE TABLE " + TABLE_PLAN + "("
        + COLUMN_PLAN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
        + COLUMN_PLAN_DESCRIPTION + " TEXT NOT NULL, "
        + COLUMN_PLAN_DISTANCE + " INTEGER NOT NULL, "
        + COLUMN_PLAN_LEVEL + " INTEGER NOT NULL, "
        + COLUMN_PLAN_COMPLETED+ " TEXT NOT NULL, "
        + COLUMN_PLAN_DATE + " TEXT NOT NULL "

        +");";