表名 | 存储内容 | 关键字段 | 备注 |
project | 项目主表 | ID | |
pname | 项目名称 | ||
URL | URL | ||
LEAD | 项目主管 | ||
DESCRIPTION | 描述 | ||
pkey | 项目KEY | ||
pcounter | |||
ASSIGNEETYPE | |||
AVATAR | |||
ORIGINALKEY | |||
PROJECTTYPE | 项目类型 | ||
project_key | 项目key表 | ID | |
PROJECT_ID | 项目ID | ||
PROJECT_KEY | 项目KEY | ||
projectrole | 项目角色 | ID | |
NAME | |||
DESCRIPTION | |||
projectroleactor | 项目角色关联关系 | ID | |
PID 项目ID | |||
PROJECTROLEID | 项目角色ID | ||
ROLETYPE | 角色类型 atlassian-group-role-actor、atlassian-user-role-actor | ||
ROLETYPEPARAMETER | 具体用户或用户组 | ||
issuetype | issue类型 | ID | |
SEQUENCE | |||
pname | 类型名称 | ||
pstyle | |||
DESCRIPTION | |||
ICONURL | |||
AVATAR | |||
issuestatus | issue状态 | ID | |
SEQUENCE | |||
pname | 状态名称 | ||
DESCRIPTION | |||
ICONURL | |||
STATUSCATEGORY | |||
priority | issue优先级 | ID | |
SEQUENCE | |||
pname | 优先级名称 | ||
DESCRIPTION | |||
resolution | issue解决结果 | ID | |
SEQUENCE | |||
pname | 解决结果名称 | ||
DESCRIPTION | |||
issuetypescreenscheme | issue的scheme名称 | ID | |
NAME | |||
DESCRIPTION | |||
issuetypescreenschemeentity | issue的scheme详情 | ID | |
ISSUETYPE | |||
SCHEME issuetypescreenscheme的ID | |||
FIELDSCREENSCHEME fieldscreenscheme的ID | |||
fieldscreen | 字段的screen | ID | |
NAME | |||
DESCRIPTION | |||
fieldscreenscheme | 字段的screenscheme | ID | |
NAME | |||
DESCRIPTION | |||
fieldscreenschemeitem | 字段的screenschemeitem | ID | |
OPERATION | |||
FIELDSCREEN fieldscreen的ID | |||
FIELDSCREENSCHEME fieldscreenscheme的ID | |||
fieldscreentab | ID | ||
NAME | |||
DESCRIPTION | |||
SEQUENCE | |||
FIELDSCREEN fieldscreen的ID | |||
jiraissue | JIRA的issue | ID | |
pkey | 空字段 | ||
issuenum | 和project表pkey字段 组合成issue key | ||
PROJECT project的ID | 关联project表ID | ||
REPORTER 报告人 | 报告人 | ||
ASSIGNEE 指派人 | 经办人 | ||
CREATOR | 创建人 | ||
issuetype issuetype的ID | 关联issuetype表ID | ||
SUMMARY | 标题 | ||
DESCRIPTION | 描述 | ||
ENVIRONMENT | |||
PRIORITY | 关联priority表ID | ||
RESOLUTION | 关联表resolution表ID | ||
issuestatus issuestatus的ID | 关联issuestatus表ID | ||
CREATED | 创建时间 | ||
UPDATED | 更新时间 | ||
DUEDATE | |||
RESOLUTIONDATE | 解决时间 | ||
VOTES | |||
WATCHES | |||
TIMEORIGINALESTIMATE | |||
TIMEESTIMATE | |||
TIMESPENT | |||
WORKFLOW_ID | 工作流id | ||
SECURITY | |||
FIXFOR | |||
workflowscheme | ID | ||
NAME | |||
DESCRIPTION | |||
workflowschemeentity | ID | ||
SCHEME workflowscheme的ID | |||
WORKFLOW | |||
issuetype | |||
jiraworkflows | JIRA的工作流 | ID | |
workflowname | |||
creatorname | |||
DESCRIPTOR | |||
ISLOCKED | |||
configurationcontext | ID | ||
PROJECTCATEGORY | |||
PROJECT | |||
customfield | |||
FIELDCONFIGSCHEME | |||
worklog | 登录工时表 | ID | |
issueid | issueid 关联jiraissue表ID | ||
AUTHOR | 添加工时作者 | ||
grouplevel | |||
rolelevel | |||
worklogbody | 添加工时备注 | ||
CREATED | 添加时间 | ||
UPDATEAUTHOR | 修改人 | ||
UPDATED | 修改时间 | ||
STARTDATE | 工时开始时间 | ||
timeworked | 工时时长,单位秒 | ||
CUSTOMFIELD | 自定义字段表 | ID | |
cfkey | |||
CUSTOMFIELDTYPEKEY | |||
CUSTOMFIELDSEARCHERKEY | |||
cfname | 自定义字段名 | ||
DESCRIPTION | 描述 | ||
defaultvalue | 默认值 | ||
FIELDTYPE | |||
PROJECT | |||
ISSUETYPE | |||
customfieldoption | 自定义字段选项表 | ID | |
CUSTOMFIELD | 关联customfield表ID | ||
CUSTOMFIELDCONFIG | 自定义字段配置 | ||
PARENTOPTIONID | |||
SEQUENCE | 选项顺序 | ||
customvalue | 选项值 | ||
optiontype | |||
disabled | 是否禁用 | ||
customfieldvalue | 自定义字段值表 | ID | |
ISSUE | issueid 关联jiraissue表ID | ||
CUSTOMFIELD | 自动以字段id 关联customfield表ID | ||
UPDATED | 更新时间 | ||
PARENTKEY | 父节点 key | ||
STRINGVALUE | 字符串类型值 如果是选项类型,关联customfieldoption表ID | ||
NUMBERVALUE | 数字类型值 | ||
TEXTVALUE | 文本类型值 | ||
DATEVALUE | 日期类型值 | ||
VALUETYPE | 值类型 | ||
issuelinktype | issue链接类型表 | ID | 类型ID |
LINKNAME | 类型名称 | ||
INWARD | 链接方描述 | ||
OUTWARD | 被链接方描述 | ||
pstyle | |||
issuelink | issue链接表 | ID | |
LINKTYPE | 关联issuelinktype表ID | ||
SOURCE | 链接方 issueid 关联jiraissue表ID | ||
DESTINATION | 被链接方 issueid 关联jiraissue表ID | ||
SEQUENCE | |||
changegroup | issue修改组表 | ID | |
issueid | 关联jiraissue表ID | ||
AUTHOR | 修改人 | ||
CREATED | 创建时间 | ||
changeitem | issue修改记录表 | ID | |
groupid | 修改组id 关联changegroup表ID | ||
FIELDTYPE | 字段类型 jira, custom | ||
FIELD | 字段名 | ||
OLDVALUE | 原始ID等 | ||
OLDSTRING | 原始字符串 | ||
NEWVALUE | 新值ID等 | ||
NEWSTRING | 新值字符串 | ||
nodeassociation | issue 内部字段值表 | SOURCE_NODE_ID | 关联jiraissue表ID |
SOURCE_NODE_ENTITY | issue类型 | ||
SINK_NODE_ID | 值id (比如 模块id, 关联component表ID) | ||
SINK_NODE_ENTITY | 值类型 (比如:Component) | ||
ASSOCIATION_TYPE | 类型 | ||
SEQUENCE | |||
component | 模块表 | ID | 模块表 |
PROJECT | 项目ID 关联project表ID | ||
cname | 模块名称 | ||
description | 描述 | ||
URL | |||
LEAD | |||
ASSIGNEETYPE | |||
ARCHIVED |
jira数据库表结构
于 2022-03-17 14:02:35 首次发布