sq
Tables (16)
AlgorithmCampHistoryDetail
- idx — BIGINT — Primary key — NOT NULL — algorithmCampHistoryDetailIdx
- algorithmCampHistoryIdx — BIGINT — algorithmCampHistoryIdx
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
CMCHistory
- idx — BIGINT — Primary key — NOT NULL — cmcHistoryIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
FireflyExpedition
- idx — BIGINT — Primary key — NOT NULL — fireflyExpeditionIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- waiverType — VARCHAR(45) — NOT NULL — 개인사유, 능력부족, 학교병행, 업무병행, 수업불만족
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
HeadhuntingHistory
- idx — BIGINT — Primary key — NOT NULL — headhuntingHistoryIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
KeeperUser
- idx — BIGINT — Primary key — NOT NULL — keeperUserIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- adminNumber — CHAR(6) — NOT NULL — 사원번호
- mbti — CHAR(4) — 논의 필요 MBTI 정말 필요한가? 필요하다면 너디너리유저로 옮겨서 수집가능한 사람들은 다 수집할까?
- residentRegistrationNumber — VARCHAR(45) — 주민등록번호
- crewName — VARCHAR(45) — 크루명
- teamName — VARCHAR(45) — 팀명
- positionName — VARCHAR(45) — 직책/직무명
- enteringDate — DATE — NOT NULL — 입사일자, null=사업소득자
- address — TEXT — 거주지 주소
- status — VARCHAR(45) — NOT NULL — ACT, INACT, DELETE
OutsourceHistory
- idx — BIGINT — Primary key — NOT NULL — outsourceHistoryIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
PMCHistory
- idx — BIGINT — Primary key — NOT NULL — pmcHistoryIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
RisingCampHistory
- idx — BIGINT — Primary key — NOT NULL — risingCampHistoryIdx
- risingCampIdx — BIGINT — NOT NULL — risingCampIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- graduateStatus — VARCHAR(45) — NOT NULL — PROCEEDING, GRADUATE, WAIVER
- waiverType — VARCHAR(45) — NOT NULL — 개인사유, 능력부족, 학교병행, 업무병행, 수업불만족
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
RisingCampHistoryDetail
- idx — BIGINT — Primary key — NOT NULL — risingCampHistoryDetailIdx
- risingCampHistoryIdx — BIGINT — Foreign key → RisingCampHistory.idx — risingCampHistoryIdx
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
RisingProgrammerHistory
- idx — BIGINT — Primary key — NOT NULL — risingProgrammerHistoryIdx
- risingCampIdx — BIGINT — Foreign key → risingProgrammer.idx — NOT NULL — risingProgrammerIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- graduateStatus — VARCHAR(45) — NOT NULL — PROCEEDING, GRADUATE, WAIVER
- waiverType — VARCHAR(45) — NOT NULL — 개인사유, 능력부족, 학교병행, 업무병행, 수업불만족
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
RisingTestHistory
- idx — BIGINT — Primary key — NOT NULL — risingTestHistoryIdx
- neordinaryUserIdx — BIGINT — neordinaryUserIdx
- risingTestIdx — BIGINT — risingTestIdx
- platform — VARCHAR(45) — 플랫폼
- productivityAbility — NUMERIC(5, 1) — 생산성
- similarityAbility — NUMERIC(5, 1) — 유사도
- communicationAbility — NUMERIC(5, 1) — 커뮤니케이션능력
- responsibilityAbility — NUMERIC(5, 1) — 책임감
- workAbility — NUMERIC(5, 1) — 업무처리능력
- problemSolveAbility — NUMERIC(5, 1) — (사라졌나요?)
- creativityAbility — NUMERIC(5, 1) — 사고력
- projectName — VARCHAR(45) — 실전프로젝트명
- projectResultUrl — TEXT — 실전프로젝트제출링크
- etc — TEXT — 비고
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
RisingTestHistoryDetail
- idx — BIGINT — Primary key — NOT NULL — risingTestHistoryDetailIdx
- risingTestHistoryIdx — BIGINT — Foreign key → RisingTestHistory.idx — risingTestHistoryIdx
- abilityType — VARCHAR(45) — productivity, similarity, communication, responsibility, work, problemSolve, creativity
- abilityDescription — VARCHAR(45) — 평가내용
- abilityScore — NUMERIC(5, 1) — 평가점수
- etc — TEXT — 비고
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
TwoTwoBasicChallenge
- idx — BIGINT — Primary key — NOT NULL — twoTwoBasicChallengeIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- waiverType — VARCHAR(45) — NOT NULL — 개인사유, 능력부족, 학교병행, 업무병행, 수업불만족
- status — VARCHAR(45) — ACT, INACT, DELETE
- aa — VARCHAR(45) — 필요한 컬럼 채우기
UMCHistory
- idx — BIGINT — Primary key — NOT NULL — umcHistoryIdx
- neordinaryUserIdx — BIGINT — NOT NULL — neordinaryUserIdx
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
risingProgrammer
- idx — BIGINT — Primary key — NOT NULL — risingProgrammerIdx
- programmerRound — INT — 기수(회차)
- startDate — DATE — 시작일자
- endDate — DATE — 종료일자
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기
risingProgrammerHistoryDetail
- idx — BIGINT — Primary key — NOT NULL — risingProgrammerHistoryDetailIdx
- algorithmCampHistoryIdx — BIGINT — Foreign key → RisingProgrammerHistory.idx — risingProgrammerHistoryIdx
- status — VARCHAR(45) — ACT, INACT, DELETE
- aaa — VARCHAR(45) — 필요한 컬럼 채우기