jira schema

events=> \d jira.*;
          Table "jira.comments"
  Column  |       Type        | Modifiers 
----------+-------------------+-----------
 id       | integer           | not null
 issue_id | integer           | 
 author   | character varying | 
 body     | character varying | 
 created  | bigint            | 
Indexes:
    "comments_pkey" PRIMARY KEY, btree (id)

  Index "jira.comments_pkey"
 Column |  Type   | Definition 
--------+---------+------------
 id     | integer | id
primary key, btree, for table "jira.comments"

           Table "jira.components"
   Column    |       Type        | Modifiers 
-------------+-------------------+-----------
 id          | integer           | not null
 name        | character varying | 
 description | character varying | 
Indexes:
    "components_pkey" PRIMARY KEY, btree (id)

 Index "jira.components_pkey"
 Column |  Type   | Definition 
--------+---------+------------
 id     | integer | id
primary key, btree, for table "jira.components"

   Table "jira.issue_components"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 issue_id     | integer | not null
 component_id | integer | not null
Indexes:
    "issue_components_pkey" PRIMARY KEY, btree (issue_id, component_id)

  Index "jira.issue_components_pkey"
    Column    |  Type   |  Definition  
--------------+---------+--------------
 issue_id     | integer | issue_id
 component_id | integer | component_id
primary key, btree, for table "jira.issue_components"

        Table "jira.issue_labels"
  Column  |       Type        | Modifiers 
----------+-------------------+-----------
 issue_id | integer           | not null
 label    | character varying | not null
Indexes:
    "issue_labels_pkey" PRIMARY KEY, btree (issue_id, label)

      Index "jira.issue_labels_pkey"
  Column  |       Type        | Definition 
----------+-------------------+------------
 issue_id | integer           | issue_id
 label    | character varying | label
primary key, btree, for table "jira.issue_labels"

             Table "jira.issue_links"
      Column      |       Type        | Modifiers 
------------------+-------------------+-----------
 outward_issue_id | integer           | not null
 inward_issue_id  | integer           | not null
 type             | character varying | not null
Indexes:
    "issue_links_pkey" PRIMARY KEY, btree (outward_issue_id, inward_issue_id, type)

              Index "jira.issue_links_pkey"
      Column      |       Type        |    Definition    
------------------+-------------------+------------------
 outward_issue_id | integer           | outward_issue_id
 inward_issue_id  | integer           | inward_issue_id
 type             | character varying | type
primary key, btree, for table "jira.issue_links"

      Table "jira.issue_subtasks"
     Column      |  Type   | Modifiers 
-----------------+---------+-----------
 parent_issue_id | integer | not null
 child_issue_id  | integer | not null
Indexes:
    "issue_subtasks_pkey" PRIMARY KEY, btree (parent_issue_id, child_issue_id)

      Index "jira.issue_subtasks_pkey"
     Column      |  Type   |   Definition    
-----------------+---------+-----------------
 parent_issue_id | integer | parent_issue_id
 child_issue_id  | integer | child_issue_id
primary key, btree, for table "jira.issue_subtasks"

             Table "jira.issues"
    Column    |       Type        | Modifiers 
--------------+-------------------+-----------
 id           | integer           | not null
 creator      | character varying | 
 description  | character varying | 
 issuetype    | character varying | 
 reporter     | character varying | 
 created      | bigint            | 
 project      | character varying | 
 summary      | character varying | 
 assignee     | character varying | 
 resolution   | character varying | 
 epic_key     | character varying | 
 epic_name    | character varying | 
 epic_status  | character varying | 
 status       | character varying | 
 story_points | integer           | 
 dcos_area    | character varying | 
 mesos_link   | character varying | 
Indexes:
    "issues_pkey" PRIMARY KEY, btree (id)

   Index "jira.issues_pkey"
 Column |  Type   | Definition 
--------+---------+------------
 id     | integer | id
primary key, btree, for table "jira.issues"

              Table "jira.users"
    Column     |       Type        | Modifiers 
---------------+-------------------+-----------
 username      | character varying | not null
 display_name  | character varying | 
 email_address | character varying | 
Indexes:
    "users_pkey" PRIMARY KEY, btree (username)

          Index "jira.users_pkey"
  Column  |       Type        | Definition 
----------+-------------------+------------
 username | character varying | username
primary key, btree, for table "jira.users"