小说作者表结构优化

SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;

-- Table structure for novel_author

DROP TABLE IF EXISTS novel_author; CREATE TABLE novel_author ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', user_id bigint(20) NOT NULL COMMENT '用户id', pen_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作者笔名', real_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名', email varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', phone varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号码', bank_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '银行名称', bank_account varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '银行账户', bank_address varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开户行', review_status tinyint(4) NOT NULL COMMENT '审核状态', review_status_msg varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '审核状态描述', create_by varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', create_time datetime NULL DEFAULT NULL COMMENT '创建时间', update_by varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', update_time datetime NULL DEFAULT NULL COMMENT '更新时间', remark varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (id) USING BTREE, INDEX idx_user_id(user_id) USING BTREE, INDEX idx_pen_name(pen_name) USING BTREE, INDEX idx_review_status(review_status) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

-- 添加外键关系，假设user表存在 ALTER TABLE novel_author ADD CONSTRAINT fk_novel_author_user FOREIGN KEY (user_id) REFERENCES user (id);