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) — 필요한 컬럼 채우기