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