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