| Info | ||
|---|---|---|
| ||
The following is a description of the database tables created during the installation of Herzum Approval add-on into your JIRA instance. |
| Info | ||
|---|---|---|
| ||
|
Database Diagram
Tables Details
TABLE AO_68CA91_MODERATOR_MAPPING | ||
|---|---|---|
| The Table holds the Moderators per Project/Repository | ||
| Column | Type | Description |
| [ID] | [int] NOT NULL | The Unique Moderator Mapping Identifier (Primary Key) |
| [MODERATORS] | [nvarchar](255) NULL | It maintains theusernames of the Moderators separated by comma. |
| [PROJECT_KEY] | [nvarchar](255) NULL | The Project |
| Key | ||
| [REPOSITORY_SLUG] | [nvarchar](255) NULL | The Repository |
| Slug |
TABLE AO_68CA91_UTILITY_CONFIG | ||
|---|---|---|
| Column | Type | Description |
| [ID] | [int] NOT NULL | The Utility Config Identifier (Primary Key) |
TABLE [dbo].[sta_activity](
[id] [bigint] NOT NULL,
[activity_type] [int] NOT NULL,
[created_timestamp] [datetime] NOT NULL,
[user_id] [int] NOT NULL,
TABLE [dbo].[sta_pr_activity](
[activity_id] [bigint] NOT NULL,
[pr_id] [bigint] NOT NULL,
[pr_action] [int] NOT NULL,
E.g pr_action=7 APPROVE
TABLE [dbo].[repository](
[id] [int] NOT NULL,
[slug] [nvarchar](128) NOT NULL,
[name] [nvarchar](128) NOT NULL,
[state] [int] NOT NULL,
[project_id] [int] NOT NULL,
[scm_id] [nvarchar](255) NOT NULL,
[hierarchy_id] [nvarchar](20) NOT NULL,
[is_forkable] [bit] NOT NULL,
[is_public] [bit] NOT NULL,
TABLE [dbo].[project](
[id] [int] NOT NULL,
[name] [nvarchar](128) NOT NULL,
[project_key] [nvarchar](128) NOT NULL,
[description] [nvarchar](255) NULL,
[project_type] [int] NOT NULL,
[namespace] [nvarchar](128) NOT NULL,