mod biz_tb_certificate.md
mod biz_company_employment.md

lake/biz_land_result_announcement.md

@@ -11,4 +11,48 @@
 
 # 建表语句
 
-```sql
\ No newline at end of file
+```sql
+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
+
+```
+# 数据字典
\ No newline at end of file