trying to build a SQLite database, i dont know why i am getting error, my codes and catlog is bellow:

public void onCreate(SQLiteDatabase db) {
String query = "CREATE TABLE " + TABLE_INFO + "(" +
COLUMN_ID + " INTEGER PRIMARY KEY " +
COLUMN_DATE + " TEXT " +
COLUMN_DOCNAME + " TEXT " +
COLUMN_SYMP + " TEXT " +
COLUMN_DIGNO + " TEXT " +
COLUMN_MEDS + " TEXT " +
");";
db.execSQL(query);





E/AndroidRuntime: FATAL EXCEPTION: main
android.database.sqlite.SQLiteException: near "date": syntax error: , while compiling: CREATE TABLE info(_id INTEGER PRIMARY KEY date TEXT docName TEXT symp TEXT digno TEXT meds TEXT );
at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
at android.database.sqlite.SQLiteCompiledSql.(SQLiteCompiledSql.java:68)
at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:134)
at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:260)
at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:84)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1899)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1839)
at com.rockys.personalmedicalhistory.MyDBHandler.onCreate(MyDBHandler.java:38)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:165)
at com.rockys.personalmedicalhistory.MyDBHandler.newInfo(MyDBHandler.java:55)
at com.rockys.personalmedicalhistory.InfoAddActivity$1.onClick(InfoAddActivity.java:39)
at android.view.View.performClick(View.java:3511)
at android.view.View$PerformClick.run(View.java:14105)
at android.os.Handler.handleCallback(Handler.java:605)
at android.os.Handler.dispatchMessage(Handler.java:92)
at android.os.Looper.loop(Looper.java:137)
at android.app.ActivityThread.main(ActivityThread.java:4424)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:511)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
at dalvik.system.NativeStart.main(Native Method)