SSAFY CommitMood

Tables (7)

ACCESS_TOKEN

  • ID — BIGINT — Primary key — NOT NULL
  • USER_ACCOUNT_ID — BIGINT — Foreign key → USER_ACCOUNT.ID — NOT NULL
  • ACCESS_TOKEN — VARCHAR(20)
  • TOKEN_TYPE — VARCHAR(20)
  • SCOPE — VARCHAR(500)
  • EXPIRES_AT — TIMESTAMP
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

COMMIT_ANALYSIS

  • ID — BIGINT — Primary key — NOT NULL
  • COMMIT_LOG_ID — BIGINT — Foreign key → COMMIT_LOG.ID — NOT NULL
  • FLAGGED_COUNT — BIGINT
  • SWEAR_COUNT — BIGINT
  • EXCLAIM_COUNT — BIGINT
  • EMOJI_COUNT — BIGINT
  • SENTIMENT — VARCHAR(20)
  • SENTIMENT_SCORE — DECIMAL(5, 2)
  • ANALYZED_AT — TIMESTAMP
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

COMMIT_FILE_CHANGE

  • ID — BIGINT — Primary key — NOT NULL
  • COMMIT_LOG_ID — BIGINT — Foreign key → COMMIT_LOG.ID — NOT NULL
  • FILENAME — VARCHAR(500)
  • PREV_FILENAME — VARCHAR(500)
  • STATUS — VARCHAR(20)
  • ADDITIONS — BIGINT
  • DELETIONS — BIGINT
  • CHANGES — INT
  • PATCH — CLOB
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

COMMIT_LOG

  • ID — BIGINT — Primary key — NOT NULL
  • GITHUB_REPO_ID — BIGINT — Foreign key → GITHUB__REPO.ID — NOT NULL
  • USER_ACCOUNT_ID — BIGINT — Foreign key → USER_ACCOUNT.ID — NOT NULL
  • GITHUB_COMMIT_SHA — CHAR(40)
  • COMMITTED_AT — TIMESTAMP
  • MESSAGE — CLOB
  • HTML_URL — VARCHAR(255)
  • ADDITIONS — BIGINT
  • DELETIONS — BIGINT
  • TOTAL_CHANGES — BIGINT
  • FILES_CHANGED — BIGINT
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

FLAGGED_TOKEN

  • ID — BIGINT — Primary key — NOT NULL
  • COMMIT_LOG_ID — BIGINT — Foreign key → COMMIT_LOG.ID — NOT NULL
  • TOKEN — VARCHAR(200)
  • TOKEN_TYPE — VARCHAR(20)
  • WEIGHT — BIGINT
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

GITHUB__REPO (GITHUB_REPO)

  • ID — BIGINT — Primary key — NOT NULL
  • USER_ACCOUNT_ID — BIGINT — Foreign key → USER_ACCOUNT.ID — NOT NULL
  • GITHUB_REPO_FULLNAME — VARCHAR(200)
  • GITHUB_REPO_ID — BIGINT
  • GITHUB_REPO_NAME — VARCHAR(100)
  • DEFAULT_BRANCH — VARCHAR(100)
  • DESCRIPTION — CLOB
  • GITHUB_REPO_URL — VARCHAR(255)
  • IS_PRIVATE — BOOLEAN
  • LAST_SYNCED_AT — TIMESTAMP
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

USER_ACCOUNT

  • ID — BIGINT — Primary key — NOT NULL
  • GITHUB_USER_ID — BIGINT
  • GITHUB_LOGIN — VARCHAR(100)
  • GITHUB_EMAIL — VARCHAR(150)
  • GITHUB_AVATAR_URL — VARCHAR(250)
  • GITHUB_NAME — VARCHAR(100)
  • LAST_SYNCED_AT — TIMESTAMP
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP