Table CUSTOMFIELDS


This view does not expose all custom fields, but only those which are available for user due to his JIRA permissions.

ColumnTypeNotes
IDBIGINT NOT NULL
ISSUEBIGINT NOT NULLPoints to Table ISSUES
TYPEIDBIGINT NOT NULLSee https://confluence.atlassian.com/jirakb/how-to-find-id-for-custom-field-s-744522503.html
STRINGVALUEVARHAR
NUMBERVALUENUMERIC
TEXTVALUEVARCHAR
DATEVALUEDATETIME
NAMEVARCHAR
DESCRIPTIONVARCHAR