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
  • ic_branch

ic_branch · Changes

Page history
update: 加字段 authored Oct 29, 2021 by 王鹏举's avatar 王鹏举
Hide whitespace changes
Inline Side-by-side
Showing with 9 additions and 4 deletions
+9 -4
  • lake/ic_branch.md lake/ic_branch.md +9 -4
  • No files found.
lake/ic_branch.md
View page @ 422be3c7
...@@ -39,7 +39,9 @@ ic表的n_branches列表字段是工商展示分支机构+名称解析处理合 ...@@ -39,7 +39,9 @@ ic表的n_branches列表字段是工商展示分支机构+名称解析处理合
"company_status": "分支机构登记状态", "company_status": "分支机构登记状态",
"n_company_status": "归类后的分支机构登记状态", "n_company_status": "归类后的分支机构登记状态",
"cancel_date": "分支机构注销日期", "cancel_date": "分支机构注销日期",
"revoke_date": "分支机构吊销日期" "revoke_date": "分支机构吊销日期",
"legal_person": "法人",
"legal_person_npid": "法人id(aqc)"
}, },
..., ...,
...@@ -64,7 +66,9 @@ ic表的n_branches列表字段是工商展示分支机构+名称解析处理合 ...@@ -64,7 +66,9 @@ ic表的n_branches列表字段是工商展示分支机构+名称解析处理合
"cancel_date": "分支机构注销日期", "cancel_date": "分支机构注销日期",
"revoke_date": "分支机构吊销日期", "revoke_date": "分支机构吊销日期",
"create_time": "入库时间", "create_time": "入库时间",
"lastupdatetime": "最后更新时间" "lastupdatetime": "最后更新时间",
"legal_person": "法人",
"legal_person_npid": "法人id(aqc)"
} }
``` ```
...@@ -87,9 +91,10 @@ ic表的n_branches列表字段是工商展示分支机构+名称解析处理合 ...@@ -87,9 +91,10 @@ ic表的n_branches列表字段是工商展示分支机构+名称解析处理合
| revoke_date | date | 分支机构吊销日期 | | revoke_date | date | 分支机构吊销日期 |
| create_time | date | 入库时间 | | create_time | date | 入库时间 |
| lastupdatetime | date | 最后更新时间 | | lastupdatetime | date | 最后更新时间 |
| legal_person | string | 法人 |
| legal_person_npid | string | 法人id(aqc) |
# 使用说明 # 使用说明
* 查询企业当前的分支机构,应该选择n_company_status = '正常' * 查询企业当前的分支机构,应该选择n_company_status = '正常'
* 查询企业的历史分支机构,应该选择n_company_status != '正常' * 查询企业的历史分支机构,应该选择n_company_status != '正常'
\ 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