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