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}