Schema: Database: Foo: bar Hello: world Table: Basic ========================================================================== Fields id data_type: int size: 10 is_nullable: 0 default_value: is_primary_key: 1 is_unique: 0 is_auto_increment: 1 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 1 table: Basic title data_type: varchar size: 100 is_nullable: 0 default_value: hello is_primary_key: 0 is_unique: 1 is_auto_increment: 0 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 2 table: Basic description data_type: text size: 0 is_nullable: 1 default_value: is_primary_key: 0 is_unique: 0 is_auto_increment: 0 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 3 table: Basic email data_type: varchar size: 500 is_nullable: 1 default_value: is_primary_key: 0 is_unique: 1 is_auto_increment: 0 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 4 table: Basic explicitnulldef data_type: varchar size: 0 is_nullable: 1 default_value: is_primary_key: 0 is_unique: 0 is_auto_increment: 0 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 5 table: Basic explicitemptystring data_type: varchar size: 0 is_nullable: 1 default_value: is_primary_key: 0 is_unique: 0 is_auto_increment: 0 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 6 table: Basic emptytagdef data_type: varchar size: 0 is_nullable: 1 default_value: is_primary_key: 0 is_unique: 0 is_auto_increment: 0 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 7 table: Basic another_id data_type: int size: 10 is_nullable: 1 default_value: 2 is_primary_key: 0 is_unique: 0 is_auto_increment: 0 is_foreign_key: 1 foreign_key_reference: Another is_valid: 1 order: 8 table: Basic timest data_type: timestamp size: 0 is_nullable: 1 default_value: is_primary_key: 0 is_unique: 0 is_auto_increment: 0 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 9 table: Basic Indices titleindex table: Basic fields: title type: NORMAL options: is_valid: 1 Constraints ? type: PRIMARY KEY fields: id expression: match_type: reference_fields: reference_table: deferrable: 1 on_delete: on_update: options: is_valid: 1 emailuniqueindex type: UNIQUE fields: email expression: match_type: reference_fields: reference_table: deferrable: 1 on_delete: on_update: options: is_valid: 1 very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms type: UNIQUE fields: title expression: match_type: reference_fields: reference_table: deferrable: 1 on_delete: on_update: options: is_valid: 1 ? type: FOREIGN KEY fields: another_id expression: match_type: reference_fields: id reference_table: Another deferrable: 1 on_delete: on_update: options: is_valid: 1 Table: Another ========================================================================== Fields id data_type: int size: 10 is_nullable: 0 default_value: is_primary_key: 1 is_unique: 0 is_auto_increment: 1 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 1 table: Another num data_type: numeric size: 10,2 is_nullable: 1 default_value: is_primary_key: 0 is_unique: 0 is_auto_increment: 0 is_foreign_key: 0 foreign_key_reference: is_valid: 1 order: 2 table: Another Indices Constraints ? type: PRIMARY KEY fields: id expression: match_type: reference_fields: reference_table: deferrable: 1 on_delete: on_update: options: is_valid: 1