快速数据库结构生成助手

{ "databaseSchema": "CREATE TABLE users (\n id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n username VARCHAR(50) NOT NULL,\n email VARCHAR(255) NOT NULL,\n phone VARCHAR(20),\n password_hash VARCHAR(255) NOT NULL,\n avatar_url VARCHAR(512),\n status TINYINT NOT NULL DEFAULT 1,\n signup_ip VARCHAR(45),\n last_login_at DATETIME,\n created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (id),\n UNIQUE KEY uk_users_username (username),\n UNIQUE KEY uk_users_email (email),\n INDEX idx_users_phone (phone)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\nCREATE TABLE roles (\n id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n name VARCHAR(50) NOT NULL,\n description VARCHAR(255),\n created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (id),\n UNIQUE KEY uk_roles_name (name)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\nCREATE TABLE orders (\n id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n user_id BIGINT UNSIGNED NOT NULL,\n status TINYINT NOT NULL DEFAULT 0,\n total_amount DECIMAL(10,2) NOT NULL DEFAULT 0.00,\n created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (id),\n INDEX idx_orders_user_id (user_id),\n CONSTRAINT fk_orders_user FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\nCREATE TABLE profiles (\n user_id BIGINT UNSIGNED NOT NULL,\n full_name VARCHAR(100),\n birthday DATE,\n bio TEXT,\n created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n PRIMARY KEY (user_id),\n CONSTRAINT fk_profiles_user FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\n\nCREATE TABLE user_roles (\n user_id BIGINT UNSIGNED NOT NULL,\n role_id BIGINT UNSIGNED NOT NULL,\n assigned_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (user_id, role_id),\n INDEX idx_ur_role_id (role_id),\n CONSTRAINT fk_user_roles_user FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT fk_user_roles_role FOREIGN KEY (role_id) REFERENCES roles(id) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;", "tables": [ { "tableName": "users", "fields": [ {"name": "id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "username", "type": "VARCHAR(50)", "isPrimaryKey": false}, {"name": "email", "type": "VARCHAR(255)", "isPrimaryKey": false}, {"name": "phone", "type": "VARCHAR(20)", "isPrimaryKey": false}, {"name": "password_hash", "type": "VARCHAR(255)", "isPrimaryKey": false}, {"name": "avatar_url", "type": "VARCHAR(512)", "isPrimaryKey": false}, {"name": "status", "type": "TINYINT", "isPrimaryKey": false}, {"name": "signup_ip", "type": "VARCHAR(45)", "isPrimaryKey": false}, {"name": "last_login_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "created_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "updated_at", "type": "DATETIME", "isPrimaryKey": false} ] }, { "tableName": "roles", "fields": [ {"name": "id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "name", "type": "VARCHAR(50)", "isPrimaryKey": false}, {"name": "description", "type": "VARCHAR(255)", "isPrimaryKey": false}, {"name": "created_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "updated_at", "type": "DATETIME", "isPrimaryKey": false} ] }, { "tableName": "orders", "fields": [ {"name": "id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "user_id", "type": "BIGINT UNSIGNED", "isPrimaryKey": false}, {"name": "status", "type": "TINYINT", "isPrimaryKey": false}, {"name": "total_amount", "type": "DECIMAL(10,2)", "isPrimaryKey": false}, {"name": "created_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "updated_at", "type": "DATETIME", "isPrimaryKey": false} ] }, { "tableName": "profiles", "fields": [ {"name": "user_id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "full_name", "type": "VARCHAR(100)", "isPrimaryKey": false}, {"name": "birthday", "type": "DATE", "isPrimaryKey": false}, {"name": "bio", "type": "TEXT", "isPrimaryKey": false}, {"name": "created_at", "type": "DATETIME", "isPrimaryKey": false}, {"name": "updated_at", "type": "DATETIME", "isPrimaryKey": false} ] }, { "tableName": "user_roles", "fields": [ {"name": "user_id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "role_id", "type": "BIGINT UNSIGNED", "isPrimaryKey": true}, {"name": "assigned_at", "type": "DATETIME", "isPrimaryKey": false} ] } ], "relationships": [ "orders.user_id -> users.id", "profiles.user_id -> users.id", "user_roles.user_id -> users.id", "user_roles.role_id -> roles.id" ] }