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