SKU-UMC

Tables (27)

application_form_answer (신청서 답변)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • header_id (답변 헤더 ID) — BIGINT — Foreign key → application_form_answer_header.id — NOT NULL
  • question_id (질문 아이디) — BIGINT — Foreign key → application_form_template.id — NOT NULL
  • select_item_id (선택 항목 ID) — BIGINT — Foreign key → application_form_select_item.id
  • answer_text (텍스트 답변) — TEXT

application_form_answer_header (신청서 답변 헤더)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • created_at (생성일자) — TIMESTAMP — NOT NULL — now()

application_form_header (신청서 헤더)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • user_id (유저 ID) — BIGINT — Foreign key → user.id — NOT NULL
  • part_id (파트 ID) — INT — Foreign key → part.id — NOT NULL
  • course (과정) — ENUM — NOT NULL — {JUNIOR,SENIOR}
  • cohort (깃수) — INT — NOT NULL
  • default_info_id (기본 정보 ID) — BIGINT — Foreign key → user_default_info.id — NOT NULL
  • form_template_id (폼 템플릿 ID) — BIGINT — Foreign key → application_form_template_header.id — NOT NULL
  • form_answer_id (폼 답변 ID) — BIGINT — Foreign key → application_form_answer_header.id — NOT NULL
  • portfolio_id (포트폴리오ID) — BIGINT — Foreign key → portfolio_header.id — NOT NULL
  • available_time_id (면접 가능 시간 ID) — BIGINT — Foreign key → available_time_header.id — NOT NULL

application_form_select_item (신청서 선택 항목)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • question_id (질문 아이디) — BIGINT — Foreign key → application_form_template.id — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • enabled (활성화 여부) — BOOLEAN — NOT NULL

application_form_template (신청서 템플릿)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • header_id (신청서 헤더 ID) — BIGINT — Foreign key → application_form_template_header.id — NOT NULL
  • question (질문) — TEXT — NOT NULL
  • type (타입) — ENUM — NOT NULL — {TEXT,SELECT,RADIO}
  • required (필수여부) — BOOLEAN — NOT NULL
  • enabled (활성화 여부) — BOOLEAN — NOT NULL

application_form_template_header (신청서 템플릿 헤더)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • part_id (파트 ID) — INT — Foreign key → part.id — NOT NULL
  • name (템플릿 이름) — VARCHAR(100) — NOT NULL
  • created_at (생성일자) — TIMESTAMP — NOT NULL — now()
  • updated_at (수정일자) — TIMESTAMP — @updatedAt

apply_result (신청 결과)

  • id (ID) — BIGINT — Primary key — NOT NULL — auto_increment()
  • application_form_id (신청서 ID) — BIGINT — Foreign key → application_form_header.id — NOT NULL
  • first_result (1차 결과) — BOOLEAN
  • second_result (2차 결과) — BOOLEAN

available_time (면접 가능 시간)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • header_id (헤더 ID) — BIGINT — Foreign key → available_time_header.id — NOT NULL
  • date (일자) — DATE — NOT NULL
  • start_time (시작 시간) — TIME — NOT NULL
  • end_time (종료 시간) — TIME — NOT NULL
  • deleted_at (삭제된 시간) — TIMESTAMP

available_time_header (면접 가능 시간 헤더)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • created_at (생성일자) — TIMESTATMP — NOT NULL — now()
  • updated_at (수정일자) — TIMESTAMP — @updated_at

challenger (챌린저)

  • id (ID) — BIGINT — Primary key — NOT NULL — auto_increment()
  • user_id (유저ID) — BIGINT — Foreign key → user.id — NOT NULL
  • part_id (파트 ID) — INT — Foreign key → part.id — NOT NULL
  • default_info_id (기본 정보 ID) — BIGINT — Foreign key → user_default_info.id — NOT NULL
  • study_leader (스터디 리더) — BOOLEAN — NOT NULL
  • course (과정) — ENUM — {JUNIOR,SENIOR}
  • cohort (깃수) — INT — NOT NULL
  • expelled_at (제명일자) — TIMESTAMP
  • completed_at (수료일자) — TIMESTAMP
  • role (역할) — ENUM — NOT NULL — {CHALLENEGER, PART_LEADER, VICE_PRESIDENT, PRESIDENT}

cohort (깃수)

  • id (ID) — INT — Primary key — NOT NULL — auto_increment()
  • cohort (깃수) — INT — NOT NULL
  • apply_start_date (모집 시작 일자) — DATETIME — NOT NULL
  • apply_end_date (모집 종료 일자) — DATETIME — NOT NULL

default_application_form (기본 신청서 목록)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • cohort (깃수) — INT — NOT NULL
  • part_id (파트 아이디) — INT — Foreign key → part.id — NOT NULL
  • form_template_id (신청 양식 ID) — BIGINT — Foreign key → application_form_template_header.id — NOT NULL

