wanted2

Tables (39)

BlockingCompany

  • userIdx — int — Primary key — NOT NULL
  • companyIdx — int — Primary key — NOT NULL
  • blokingIdx — int
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

Bookmark

  • userIdx — int — Primary key — NOT NULL
  • positionIdx — int — Primary key — NOT NULL
  • bookmarkIdx — int
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

CareerPerformance

  • careerIdx — int — Primary key — NOT NULL
  • performanceIdx — int
  • title — varchar(50)
  • period — varchar
  • content — text
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

Community

  • userIdx — int — Primary key — NOT NULL
  • communityIdx — int
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • category — varchar(50) — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

CommunityComment

  • userIdx — int — Primary key — NOT NULL
  • communityIdx — int — Primary key — NOT NULL
  • commentIdx — int
  • comment — text — NOT NULL — ext not nul
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

CommunityLike

  • userIdx — int — Primary key — NOT NULL
  • communityIdx — int — Primary key — NOT NULL
  • likeIdx — int
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

Company

  • companyIdx — int
  • name — varchar(50) — NOT NULL
  • introduce — text — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • responseLevel — varchar(40) — 응답률
  • logo — text

CompanyCategory

  • positionIdx — int — Primary key — NOT NULL
  • categoryIdx — int
  • largeCategory — varchar(30) — NOT NULL
  • mediumCategory — varchar(30) — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

CompanyDetail

  • companyIdx — int — Primary key — NOT NULL
  • companyDetailIdx — int
  • nation — varchar(30) — NOT NULL
  • region — varchar(30) — NOT NULL
  • businessCode — varchar(100) — NOT NULL — 사업자 등록 번호
  • sales — int — NOT NULL — 단위 억원
  • industry — varchar(30) — NOT NULL — 산업군
  • employeeNum — varchar(30) — NOT NULL — ex XX~XXX
  • establishment — varchar(30) — NOT NULL
  • phoneNum — varchar(30) — NOT NULL
  • email — varchar(50) — NOT NULL
  • website — varchar(50)
  • recommendedPath — varchar(30)
  • agreeClause — char(15) — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • address — varchar(100) — NOT NULL — 대표 주소

CompanyImage

  • companyIdx — int — Primary key — NOT NULL
  • companyImageIdx — int
  • image — text
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

CompanyNews

  • companyIdx — int — Primary key — NOT NULL
  • newsIdx — int
  • news — text — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • headline — varchar(100)

CompanyOffer

  • companyIdx — int — Primary key — NOT NULL
  • userIdx — int — Primary key — NOT NULL
  • offeredIdx — int
  • type — varchar(30) — NOT NULL — like: 원해요, open: 프로필열람, offer: 받은제안
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

CompanyPosition

  • companyIdx — int — Primary key — NOT NULL
  • positionIdx — int
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • deadline — varchar(30) — NOT NULL — 상시도 있기 때문에 varchar() 형식을 사용
  • recommenderReward — int — 추천인 보상금
  • applicantReward — int — 지원자 보상금
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • workingPlace — varchar(100) — NOT NULL — 근무 장소
  • careerYears — int — 경력 년 수

CompanyTag

  • companyIdx — int — Primary key — NOT NULL
  • tagIdx — int
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • tag — varchar(30) — NOT NULL

Event

  • eventIdx — int
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • category — varchar(30) — NOT NULL — wanted plus, 커리어, 개발, ...
  • type — varchar(30) — NOT NULL — article : 아티클, education : 교육, ...
  • freeStatus — varchar(15) — NOT NULL — free : 무료 charge : 유료
  • date — varchar(30)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

EventMapping

  • companyIdx — int — Primary key — NOT NULL
  • eventIdx — int — Primary key — NOT NULL
  • mappingIdx — int
  • createdAt — timestamp
  • updatedAT — datetime
  • status — char(15)

EventTag

  • eventIdx — int — Primary key — NOT NULL
  • eventTagIdx — int
  • eventTag — varchar(30)
  • status — char(15) — 0 : 태그 해제 1 : 태그 선택됨

FollowCompany

  • userIdx — int — Primary key — NOT NULL
  • companyIdx — int — Primary key — NOT NULL
  • followIdx — int
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

ForeignLanguageTest

  • languageIdx — int — Primary key — NOT NULL
  • testIdx — int
  • test — varchar(30)
  • result — varchar(30)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • period — varchar

InquiryImage

  • inquiryIdx — int — Primary key — NOT NULL
  • imageIdx — int
  • image — text

InterestCompetency

  • userIdx — int — Primary key — NOT NULL
  • competencyIdx — int
  • competency — varchar(30)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

