|
|
# 经营风险-司法拍卖
|
|
|
|
|
|
# 存储信息
|
|
|
aliyun-mysql-rds
|
|
|
|
|
|
* host: bdp-rds-003.mysql.rds.aliyuncs.com
|
|
|
* port: 3306
|
|
|
* user: **
|
|
|
* password: **
|
|
|
* database: utn_ng_biz_info
|
|
|
|
|
|
# 建表语句
|
|
|
|
|
|
```sql
|
|
|
CREATE TABLE `tb_judicial_sale` (
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
|
|
|
`title` varchar(400) DEFAULT NULL COMMENT '公告名',
|
|
|
`court` varchar(255) DEFAULT NULL COMMENT '资产处置单位',
|
|
|
`pub_time` datetime DEFAULT NULL COMMENT '公告时间',
|
|
|
`pub_id` varchar(50) NOT NULL COMMENT '公告id',
|
|
|
`source` varchar(50) NOT NULL COMMENT '来源网站',
|
|
|
`content` varchar(255) DEFAULT NULL COMMENT '公告内容存储路径',
|
|
|
`sale_start_date` date DEFAULT NULL COMMENT '拍卖开始日期',
|
|
|
`sale_end_date` date DEFAULT NULL COMMENT '拍卖截止日期',
|
|
|
`source_url` varchar(300) DEFAULT NULL COMMENT '原始链接',
|
|
|
`use_flag` int(1) DEFAULT '0' COMMENT '使用标志0正常,1人工已修正,2调试中,3未解析,9删除,10废弃',
|
|
|
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间',
|
|
|
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
|
|
PRIMARY KEY (`id`),
|
|
|
UNIQUE KEY `pub_id` (`pub_id`,`source`),
|
|
|
KEY `idx_create_time` (`create_time`),
|
|
|
KEY `idx_update_time` (`update_time`)
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|
|
|
|
|
|
``` |
|
|
\ No newline at end of file |