テキスト比較

2 つのテキスト ファイルの違いを見つける

ライブエディター
未変更行を折りたたむ
折り返しなし
レイアウト
比較精度
シンタックスハイライト

schema_diff

作成日 差分は期限切れになりません
29 削除
754 行
31 追加
760 行
{
{
"alembic_version": {
"alembic_version": {
"columns": [
"columns": [
{
{
"name": "version_num",
"name": "version_num",
"type": VARCHAR(length=32),
"type": VARCHAR(length=32),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
}
}
],
],
"pk_constraint": {
"pk_constraint": {
"constrained_columns": ["version_num"],
"constrained_columns": ["version_num"],
"name": "alembic_version_pkc",
"name": "alembic_version_pkc",
},
},
"foreign_keys": [],
"foreign_keys": [],
"check_constraints": [],
"check_constraints": [],
},
},
"alternative": {
"alternative": {
"columns": [
"columns": [
{
{
"name": "commit_id",
"name": "commit_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": True,
"nullable": True,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "description",
"name": "description",
"type": TEXT(),
"type": TEXT(),
"nullable": True,
"nullable": True,
"default": None,
"default": "NULL",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "name",
"name": "name",
"type": TEXT(),
"type": VARCHAR(length=255),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
],
],
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_alternative"},
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_alternative"},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_alternative_commit_id_commit",
"name": "fk_alternative_commit_id_commit",
"constrained_columns": ["commit_id"],
"constrained_columns": ["commit_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "commit",
"referred_table": "commit",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {},
"options": {},
}
}
],
],
"check_constraints": [],
"check_constraints": [],
},
},
"commit": {
"commit": {
"columns": [
"columns": [
{
{
"name": "comment",
"name": "comment",
"type": VARCHAR(length=255),
"type": VARCHAR(length=255),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "date",
"name": "date",
"type": DATETIME(),
"type": DATETIME(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "user",
"name": "user",
"type": VARCHAR(length=45),
"type": VARCHAR(length=45),
"nullable": True,
"nullable": True,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
],
],
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_commit"},
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_commit"},
"foreign_keys": [],
"foreign_keys": [],
"check_constraints": [],
"check_constraints": [],
},
},
"display_mode__entity_class": {
"display_mode__entity_class": {
"columns": [
"columns": [
{
{
"name": "display_background_color",
"name": "display_background_color",
"type": BIGINT(),
"type": BIGINT(),
"nullable": True,
"nullable": True,
"default": "NULL",
"default": "NULL",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "display_font_color",
"name": "display_font_color",
"type": BIGINT(),
"type": BIGINT(),
"nullable": True,
"nullable": True,
"default": "NULL",
"default": "NULL",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "display_mode_id",
"name": "display_mode_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "display_order",
"name": "display_order",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "display_status",
"name": "display_status",
"type": VARCHAR(length=10),
"type": VARCHAR(length=10),
"nullable": False,
"nullable": False,
"default": "'visible'",
"default": "'visible'",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "entity_class_id",
"name": "entity_class_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
],
],
"pk_constraint": {
"pk_constraint": {
"constrained_columns": ["id"],
"constrained_columns": ["id"],
"name": "pk_display_mode__entity_class",
"name": "pk_display_mode__entity_class",
},
},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_display_mode_display_mode",
"name": "fk_display_mode_display_mode",
"constrained_columns": ["display_mode_id"],
"constrained_columns": ["display_mode_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity_class_display_mode",
"referred_table": "entity_class_display_mode",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
{
{
"name": "fk_display_mode_entity_class",
"name": "fk_display_mode_entity_class",
"constrained_columns": ["entity_class_id"],
"constrained_columns": ["entity_class_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity_class",
"referred_table": "entity_class",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
],
],
"check_constraints": [
"check_constraints": [
{
{
"sqltext": "display_status IN ('visible', 'hidden', 'greyed_out')",
"sqltext": "display_status IN ('visible', 'hidden', 'greyed_out')",
"name": "ck_display_mode__entity_class_display_status_enum",
"name": "ck_display_mode__entity_class_display_status_enum",
}
}
],
],
},
},
"entity": {
"entity": {
"columns": [
"columns": [
{
{
"name": "class_id",
"name": "class_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": True,
"nullable": True,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "commit_id",
"name": "commit_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": True,
"nullable": True,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "description",
"name": "description",
"type": TEXT(),
"type": TEXT(),
"nullable": True,
"nullable": True,
"default": "NULL",
"default": "NULL",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "name",
"name": "name",
"type": VARCHAR(length=255),
"type": VARCHAR(length=255),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
],
],
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_entity"},
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_entity"},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_entity_class_id_entity_class",
"name": "fk_entity_class_id_entity_class",
"constrained_columns": ["class_id"],
"constrained_columns": ["class_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity_class",
"referred_table": "entity_class",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
{
{
"name": "fk_entity_commit_id_commit",
"name": "fk_entity_commit_id_commit",
"constrained_columns": ["commit_id"],
"constrained_columns": ["commit_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "commit",
"referred_table": "commit",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {},
"options": {},
},
},
],
],
"check_constraints": [],
"check_constraints": [],
},
},
"entity_alternative": {
"entity_alternative": {
"columns": [
"columns": [
{
{
"name": "active",
"name": "active",
"type": BOOLEAN(),
"type": BOOLEAN(),
"nullable": False,
"nullable": False,
"default": "1",
"default": "1",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "alternative_id",
"name": "alternative_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "commit_id",
"name": "commit_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": True,
"nullable": True,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "entity_id",
"name": "entity_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
],
],
"pk_constraint": {
"pk_constraint": {
"constrained_columns": ["id"],
"constrained_columns": ["id"],
"name": "pk_entity_alternative",
"name": "pk_entity_alternative",
},
},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_entity_alternative_alternative_id_alternative",
"name": "fk_entity_alternative_alternative_id_alternative",
"constrained_columns": ["alternative_id"],
"constrained_columns": ["alternative_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "alternative",
"referred_table": "alternative",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
{
{
"name": "fk_entity_alternative_commit_id_commit",
"name": "fk_entity_alternative_commit_id_commit",
"constrained_columns": ["commit_id"],
"constrained_columns": ["commit_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "commit",
"referred_table": "commit",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {},
"options": {},
},
},
{
{
"name": "fk_entity_alternative_entity_id_entity",
"name": "fk_entity_alternative_entity_id_entity",
"constrained_columns": ["entity_id"],
"constrained_columns": ["entity_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity",
"referred_table": "entity",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
],
],
"check_constraints": [
"check_constraints": [
{"sqltext": "active IN (0, 1)", "name": "ck_entity_alternative_active"}
{"sqltext": "active IN (0, 1)", "name": "ck_entity_alternative_active"}
],
],
},
},
"entity_class": {
"entity_class": {
"columns": [
"columns": [
{
{
"name": "active_by_default",
"name": "active_by_default",
"type": BOOLEAN(),
"type": BOOLEAN(),
"nullable": False,
"nullable": False,
"default": "1",
"default": "1",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "description",
"name": "description",
"type": TEXT(),
"type": TEXT(),
"nullable": True,
"nullable": True,
"default": "NULL",
"default": "NULL",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "display_icon",
"name": "display_icon",
"type": BIGINT(),
"type": BIGINT(),
"nullable": True,
"nullable": True,
"default": "NULL",
"default": "NULL",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "display_order",
"name": "display_order",
"type": INTEGER(),
"type": INTEGER(),
"nullable": True,
"nullable": True,
"default": "'99'",
"default": "'99'",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "hidden",
"name": "hidden",
"type": INTEGER(),
"type": INTEGER(),
"nullable": True,
"nullable": True,
"default": "'0'",
"default": "'0'",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "name",
"name": "name",
"type": VARCHAR(length=255),
"type": VARCHAR(length=255),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
],
],
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_entity_class"},
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_entity_class"},
"foreign_keys": [],
"foreign_keys": [],
"check_constraints": [
"check_constraints": [
{"sqltext": "active_by_default IN (0, 1)", "name": None},
{
{
"sqltext": "active_by_default IN (0, 1)",
"sqltext": "active_by_default IN (0, 1)",
"name": "ck_entity_class_active_by_default",
"name": "ck_entity_class_active_by_default",
},
}
{"sqltext": "active_by_default IN (0, 1)", "name": "active_by_default"},
],
],
},
},
"entity_class_dimension": {
"entity_class_dimension": {
"columns": [
"columns": [
{
{
"name": "dimension_id",
"name": "dimension_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 2,
"primary_key": 2,
},
},
{
{
"name": "entity_class_id",
"name": "entity_class_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "position",
"name": "position",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 3,
"primary_key": 3,
},
},
],
],
"pk_constraint": {
"pk_constraint": {
"constrained_columns": ["entity_class_id", "dimension_id", "position"],
"constrained_columns": ["entity_class_id", "dimension_id", "position"],
"name": "pk_entity_class_dimension",
"name": "pk_entity_class_dimension",
},
},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_entity_class_dimension_dimension_id_entity_class",
"name": "fk_entity_class_dimension_dimension_id_entity_class",
"constrained_columns": ["dimension_id"],
"constrained_columns": ["dimension_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity_class",
"referred_table": "entity_class",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
{
{
"name": "fk_entity_class_dimension_entity_class_id_entity_class",
"name": "fk_entity_class_dimension_entity_class_id_entity_class",
"constrained_columns": ["entity_class_id"],
"constrained_columns": ["entity_class_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity_class",
"referred_table": "entity_class",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
],
],
"check_constraints": [],
"check_constraints": [],
},
},
"entity_class_display_mode": {
"entity_class_display_mode": {
"columns": [
"columns": [
{
{
"name": "description",
"name": "description",
"type": TEXT(),
"type": TEXT(),
"nullable": True,
"nullable": True,
"default": "NULL",
"default": "NULL",
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "name",
"name": "name",
"type": VARCHAR(length=255),
"type": VARCHAR(length=255),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
],
],
"pk_constraint": {
"pk_constraint": {
"constrained_columns": ["id"],
"constrained_columns": ["id"],
"name": "pk_entity_class_display_mode",
"name": "pk_entity_class_display_mode",
},
},
"foreign_keys": [],
"foreign_keys": [],
"check_constraints": [],
"check_constraints": [],
},
},
"entity_element": {
"entity_element": {
"columns": [
"columns": [
{
{
"name": "dimension_id",
"name": "dimension_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "element_id",
"name": "element_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "entity_class_id",
"name": "entity_class_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "entity_id",
"name": "entity_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "position",
"name": "position",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 2,
"primary_key": 2,
},
},
],
],
"pk_constraint": {
"pk_constraint": {
"constrained_columns": ["entity_id", "position"],
"constrained_columns": ["entity_id", "position"],
"name": "pk_entity_element",
"name": "pk_entity_element",
},
},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_entity_element_element_id_entity",
"name": "fk_entity_element_element_id_entity",
"constrained_columns": ["element_id", "dimension_id"],
"constrained_columns": ["element_id", "dimension_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity",
"referred_table": "entity",
"referred_columns": ["id", "class_id"],
"referred_columns": ["id", "class_id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
{
{
"name": "fk_entity_element_entity_class_id_entity_class_dimension",
"name": "fk_entity_element_entity_class_id_entity_class_dimension",
"constrained_columns": ["entity_class_id", "dimension_id", "position"],
"constrained_columns": ["entity_class_id", "dimension_id", "position"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity_class_dimension",
"referred_table": "entity_class_dimension",
"referred_columns": ["entity_class_id", "dimension_id", "position"],
"referred_columns": ["entity_class_id", "dimension_id", "position"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
{
{
"name": "fk_entity_element_entity_id_entity",
"name": "fk_entity_element_entity_id_entity",
"constrained_columns": ["entity_id", "entity_class_id"],
"constrained_columns": ["entity_id", "entity_class_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity",
"referred_table": "entity",
"referred_columns": ["id", "class_id"],
"referred_columns": ["id", "class_id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
],
],
"check_constraints": [],
"check_constraints": [],
},
},
"entity_group": {
"entity_group": {
"columns": [
"columns": [
{
{
"name": "entity_class_id",
"name": "entity_class_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "entity_id",
"name": "entity_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "member_id",
"name": "member_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
],
],
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_entity_group"},
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_entity_group"},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_entity_group_entity_id_entity",
"name": "fk_entity_group_entity_id_entity",
"constrained_columns": ["entity_id", "entity_class_id"],
"constrained_columns": ["entity_id", "entity_class_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity",
"referred_table": "entity",
"referred_columns": ["id", "class_id"],
"referred_columns": ["id", "class_id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
{
{
"name": "fk_entity_group_member_id_entity",
"name": "fk_entity_group_member_id_entity",
"constrained_columns": ["member_id", "entity_class_id"],
"constrained_columns": ["member_id", "entity_class_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity",
"referred_table": "entity",
"referred_columns": ["id", "class_id"],
"referred_columns": ["id", "class_id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
],
],
"check_constraints": [],
"check_constraints": [],
},
},
"entity_metadata": {
"entity_metadata": {
"columns": [
"columns": [
{
{
"name": "commit_id",
"name": "commit_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": True,
"nullable": True,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "entity_id",
"name": "entity_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "metadata_id",
"name": "metadata_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
],
],
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_entity_metadata"},
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_entity_metadata"},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_entity_metadata_commit_id_commit",
"name": "fk_entity_metadata_commit_id_commit",
"constrained_columns": ["commit_id"],
"constrained_columns": ["commit_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "commit",
"referred_table": "commit",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {},
"options": {},
},
},
{
{
"name": "fk_entity_metadata_entity_id_entity",
"name": "fk_entity_metadata_entity_id_entity",
"constrained_columns": ["entity_id"],
"constrained_columns": ["entity_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "entity",
"referred_table": "entity",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
{
{
"name": "fk_entity_metadata_metadata_id_metadata",
"name": "fk_entity_metadata_metadata_id_metadata",
"constrained_columns": ["metadata_id"],
"constrained_columns": ["metadata_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "metadata",
"referred_table": "metadata",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
},
},
],
],
"check_constraints": [],
"check_constraints": [],
},
},
"feature": {
"list_value": {
"columns": [
"columns": [
{
{
"name": "commit_id",
"name": "commit_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": True,
"nullable": True,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
Text moved with changes to lines 727-733 (96.8% similarity)
"name": "description",
"type": TEXT(),
"nullable": True,
"default": "NULL",
"autoincrement": "auto",
"primary_key": 0,
},
{
"name": "id",
"name": "id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 1,
"primary_key": 1,
},
},
{
{
"name": "parameter_definition_id",
"name": "index",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
{
"name": "parameter_value_list_id",
"name": "parameter_value_list_id",
"type": INTEGER(),
"type": INTEGER(),
"nullable": False,
"nullable": False,
"default": None,
"default": None,
"autoincrement": "auto",
"autoincrement": "auto",
"primary_key": 0,
"primary_key": 0,
},
},
{
"name": "type",
"type": VARCHAR(length=255),
"nullable": True,
"default": None,
"autoincrement": "auto",
"primary_key": 0,
},
{
Text moved with changes from lines 697-703 (96.8% similarity)
"name": "value",
"type": BLOB(),
"nullable": True,
"default": "NULL",
"autoincrement": "auto",
"primary_key": 0,
},
],
],
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_feature"},
"pk_constraint": {"constrained_columns": ["id"], "name": "pk_list_value"},
"foreign_keys": [
"foreign_keys": [
{
{
"name": "fk_feature_commit_id_commit",
"name": "fk_list_value_commit_id_commit",
"constrained_columns": ["commit_id"],
"constrained_columns": ["commit_id"],
"referred_schema": None,
"referred_schema": None,
"referred_table": "commit",
"referred_table": "commit",
"referred_columns": ["id"],
"referred_columns": ["id"],
"options": {},
"options": {},
},
},
{
{
"name": "fk_feature_parameter_definition_id_parameter_definition",
"name": "fk_list_value_parameter_value_list_id_parameter_value_list",
"constrained_columns": [
"constrained_columns": ["parameter_value_list_id"],
"parameter_definition_id",
"parameter_value_list_id",
],
"referred_schema": None,
"referred_schema": None,
"referred_table": "parameter_definition",
"referred_table": "parameter_value_list",
"referred_columns": ["id", "parameter_value_list_id"],
"referred_columns": ["id"],
"options": {"ondelete": "CASCADE", "onupdate": "CASCADE"},
"options": {},
},
},
],
],
"check_constraints": [],
"check_constraints": [],
},
},
"list_value": {
"metadata": {
"colum
"columns": [
{
"name": "commit_id",
保存された差分