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 — 식별자