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