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