opensource

Tables (31)

BADGE

  • badge_id (id) — bigint(20) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • image_url — varchar(255) — NOT NULL

COMMENT (Untitled5)

  • comment_id (Key) — bigint(20) — Primary key — NOT NULL
  • member_id (id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL
  • type (Key4) — tinyint(1) — Foreign key → COMMENT_TYPE.comment_type_id — NOT NULL
  • repository_qna_id (Key3) — bigint(20) — Foreign key → REPOSITORY_QNA.repository_qna_id
  • repository_post_id (Key2) — bigint(20) — Foreign key → REPOSITORY_POST.repository_post_id
  • content (Field) — varchar(255) — NOT NULL

COMMENT_TYPE (Untitled6)

  • comment_type_id (Key) — tinyint(1) — Primary key — NOT NULL
  • title (Field) — varchar(255) — NOT NULL

COMMIT_HISTORY (Untitled)

  • commit_history_id (Key) — bigint(20) — Primary key — NOT NULL
  • repository_id (id) — bigint(20) — Foreign key → REPOSITORY.repository_id — NOT NULL
  • date (Field) — datetime — NOT NULL

CURRICULUM

  • curriculum_id (id) — bigint(20) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL

CURRICULUM_TAG

  • curriculum_tag_id (Key) — bigint(20) — Primary key — NOT NULL
  • curriculum_id — bigint(20) — Foreign key → CURRICULUM.curriculum_id — NOT NULL
  • tag_id — bigint(20) — Foreign key → TAG.tag_id — NOT NULL

GITHUB_SYNC

  • github_sync_id (id) — bigint(20) — Primary key — NOT NULL
  • login_nickname — varchar(255) — NOT NULL
  • access_token (refresh_token) — varchar(255) — NOT NULL
  • refresh_token (access_token) — varchar(255) — NOT NULL

HASHTAG (Untitled8)

  • hashtag_id (Key) — bigint(20) — Primary key — NOT NULL
  • repository_post_id (Key2) — bigint(20) — Foreign key → REPOSITORY_POST.repository_post_id
  • repository_qna_id (Key3) — bigint(20) — Foreign key → REPOSITORY_QNA.repository_qna_id
  • title (Field) — varchar(255) — NOT NULL

ISSUE

  • issue_id (id) — bigint(20) — Primary key — NOT NULL
  • repository_id — bigint(20) — Foreign key → REPOSITORY.repository_id — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — varchar(255)
  • close_fl (done_fl) — tinyint(1) — NOT NULL

ISSUE_CONTRIBUTOR (USER_ISSUE)

  • issue_contributor_id (Key) — bigint(20) — Primary key — NOT NULL
  • member_id (user_id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL
  • issue_id — bigint(20) — Foreign key → ISSUE.issue_id — NOT NULL

LECTURE

  • lecture_id (id) — bigint(20) — Primary key — NOT NULL
  • Key (curriculum_id) — bigint(20) — Foreign key → CURRICULUM.curriculum_id — NOT NULL
  • title — varchar(255) — NOT NULL
  • type — enum — NOT NULL
  • link — varchar(255) — NOT NULL
  • count — int — NOT NULL
  • content — varchar(255) — NOT NULL

LECTURE_HISTORY

  • lecture_history_id (id) — bigint(20) — Primary key — NOT NULL
  • lecture_id — bigint(20) — Foreign key → LECTURE.lecture_id — NOT NULL
  • member_id (user_id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL
  • date — datetime — NOT NULL

LECTURE_TAG

  • lecture_tag_id (Key) — bigint(20) — Primary key — NOT NULL
  • lecture_id — bigint(20) — Foreign key → LECTURE.lecture_id — NOT NULL
  • tag_id — bigint(20) — Foreign key → TAG.tag_id — NOT NULL

MEMBER (USER)

  • member_id (id) — bigint(20) — Primary key — NOT NULL
  • github_sync_id — bigint(20) — Foreign key → GITHUB_SYNC.github_sync_id
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • avata_url — varchar(255)
  • github_sync_fl — tinyint(1) — NOT NULL
  • Role (Field) — ENUM — NOT NULL

MEMBER_BADGE (USER_BADGE)

  • member_badge_id (Key) — bigint(20) — Primary key — NOT NULL
  • member_id (user_id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL
  • badge_id — bigint(20) — Foreign key → BADGE.badge_id — NOT NULL

MEMBER_FOLLOW (Untitled10)

  • member_follow_id (Key) — bigint(20) — Primary key — NOT NULL
  • from_member_id (id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL
  • to_member_id (id2) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL

MEMBER_TECH_LANGUAGE (USER_TOPIC)

  • member_tech_language_id (Key) — bigint(20) — Primary key — NOT NULL
  • member_id (user_id) — bigint(20) — Foreign key → TECH_LANGUAGE.tech_language_id — NOT NULL
  • tech_language_id (topic_id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL

MEMBER_TOPIC (USER_TECH_LANGUAGE)

  • member_topic_id (Key) — bigint(20) — Primary key — NOT NULL
  • member_id (user_id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL
  • topic_id (tech_language_id) — bigint(20) — Foreign key → TOPIC.topic_id — NOT NULL

REPOSITORY

  • repository_id (id) — bigint(20) — Primary key — NOT NULL
  • member_id (id2) — bigint(20) — Foreign key → MEMBER.member_id
  • title — varchar(255) — NOT NULL
  • github_address — varchar(255) — NOT NULL
  • content — varchar(255)

REPOSITORY_CONTRIBUTOR (Untitled12)

  • repository_contributor_id (Key) — bigint(20) — Primary key — NOT NULL
  • repository_id (id) — bigint(20) — Foreign key → REPOSITORY.repository_id — NOT NULL
  • member_id (id2) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL

REPOSITORY_FOLLOW (Untitled11)

  • repository_follow_id (Key) — bigint(20) — Primary key — NOT NULL
  • repository_id (id) — bigint(20) — Foreign key → REPOSITORY.repository_id — NOT NULL
  • member_id (id2) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL

REPOSITORY_POST (Untitled4)

  • repository_post_id (Key) — bigint(20) — Primary key — NOT NULL
  • repository_id (id) — bigint(20) — Foreign key → REPOSITORY.repository_id — NOT NULL
  • member_id (id2) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL
  • title (Field) — varchar(255) — NOT NULL
  • content (Field2) — varchar(255) — NOT NULL
  • merge_fl (Field5) — tinyint(1) — NOT NULL
  • date (Field3) — datetime — NOT NULL
  • close_state (Field4) — tinyint(1) — NOT NULL

REPOSITORY_POST_MEMBER_LIKE (Untitled7)

  • repository_post_like_id (Key2) — bigint(20) — Primary key — NOT NULL
  • repository_post_id (Key) — bigint(20) — Foreign key → REPOSITORY_POST.repository_post_id — NOT NULL
  • member_id (id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL

REPOSITORY_QNA (Untitled3)

  • repository_qna_id (Key) — bigint(20) — Primary key — NOT NULL
  • member_id (id2) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL
  • repository_id (id) — bigint(20) — Foreign key → REPOSITORY.repository_id — NOT NULL
  • title (Field) — varchar(255) — NOT NULL
  • content (Field2) — varchar(255) — NOT NULL
  • comment (Field3)

REPOSITORY_QNA_MEMBER_LIKE (Untitled9)

  • repository_qna__like_id (Key2) — bigint(20) — Primary key — NOT NULL
  • repository_qna_id (Key) — bigint(20) — Foreign key → REPOSITORY_QNA.repository_qna_id — NOT NULL
  • user_id (id) — bigint(20) — Foreign key → MEMBER.member_id — NOT NULL

REPOSITORY_TECH_LANGUAGE (REPOSITORY_TOPIC)

  • repository_tech_language_id (Key) — bigint(20) — Primary key — NOT NULL
  • tech_language_id (repository_id) — bigint(20) — Foreign key → REPOSITORY.repository_id — NOT NULL
  • repository_id (topic_id) — bigint(20) — Foreign key → TECH_LANGUAGE.tech_language_id — NOT NULL

REPOSITORY_TOPIC (Untitled2)

  • repository_topic_id (Key) — bigint(20) — Primary key — NOT NULL
  • topic_id (id) — bigint(20) — Foreign key → TOPIC.topic_id — NOT NULL
  • repository_id (id2) — bigint(20) — Foreign key → REPOSITORY.repository_id — NOT NULL

TAG

  • tag_id (id) — bigint(20) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL

TECH_LANGUAGE (TOPIC)

  • tech_language_id (id) — bigint(20) — Primary key — NOT NULL
  • language_name (title) — varchar(255) — NOT NULL
  • color (Field) — NOT NULL

TOPIC (TECH_LANGUAGE)

  • topic_id (id) — bigint(20) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL

Untitled13