Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
K
kb
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 2
    • Issues 2
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • granite
  • kb
  • Wiki
    • Lake
  • risk_tb_judicial_sale

risk_tb_judicial_sale · Changes

Page history
mod risk_tb_judicial_sale.md authored May 12, 2021 by 韩双's avatar 韩双
Hide whitespace changes
Inline Side-by-side
Showing with 35 additions and 0 deletions
+35 -0
  • lake/risk_tb_judicial_sale.md lake/risk_tb_judicial_sale.md +35 -0
  • No files found.
lake/risk_tb_judicial_sale.md 0 → 100644
View page @ e33c43a0
# 经营风险-司法拍卖
# 存储信息
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
Clone repository
  • README
  • basic_guidelines
  • basic_guidelines
    • basic_guidelines
    • dev_guide
    • project_build
    • 开发流程
  • best_practice
  • best_practice
    • AlterTable
    • RDS
    • azkaban
    • create_table
    • design
    • elasticsearch
    • elasticsearch
      • ES运维
    • logstash
View All Pages