elancer
Tables (19)
AcademicAbility (CopyOfCopyOfCopyOfUntitled)
- num (Key) — Primary key — NOT NULL
- schoolName (Field) — ID
- schoolLevel (Field2) — PASSWORD
- enterSchoolDate (Field3) — 이름
- graduationDate (Field4) — 연락처
- academicState (Field5) — 이메일
- freelancerProfile_num (Key2) — Foreign key → FreelancerProfile.num — NOT NULL
ApplyProject (CopyOfCopyOfCopyOfUntitled3)
- num (Key) — Primary key — NOT NULL
- project_num (Key2) — Foreign key → Project.num — NOT NULL — 식별자
- member_num (Key3) — Foreign key → Freelancer.member_num — NOT NULL — 식별자
Career (CopyOfCopyOfCopyOfCopyOfUntitled)
- num (Key) — Primary key — NOT NULL
- companyName (Field) — ID
- departmentName (Field2) — PASSWORD
- companyPosition (Field3) — 이름
- graduationDate (Field4) — 연락처
- careerEndDate (Field5) — 이메일
- freelancerProfile_num (Key2) — Foreign key → FreelancerProfile.num — NOT NULL
Education (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- num (Key) — Primary key — NOT NULL
- educationTitle (Field) — ID
- educationOrganization (Field2) — PASSWORD
- educationStartDate (Field3) — 이름
- educationEndDate (Field4) — 연락처
- freelancerProfile_num (Key2) — Foreign key → FreelancerProfile.num — NOT NULL
Enterprise (CopyOfCopyOfUntitled2)
- member_num (Key) — Foreign key → Member.Key — NOT NULL — 식별자
- companyName (Field) — ID
- companyPeople (Field2) — PASSWORD
- position (Field3) — 이름
- telNumber (Field4) — 연락처
- bizContents (Field5) — 이메일
- sales (Field6) — 웹사이트
- idNumber (Field7) — 국가
- enterpriseIntro_num (Key2) — Foreign key → EnterpriseIntro.num — NOT NULL
EnterpriseIntro (CopyOfCopyOfCopyOfUntitled2)
- num (Key) — Primary key — NOT NULL
- introTitle (Field) — ID
EnterpriseMainBiz (CopyOfCopyOfCopyOfCopyOfUntitled2)
- num (Key) — Primary key — NOT NULL
- etc (Field) — ID
- enterpriseIntro_num (Key2) — Foreign key → EnterpriseIntro.num — NOT NULL
- mainBusiness_num (Key3) — Foreign key → MainBusiness.num — NOT NULL
EnterpriseSubBiz (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)
- num (Key) — Primary key — NOT NULL
- etc (Field) — ID
- enterpriseIntro_num (Key2) — Foreign key → EnterpriseIntro.num — NOT NULL
- subBusiness_num (Key3) — Foreign key → SubBusiness.num — NOT NULL
- Field2
Freelancer (CopyOfUntitled)
- member_num (Key) — Foreign key → Member.Key — NOT NULL — 식별자
- birthDate (Field) — ID
- workEtcField (Field2) — PASSWORD
- careerYear (Field3) — 이름
- careerMonth (Field4) — 연락처
- hopeMonthMinPay (Field5) — 이메일
- hopeMonthMaxPay (Field6) — 웹사이트
- kosaState (Field7) — 국가
- mailReceptionState (Field8) — 우편번호
- presentWorkState (Field9) — 메인주소
- hopeWorkState (Field10) — 상세 주소
- workPossibleState (Field11) — JWT 리플래쉬 토큰
- workStartPossibleDate (Field12) — 경험 평가 점수
- hopeWorkCountry (Field13) — 일정 평가 점수
- hopeWorkCity (Field14) — 적극성 평가 점수
- freelancerProfile_num (Key2) — Foreign key → FreelancerProfile.num — NOT NULL
FreelancerProfile (CopyOfCopyOfUntitled)
- num (Key) — Primary key — NOT NULL
- greeting (Field) — ID
- introduceName (Field2) — PASSWORD
- introBackGround (Field3) — 이름
- introduceVideoURL (Field4) — 연락처
- introduceContent (Field5) — 이메일
InterviewProject (CopyOfCopyOfCopyOfCopyOfUntitled3)
- num (Key) — Primary key — NOT NULL
- interviewStatus (Field)
- project_num (Key2) — Foreign key → Project.num — NOT NULL — 식별자
- member_num (Key3) — Foreign key → Freelancer.member_num — NOT NULL — 식별자
Language (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- num (Key) — Primary key — NOT NULL
- languageName (Field) — ID
- languageAbility (Field2) — PASSWORD
- freelancerProfile_num (Key2) — Foreign key → FreelancerProfile.num — NOT NULL
License (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- num (Key) — Primary key — NOT NULL
- licenseTitle (Field) — ID
- licenseIssuer (Field2) — PASSWORD
- acquisitionDate (Field3) — 이름
- freelancerProfile_num (Key2) — Foreign key → FreelancerProfile.num — NOT NULL
MainBusiness (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- num (Key) — Primary key — NOT NULL
- code (Field) — ID
- bizName (Field2)
Member (Untitled)
- Key — Primary key — NOT NULL — 식별자
- userId (Field) — ID
- password (Field2) — PASSWORD
- name (Field3) — 이름
- phone (Field4) — 연락처
- email (Field5) — 이메일
- website (Field6) — 웹사이트
- countryType (Field7) — 국가
- zipcode (Field8) — 우편번호
- mainAddress (Field9) — 메인주소
- detailAddress (Field10) — 상세 주소
- refreshToken (Field11) — JWT 리플래쉬 토큰
- expertise (Field12) — 경험 평가 점수
- scheduleAdherence (Field13) — 일정 평가 점수
- initiative (Field14) — 적극성 평가 점수
- communication (Field15) — 의사소통 평가 점수
- reEmploymentIntention (Field16) — 재고용 의사 평가 점수
- assessmentCount (Field17) — 평가 횟수
- totalRawScore (Field18) — 총 평가 점수
- totalActiveScore (Field19) — 평균 평가 점수
- memberType (Field20) — 회원 타입
Project (CopyOfUntitled2)
- num (Key) — Primary key — NOT NULL — 식별자
- projectType (Field) — ID
- projectBackGround (Field2) — PASSWORD
- enterpriseLogo (Field3) — 이름
- projectStep (Field4) — 연락처
- mainBiz (Field5) — 이메일
- positionKind (Field6) — 웹사이트
- skill (Field7) — 국가
- projectName (Field8) — 우편번호
- headCount (Field9) — 메인주소
- inputHeadCount (Field10) — 상세 주소
- content (Field11) — JWT 리플래쉬 토큰
- projectStateDate (Field12) — 경험 평가 점수
- projectEndDate (Field13) — 일정 평가 점수
- recruitEndDate (Field14) — 적극성 평가 점수
- countryType (Field15) — 의사소통 평가 점수
- zipcode (Field16) — 재고용 의사 평가 점수
- mainAddress (Field17) — 평가 횟수
- detailAddress (Field18) — 총 평가 점수
- minMoney (Field19) — 평균 평가 점수
- maxMoney (Field20) — 회원 타입
- careerYear (Field21)
- careerMonth (Field22)
- minDesiredAge (Field23)
- maxDesiredAge (Field24)
- projectStatus (Field25)
- member_num (Key2) — Foreign key → Enterprise.member_num — NOT NULL — 식별자
ProjectHistory (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled)
- num (Key) — Primary key — NOT NULL
- projectTitle (Field) — ID
- projectStartDate (Field2) — PASSWORD
- projectEndDate (Field3) — 이름
- clientCompany (Field4) — 연락처
- workCompany (Field5) — 이메일
- developField (Field6)
- developRole (Field7)
- developEnvironment (Field8)
- responsibilityTask (Field9)
- freelancerProfile_num (Key2) — Foreign key → FreelancerProfile.num — NOT NULL
SubBusiness (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- num (Key) — Primary key — NOT NULL
- code (Field) — ID
- bizName (Field2)
WaitProject (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled3)
- num (Key) — Primary key — NOT NULL
- waitStatus (Field)
- project_num (Key2) — Foreign key → Project.num — NOT NULL — 식별자
- member_num (Key3) — Foreign key → Freelancer.member_num — NOT NULL — 식별자