评论表、回复表设计

来源：互联网发布：越狱怎么清除所有数据编辑：程序博客网时间：2024/06/05 08:11

建表

     CREATE TABLE `comment` (        `id` varchar(50) NOT NULL,        `issue_id` varchar(50) NOT NULL COMMENT '笔记Id',        `user_id` varchar(50) NOT NULL COMMENT '回复人',        `reply_msg` varchar(500) DEFAULT NULL COMMENT '回复内容',        `create_date` datetime NOT NULL COMMENT '创建时间',        `zan_count` int COMMENT '赞数',        PRIMARY KEY (`id`)      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='评论表'            CREATE TABLE `reply` (        `id` varchar(50) NOT NULL,        `comment_id` varchar(50) NOT NULL COMMENT '评论Id',        `from_user_id` varchar(50) NOT NULL COMMENT '回复人',        `to_user_id` varchar(50) NOT NULL COMMENT '回复对象',        `reply_msg` varchar(500) DEFAULT NULL COMMENT '回复内容',        `create_date` datetime NOT NULL COMMENT '创建时间',        PRIMARY KEY (`id`),        KEY `reply_fk1` (`comment_id`),        CONSTRAINT `reply_fk1` FOREIGN KEY (`comment_id`) REFERENCES `comment` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='回复表'

阅读全文

0 0