[
{
"name": "categories",
"columns": [
{ "name": "id", "type": "bigint unsigned", "nullable": false, "default": null },
{ "name": "parent_id", "type": "bigint unsigned", "nullable": true, "default": null }
],
"primary_key": ["id"],
"indexes": [],
"foreign_keys": [
{ "name": "categories_parent_id_foreign", "columns": ["parent_id"], "references_table": "categories", "references_columns": ["id"], "on_update": null, "on_delete": "set null" }
]
},
{
"name": "posts",
"columns": [
{ "name": "id", "type": "bigint unsigned", "nullable": false, "default": null },
{ "name": "user_id", "type": "bigint unsigned", "nullable": false, "default": null },
{ "name": "title", "type": "varchar(255)", "nullable": false, "default": null },
{ "name": "status", "type": "enum('draft','published','archived')", "nullable": false, "default": "draft" },
{ "name": "published_at", "type": "timestamp", "nullable": true, "default": null }
],
"primary_key": ["id"],
"indexes": [
{ "name": "posts_status_index", "columns": ["status"], "unique": false }
],
"foreign_keys": [
{ "name": "posts_user_id_foreign", "columns": ["user_id"], "references_table": "users", "references_columns": ["id"], "on_update": null, "on_delete": "cascade" }
]
},
{
"name": "role_user",
"columns": [
{ "name": "role_id", "type": "bigint unsigned", "nullable": false, "default": null },
{ "name": "user_id", "type": "bigint unsigned", "nullable": false, "default": null }
],
"primary_key": ["role_id", "user_id"],
"indexes": [],
"foreign_keys": [
{ "name": "role_user_role_id_foreign", "columns": ["role_id"], "references_table": "roles", "references_columns": ["id"], "on_update": null, "on_delete": "cascade" },
{ "name": "role_user_user_id_foreign", "columns": ["user_id"], "references_table": "users", "references_columns": ["id"], "on_update": null, "on_delete": "cascade" }
]
},
{
"name": "roles",
"columns": [
{ "name": "id", "type": "bigint unsigned", "nullable": false, "default": null },
{ "name": "name", "type": "varchar(255)", "nullable": false, "default": null }
],
"primary_key": ["id"],
"indexes": [],
"foreign_keys": []
},
{
"name": "users",
"columns": [
{ "name": "id", "type": "bigint unsigned", "nullable": false, "default": null },
{ "name": "name", "type": "varchar(255)", "nullable": false, "default": null },
{ "name": "email", "type": "varchar(255)", "nullable": false, "default": null }
],
"primary_key": ["id"],
"indexes": [
{ "name": "users_email_unique", "columns": ["email"], "unique": true }
],
"foreign_keys": []
}
]
|
Download
