经营状况-购地信息

存储信息

aliyun-mysql-rds

• host: bdp-rds-003.mysql.rds.aliyuncs.com
• port: 3306
• user: **
• password: **
• database: utn_ng_biz_info

建表语句

CREATE TABLE `land_result_announcement` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `electronic_regulatory_number` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '电子监管号',
  `land_use_right_person` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '土地使用权人',
  `landUser_clean` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '通过打内链清洗后土地使用权人',
  `district` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '行政区',
  `project_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '项目名称',
  `project_location` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '项目位置',
  `area` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '面积(公顷)',
  `land_source_value` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '土地来源实际值',
  `land_source_view` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '土地来源显示值，通过将土地来源实际值与土地面积比较来确定显示值',
  `land_use_type` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '土地用途',
  `land_supply_method` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '供地方式',
  `land_use_period` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '土地使用年限',
  `category` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '行业分类',
  `land_level` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '土地级别',
  `transaction_price` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '成交价格(万元)',
  `contracted_volume_rate` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '约定容积率下限',
  `contracted_volume_rate_ceiling` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '约定容积率上限',
  `committed_time` date DEFAULT NULL COMMENT '约定交地时间',
  `agreement_start_time` date DEFAULT NULL COMMENT '约定开工时间',
  `actual_start_time` date DEFAULT NULL COMMENT '实际开工时间',
  `scheduled_completion` date DEFAULT NULL COMMENT '约定竣工时间',
  `actual_completion_time` date DEFAULT NULL COMMENT '实际竣工时间',
  `authority` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '批准单位',
  `contract_date` date DEFAULT NULL COMMENT '合同签订日期',
  `instalment_payment` longtext CHARACTER SET utf8 COMMENT '分期支付约定\r\n存储json格式\r\ncontract_payment_period_number：分期支付约定支付期号；\r\nconvention_payment_date：分期支付约定约定支付日期；\r\nagreed_payment_amount：约定支付金额(万元)；\r\nagreement_notes：分期支付约定备注；',
  `chain_link` longtext COMMENT '内链',
  `url` varchar(250) CHARACTER SET utf8 DEFAULT NULL COMMENT '获取数据url',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除，0非删除，1删除',
  `company_name_digest` char(32) DEFAULT NULL COMMENT '对应主体唯一键',
  `company_id` char(32) DEFAULT NULL COMMENT '对应主体唯一键',
  PRIMARY KEY (`id`),
  UNIQUE KEY `urlData` (`url`),
  KEY `landUser` (`land_use_right_person`),
  KEY `num` (`electronic_regulatory_number`),
  KEY `landUser_clean` (`landUser_clean`),
  KEY `idx_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

数据字典

样例