Can you do a foreign key within a single table, though? I've only ever seen foreign key constraints tying a field in one table to a field in another table.

The MySQL Workbench GUI is cross-platform, open source, and incredibly easy to use.

The upgraded features a new table editor with foreign key support and a low level SQlite, three-database analyzer. SQLiteManager is a graphical user interface (GUI) database manager for SQLite ...