developers (개발자)

  • id (ID) — BIGINT — Primary key — NOT NULL — auto_increment()
  • project_id (프로젝트 ID) — BIGINT — Foreign key → projects.id — NOT NULL
  • challenger_id (챌린저 ID) — BIGINT — Foreign key → challenger.id — NOT NULL

faq

  • id (ID) — INT — Primary key — NOT NULL — auto_increment()
  • question (질문) — TEXT — NOT NULL
  • answer (답변) — TEXT — NOT NULL

files (파일)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • name (파일명) — VARCHAR(200) — NOT NULL
  • uploaded_at (업로드 일자) — TIMESTAMP — NOT NULL — now()

major (전공)

  • id (아이디) — INT — Primary key — NOT NULL — auto_increment()
  • name (과 이름) — VARCHAR(30) — NOT NULL
  • enabled (활성화 여부) — BOOLEAN — NOT NULL

notification (알림)

  • id (ID) — BIGINT — Primary key — NOT NULL — auto_increment()
  • title (제목) — VARCHAR(100) — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • created_at (생성일자) — TIMESTAMP — NOT NULL — now()

out_history (아웃 기록)

  • id (ID) — BIGINT — Primary key — NOT NULL — auto_increment()
  • challenger_id (챌린저 ID) — BIGINT — Foreign key → challenger.id — NOT NULL
  • reason (사유) — TEXT — NOT NULL
  • created_at (부여 일자) — TIMESTAMP — NOT NULL — now()

part (파트)

  • id (아이디) — INT — Primary key — NOT NULL — auto_increment()
  • name (파트 이름) — VARCHAR(30) — NOT NULL
  • description (설명) — TEXT
  • enabled (활성화 여부) — BOOLEAN — NOT NULL

portfolio_header (포트폴리오 헤더)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • file_id (파일 ID) — BIGINT — Foreign key → files.id — NOT NULL

projects (프로젝트)

  • id (ID) — BIGINT — Primary key — NOT NULL — auto_increment()
  • name (프로젝트 이름) — VARCHAR(100) — NOT NULL
  • description (설명) — TEXT — NOT NULL
  • cohort (깃수) — INT — NOT NULL
  • cover_image_id (커버 이미지 ID) — BIGINT — Foreign key → files.id — NOT NULL
  • github_url (깃허브 URL) — VARCHAR(300)
  • url (URL) — VARCHAR(300)
  • created_at (생성일자) — TIMESTAMP — NOT NULL — now()

projects_tech_stacks (프로젝트 테크 스택)

  • id (ID) — BIGINT — Primary key — NOT NULL — auto_increment()
  • project_id (프로젝트 ID) — BIGINT — Foreign key → projects.id — NOT NULL
  • tech_stack_id (테크 스택 ID) — INT — Foreign key → tech_stacks.id — NOT NULL

received_notification (수신한 알림)

  • id (ID) — BIGINT — Primary key — NOT NULL — auto_increment()
  • notification_id (알림 ID) — BIGINT — Foreign key → notification.id — NOT NULL
  • user_id (유저 ID) — BIGINT — Foreign key → user.id — NOT NULL
  • is_read (읽음 여부) — BOOLEAN — NOT NULL

recruit_part (모집 파트)

  • ID (id) — BIGINT — Primary key — NOT NULL — auto_increment()
  • 깃수ID (cohort_id) — INT — Foreign key → cohort.id — NOT NULL
  • 파트ID (part_id) — INT — Foreign key → part.id — NOT NULL

tech_stacks (테크 스택)

  • id (ID) — INT — Primary key — NOT NULL — auto_increment()
  • name (이름) — VARCHAR(30) — NOT NULL

user (유저)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • name (이름) — VARCHAR(10) — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • discord_email (Discord 계정 이메일) — VARCHAR(100) — NOT NULL
  • notion_email (Notion 계정 이메일) — VARCHAR(100) — NOT NULL
  • github_profile_url (깃허브 프로필 링크) — VARCHAR(300)
  • google_uid (google 계정 UID) — VARCHAR(200) — NOT NULL
  • role (역할(권한)) — ENUM — NOT NULL — {USER,ADMIN}
  • register_completed (회원가입 완료 여부) — BOOLEAN — NOT NULL

user_default_info (유저 기본 정보)

  • id (아이디) — BIGINT — Primary key — NOT NULL — auto_increment()
  • nickname (닉네임) — VARCHAR(10) — NOT NULL
  • student_no (학번) — VARCHAR(10) — NOT NULL
  • phone (전화번호) — VARCHAR(11) — NOT NULL
  • gender (성별) — ENUM — NOT NULL — {M,F}
  • birth (생일) — DATE — NOT NULL
  • major_id (과 ID) — INT — Foreign key → major.id — NOT NULL
  • grade (학년) — DECIMAL(1-4) — NOT NULL
  • status (상태) — ENUM — NOT NULL — {ENROLLED, LEAVE_OF_ABSENCE, GRADUATION_DELAYED}