asd

Tables (39)

BlockingCompany

  • blokingIdx — int — Primary key — NOT NULL
  • companyIdx — int — Foreign key → Company.companyIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

Bookmark

  • bookmarkIdx — int — Primary key — NOT NULL
  • positionIdx — int — Foreign key → CompanyPosition.positionIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

CareerPerformance

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

Community

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

CommunityComment

  • commentIdx — int — Primary key — NOT NULL
  • communityIdx — int — Foreign key → Community.communityIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • comment — text — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

CommunityLike

  • likeIdx — int — Primary key — NOT NULL
  • communityIdx — int — Foreign key → Community.communityIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

Company

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

CompanyCategory

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

CompanyDetail

  • companyDetailIdx — int — Primary key — NOT NULL
  • companyIdx — int — Foreign key → Company.companyIdx — NOT NULL
  • 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

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

CompanyNews

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

CompanyOffer

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

CompanyPosition

  • positionIdx — int — Primary key — NOT NULL
  • companyIdx — int — Foreign key → Company.companyIdx — NOT NULL
  • 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

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

Event

  • eventIdx — int — Primary key — NOT NULL
  • 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

  • mappingIdx — int — Primary key — NOT NULL
  • companyIdx — int — Foreign key → Company.companyIdx — NOT NULL
  • eventIdx — int — Foreign key → Event.eventIdx — NOT NULL
  • createdAt — timestamp
  • updatedAT — datetime
  • status — char(15)

EventTag

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

FollowCompany

  • followIdx — int — Primary key — NOT NULL
  • companyIdx — int — Foreign key → Company.companyIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

ForeignLanguageTest

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

InquiryImage

  • imageIdx — int — Primary key — NOT NULL
  • inquiryIdx — int — Foreign key → UserInquiry.inquiryIdx — NOT NULL
  • image — text

InterestCompetency

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

InterestInsight

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

InterestJob

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

LikeCompany

  • likeIdx — int — Primary key — NOT NULL
  • positionIdx — int — Foreign key → CompanyPosition.positionIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • status — char(15)
  • createdAt — timestamp
  • updatedAt — datetime

Notification

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

ResumeAcademy

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

ResumeAward

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

ResumeCareer

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

ResumeForeignLanguage

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

ResumeLink

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

ResumeSkill

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

SuggestTag

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

User

  • userIdx — int — Primary key — NOT NULL
  • 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

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

UserDetail

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

UserInquiry

  • inquiryIdx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • 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

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

UserReferral

  • referralIdx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • 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

  • resumeIdx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • 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