Android记账软件2

数据库设计：

今天进行数据库表的设计目前功能有限

目前APP共涉及到三个表，分别是：用户信息表、配置表、收支明细表

 1 public void onCreate(SQLiteDatabase db){
 2     //user table
 3     db.execSQL("create table if not exists user_tb(_id integer primary key autoincrement," +
 4             "userID text not null," +
 5             "pwd text not null)");
 6 
 7     //Configuration table
 8     db.execSQL("create table if not exists refCode_tb(_id integer primary key autoincrement," +
 9             "CodeType text not null," +
10             "CodeID text not null," +
11             "CodeName text null)");
12 
13     //costDetail_tb
14     db.execSQL("create table if not exists basicCode_tb(_id integer primary key autoincrement," +
15             "userID text not null," +
16             "Type integer not null," +
17             "incomeWay text not null," +
18             "incomeBy text not null," +
19             "category text not null," +
20             "item text not null," +
21             "cost money not null," +
22             "note text not null," +
23             "makeDate text not null)");
24 }