JIRA表结构梳理
表名
存储内容
关键字段
project
项目主表
ID
pname 项目名称
URL
LEAD
DESCRIPTION
pkey 项目KEY
pcounter
ASSIGNEETYPE
AVATAR
ORIGINALKEY
PROJECTTYPE
project_key
项目key表
ID
PROJECT_ID 项目ID
PROJECT_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
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 project的ID
REPORTER 报告人
ASSIGNEE 指派人
CREATOR
issuetype issuetype的ID
SUMMARY
DESCRIPTION
ENVIRONMENT
PRIORITY
RESOLUTION
issuestatus issuestatus的ID
CREATED
UPDATED
DUEDATE
RESOLUTIONDATE
VOTES
WATCHES
TIMEORIGINALESTIMATE
TIMEESTIMATE
TIMESPENT
WORKFLOW_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
以上是 JIRA表结构梳理 的全部内容， 来源链接： utcz.com/z/512181.html
