我是相当新的机器人，我试图创建一个相当复杂的应用程序（的东西比记事本或任务提醒更高级的），有一些严重的底层数据模型。我使用的Eclipse的Andr​​oid SDK插件，一切运作良好。但是，我应该用什么数据库设计？ 我已经通过一些编程方式创建数据库示例应用程序了，但那些只包含一个表有几列。我想创建与多个表，专用键/外键约束，枚举以及诸如此类的数据库。如果我不得不手动做到这一点，我可能会的时候，我要完蛋了去灰。我在我的时间设计了相当多的数据库，无论是在微软的Visual Studio中，MS SQL Server Management Studio中，Oracle数据库设计器和类似的工具。 我认识到，SQLite没有一些花哨shmancy DB服务器，我可以运行SQL脚本，它会创建数据库，并保持它活着。我知道它的应用程序和应用程序本身必须建立和维护它的数据库的一部分。 是否有任何视觉数据库设计工具，我也许可以集成到Eclipse（不是必要的），哪些会，我不知道，生成数据库创建code，使数据库将在我的应用程序可以使用

在此先感谢。

PS：我知道的Andr​​oid设备的限制。该应用程序将有一个复杂的数据结构，但它并不打算持有如此多的数据。演习的目的是要测试的内容可以通过这个平台来完成，并试图创造一些有意义的提高自己的技能。

我使用SQLite数据库浏览器在过去一个月以来，我发现这是一个非常好的工具。你应该尝试一下：

http://sqlitebrowser.org

I'm fairly new to Android, I'm trying to create a rather complex app (something more advanced than notepad or task reminder), with some serious underlying data model. I'm using Eclipse with the Android SDK plugin, everything is working well. But what should I use for database design? I've gone through some sample apps that create databases programmatically, but those only contained a single table with a few columns. What I want to create is a database with multiple tables, private key/foreign key constraints, enumerations and all that jazz. If I had to do this manually, I'd probably go grey by the time I'm finished. I've designed quite a few databases in my time, be it in MS Visual Studio, MS SQL Server Management Studio, Oracle DB Designer and similar tools. I realize that SQLite doesn't have some fancy shmancy DB server where I could run SQL scripts and it would create the database and keep it alive. I know it's all part of the application and the app itself must create and maintain its database. Is there any visual DB design tool, which I could maybe integrate into Eclipse (not necessary) and which would, I don't know, generate the database creation code, so that the database would be usable in my application?

Thanks in advance.

PS: I'm aware of the limitations of the Android devices. The app will have a complex data structure, but it's not intended to hold that much data. The purpose of the exercise is to test what can be done with the platform and improve my skills by attempting to create something meaningful.

I've been using SQLite Database Browser for the past month, I've found it to be a really nice tool. You should try it out:

http://sqlitebrowser.org