InterestInsight

  • userIdx — int — Primary key — NOT NULL
  • insightIdx — int
  • insight — varchar(30)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

InterestJob

  • userIdx — int — Primary key — NOT NULL
  • jobIdx — int
  • job — varchar(30)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

LikeCompany

  • userIdx — int — Primary key — NOT NULL
  • positionIdx — int — Primary key — NOT NULL
  • likeIdx — int
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

Notification

  • userIdx — int — Primary key — NOT NULL
  • notification — int
  • title — varchar(50) — NOT NULL
  • content — varchar(100) — NOT NULL
  • status — char(15) — inactive
  • isSaw — char(2) — 봤으면 y 안 봤으면 n
  • createdAt — timestamp

ResumeAcademy

  • resumeIdx — int — Primary key — NOT NULL
  • academyIdx — int
  • academy — varchar(40) — NOT NULL
  • period — varchar
  • isAttending — varchar(15)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • major — varchar(30) — 전공
  • researchContent — text — 연구 내용

ResumeAward

  • resumeIdx — int — Primary key — NOT NULL
  • awardIdx — int
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL — 세부사항
  • period — varchar
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

ResumeCareer

  • resumeIdx — int — Primary key — NOT NULL
  • careerIdx — int
  • company — varchar(40) — NOT NULL — 회사 이름
  • period — varchar
  • isWorking — varchar(15)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • department — varchar(30) — 부서명/직책

ResumeForeignLanguage

  • resumeIdx — int — Primary key — NOT NULL
  • languageIdx — int
  • language — varchar(30) — NOT NULL
  • level — varchar(30) — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

ResumeLink

  • resumeIdx — int — Primary key — NOT NULL
  • linkIdx — int
  • link — text
  • status — char(15) — 삭제 여부. 삭제하면 0
  • createdAt — timestamp
  • updatedAt — datetime

ResumeSkill

  • resumeIdx — int — Primary key — NOT NULL
  • skillIdx — int
  • skill — varchar(30)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

SuggestTag

  • companyIdx — int — Primary key — NOT NULL
  • suggestIdx — int
  • tag — varchar(30) — NOT NULL
  • createdAt — timestamp

User

  • userIdx — int
  • name — varchar(15) — NOT NULL
  • email — varchar(50) — NOT NULL
  • password — text
  • phoneNum — varchar(25) — NOT NULL
  • profileImage — text
  • eventAd — char(15)
  • employAd — char(15)
  • agreeClause — char(15) — NOT NULL
  • loginType — varchar(20) — kakao', 'naver'
  • wanted, — status
  • createdAt — timestamp
  • updatedAt — datetime
  • interest — varchar(30) — 관심사 고민

UserApplication

  • userIdx — int — Primary key — NOT NULL
  • positionIdx — int — Primary key — NOT NULL
  • applicationIdx — int
  • progress — varchar(30) — 접수(=지원 완료), 서류 통과, 최종 합격, 불합격
  • recommendStatus — varchar(30) — 추천 현황 ex. 추천인 없음, 김예준(=추천인 이름)
  • isRewarded — char(2) — 보상금 신청 여부 1이면 신청함
  • status — char(15) — 삭제 여부. 0이면 삭제됨
  • createdAt — timestamp
  • updatedAt — datetime

UserDetail

  • userIdx — int — Primary key — NOT NULL
  • detailIdx — int
  • jobGroup — varchar(30)
  • jobDeatil — varchar(40)
  • careerYears — int
  • income — int — 연봉, 단위(만)
  • skill — varchar(40)
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • wantJobStatus — varchar(30) — 구직 여부

UserInquiry

  • userIdx — int — Primary key — NOT NULL
  • inquiryIdx — int
  • email — varchar(50) — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • phoneNum — varchar(30)
  • agreeClause — char(15) — NOT NULL
  • createdAt — timestamp

UserPoint

  • userIdx — int — Primary key — NOT NULL
  • pointIdx — int
  • point — int — NOT NULL
  • status — char(15)
  • createdAt — timestamp

UserReferral

  • userIdx — int — Primary key — NOT NULL
  • referralIdx — int
  • friendName — varchar(40) — NOT NULL
  • phoneNum — varchar(30) — NOT NULL
  • content — text
  • relation — varchar(30) — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

UserResume

  • userIdx — int — Primary key — NOT NULL
  • resumeIdx — int
  • content — text
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime
  • name — varchar(50) — NOT NULL — 이력서 이름
  • isMatchUp — char(10) — true or false
  • isWriting — char(10) — true or false