CREATE TABLE `newsnotice_company` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`active`  bit NULL DEFAULT NULL COMMENT '是否可用' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_time`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
`update_by`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' ,
`sendName`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送人姓名' ,
`sendOrgName`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送人机构' ,
`conpanyId`  int(11) NULL DEFAULT NULL COMMENT '发送人ID' ,
`newsContext`  varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息内容' ,
`readstate`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阅读状态' ,
`newsnoticeId`  int NULL DEFAULT NULL COMMENT '公安消息ID' ,
PRIMARY KEY (`id`),
INDEX `newsnotice_company_key` (`id`) USING BTREE
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=COMPACT
;