GAPLOG_V1

Tables (12)

CERTIFICATIONS (우리가 가지고있는 자격증 정보)

  • CERTIFICATION_ID (ID) — BIGINT — Primary key — NOT NULL
  • NAME — VARCHAR
  • descrition (자격증설명) — TEXT
  • TAGS (필요한 직무 테그) — VARCHAR
  • TEST_DAY (시험날짜(가장가까운)) — TIMESTAMP
  • REGIST_DAY (시험등록날짜) — TIMESTAMP

DAY_EMOTIONS (감정일지)

  • EMOTIONS_ID (감정ID) — BIGINT — Primary key — NOT NULL
  • USER_ID (ID) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
  • EMOTION (그날감정) — ENUM
  • CONTENT (내용) — TEXT
  • DATE (날짜) — DATE
  • created_at (생성날짜) — TIMESTAMP
  • sleeptime (잠잔시간) — time

GAP_REVIEW_BOOKMARKS (북마크한 리뷰)

  • GAR_REVIEW_BOOKMARKS_ID (ID) — BIGINT — Primary key — NOT NULL
  • USER_ID (북마크한 유저아이디) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
  • gap_reviews_id (갭리뷰id) — BIGINT — Foreign key → gap_reviews.gap_reviews_id — NOT NULL
  • CREATED_AT (북마크한 날짜) — TIMESTAMP

GOOD_COMPANIES (강소기업)

  • COMPANY_ID (ID) — BIGINT — Primary key — NOT NULL
  • NAME (기업이름) — VARCHAR(100)
  • INDUSTRY (산업) — VARCHAR(100)
  • LOCATION (위치) — VARCHAR(100)
  • established_year (설립날짜) — INT
  • employee_count (사람수) — INT

USERS

  • USER_ID (ID) — BIGINT — Primary key — NOT NULL
  • PASSWORD — VARCHAR
  • NAME — VARCHAR
  • ROLE ('USER', 'MENTOR', 'ADMIN') — ENUM
  • JOB — VARCHAR

USER_CERTIFICATIONS (유저들의 자격증)

  • USER_CERTIFICATIONS_ID (Key) — BIGINT — Primary key — NOT NULL
  • USER_ID (ID) — BIGINT — Foreign key → CERTIFICATIONS.CERTIFICATION_ID — NOT NULL
  • CERTIFICATION_ID (ID2) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL

gap_reviews (공백기후기)

  • gap_reviews_id (갭리뷰id) — BIGINT — Primary key — NOT NULL
  • USER_ID (ID) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
  • TITLE (제목) — VARCHAR(100)
  • MAJOR (전공(직종)) — VARCHAR(100)
  • CONTENT (내용) — TEXT
  • CREATED_AT (생성날자) — TIMESTAMP
  • GRADE (학점) — FLOAT
  • GAP_PERIOD (공백기간) — DATE

good_company_bookmarks (북마크한 강소기업)

  • good_company_bookmarks (ID) — BIGINT — Primary key — NOT NULL
  • COMPANY_ID (회사ID) — BIGINT — Foreign key → GOOD_COMPANIES.COMPANY_ID — NOT NULL
  • USER_ID (유저ID) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL

mentoring_answers (멘토링 질문답변)

  • mentoring_answers_ID (질문답변ID) — BIGINT — Primary key — NOT NULL
  • mentoring_questions_ID (멘토링 질문ID) — BIGINT — Foreign key → mentoring_questions.mentoring_questions_ID — NOT NULL
  • MENTOR_ID (멘토ID) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
  • CONTENT (내용) — TEXT
  • CREATED_AT (답변날짜) — TIMESTAMP

mentoring_questions (멘토링 질문)

  • mentoring_questions_ID (멘토링 질문ID) — BIGINT — Primary key — NOT NULL
  • USER_ID (ID) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
  • TITLE (제목) — VARCHAR(100)
  • CONTENT (내용) — TEXT
  • CREATED_AT (생성날짜) — TIMESTAMP

roadmap_progress (로드맵 진행도)

  • progress_id (id) — BIGINT — Primary key — NOT NULL
  • step_id (ID) — BIGINT — Foreign key → roadmap_step.step_id — NOT NULL
  • USER_ID (ID2) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
  • checked_at (Field2) — TIMESTAMP
  • Field

roadmap_step (로드맵)

  • step_id (ID) — BIGINT — Primary key — NOT NULL
  • JOBNAME (직업이름) — VARCHAR
  • title (스텝이름) — text
  • description (스텝내용) — text