Sync Github data to Sourcetable

CARD

A card contains user, column, issue, notem archived, is deleted and timestamps for created and updated at

COLUMN

Contains project, name, is deleted and timestamps for created and updated at

COMMIT

Contains repository, author mail, commiter mail, author name and date, committer name and date and message

COMMIT_FILE

Contains commit sha, filename, additions, changes, deletions, and status

COMMIT_PARENT

Contains associations of commit sha and parent sha

ISSUE

Contains milestone, repository, user, body, closed at, created at, locked, number, satte, title, and updated at

ISSUE_ASSIGNEE

Contains associations of issue id and user id

ISSUE_ASSIGNEE_HISTORY

Contains associations of issue id, user id, assignee id, and assigned

ISSUE_CLOSED_HISTORY

Contains associations of issue id, user id,commit sha, and closed

ISSUE_COMMENT

Contains issue id, user id, body, and timestamps for created and updated at

ISSUE_LABEL

Contains associations of issue id and label

ISSUE_LABEL_HISTORY

Contains the associations of issue id, user, label, labeled and updated at

ISSUE_LOCKED_HISTORY

Contains issue id, user, locked and updated at

ISSUE_MENTION

Contains associations of issue id, user id and updated at

ISSUE_MERGED

Contains commit sha, issue id, actor id and merged at

ISSUE_MILESTONE_HISTORY

Contains associations of issue id, actor id, milestone id, updated at and milestoned

ISSUE_PROJECT_HISTORY

Contains issue id, project id, updated at, actor id, card id, removed, column name and previous column name

ISSUE_REFERENCED

Contains associations of issue id, actor id, commit sha and referenced at

ISSUE_RENAMED

Contains issue id, updated at, actor id, from name and to name

MILESTONE

Contains creator id, repository id, closed at, creted at description, due on, number, state, title, is deleted and updated at

PROJECT

Contains repository, creator id, body, number, state, name, created at, updated at and is deleted

PULL_REQUEST

Contains base sha, base repo id, base user id, head sha, head repo id, head user id, issue id, merge commit sha, base label, base ref, draft, head label and head ref

PULL_REQUEST_REVIEW

Contains pull request id, user id, commit sha, body, state, submitted at

PULL_REQUEST_REVIEW_DISMISSED

Contains review id, actor id, dismissal commit sha, created at, dismissal message, and state

REPO_TEAM

Contains associations of repository, team and permission

REPOSITORY

Contains archived, owner id, created at, default branch, description, fork, full name, homepage, language, name and private

REQUESTED_REVIEW_HISTORY

Contains pull request, created at, requested at, actor id, and revoved

TEAM

A team contains user, it's parent team, name, slug, description and privacy fields

TEAM_MEMBERSHIP

Contains associations of team and user

USER

Contains user information like bio, blog, company, hireable, login, name, type, site admin, location

USER_EMAIL

Contains email, user id and name