KT_PROJECT

Tables (23)

ADDRESS (위치정보)

  • address (주소) — NOT NULL
  • latitude (위도) — NOT NULL
  • longitude (경도) — NOT NULL

ADDRESS_INFO (픽업 장소)

  • pickup_location_id (Key) — Primary key — NOT NULL
  • address (픽업 주소) — NOT NULL
  • address_type (주소 종류(픽업, 주차)) — NOT NULL
  • post_id (Key2) — Foreign key → JOB_POST.post_id — NOT NULL

APPLY (신청)

  • apply_id (Key) — Primary key — NOT NULL
  • status (신청 현황)
  • created_at (생성일)
  • updated_at (수정일)
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • work_day_id (Key3) — Foreign key → WORK_DATE.work_day_id — NOT NULL

AVAILABLE_INFO (Untitled)

  • meal (식사 제공 여부) — NOT NULL
  • pickup (픽업 여부) — NOT NULL
  • park (주차 가능 여부) — NOT NULL
  • Field

CERTIFICATION (경력증명서)

  • certification_id (Key) — Primary key — NOT NULL
  • storeImgName (저장된 이미지 명) — NOT NULL
  • s3Url (s3url) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL

COMPANY(EMBEDDED) (회사 계정 정보)

  • business_number (사업자 번호)
  • region (지역)
  • company_name (회사 명)
  • email (이메일)
  • manager (담당자)
  • request_content (문의 내용)

HISTORY (출근 기록)

  • history_id (Key) — Primary key — NOT NULL
  • is_work (출근 여부) — NOT NULL
  • work_date (출근 날짜) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • work_day_id (Key3) — Foreign key → WORK_DATE.work_day_id — NOT NULL

JOB_POST (일자리 공고)

  • post_id (Key) — Primary key — NOT NULL
  • title (제목) — NOT NULL
  • tech (노동자 타입)
  • address (일자리 위치) — NOT NULL
  • start_time (시작일시) — NOT NULL
  • end_time (종료일시) — NOT NULL
  • recruit_number (모집인원) — NOT NULL
  • registered_number (모집된 인원) — NOT NULL
  • wage (임금) — NOT NULL
  • available_info (가능 여부 정보) — NOT NULL
  • work_detail (작업 상세)
  • preparation (준비사항)
  • expiration_date (모집 마감)
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • project_id (Key3) — Foreign key → PROJECT.project_id — NOT NULL

JOB_POST_IMAGE (일자리 공고 이미지)

  • job_post_id (Key) — Primary key — NOT NULL
  • storeImgName (저장된 이미지 명)
  • s3Url
  • post_id (Key2) — Foreign key → JOB_POST.post_id — NOT NULL

LIKE (좋아요)

  • like_id (Key) — Primary key — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • sender_id (누른 주체) — Foreign key → MEMBER.member_id — NOT NULL
  • receiver_id (받은 주체) — Foreign key → MEMBER.member_id — NOT NULL

MEMBER (회원)

  • member_id (Key) — Primary key — NOT NULL
  • username (회원 아이디) — NOT NULL
  • password (회원 비밀번호)
  • phone (휴대폰 번호) — NOT NULL
  • role (회원 타입) — NOT NULL
  • company_info (회사 정보)
  • worker_info (노동자 정보)
  • account (계좌번호) — NOT NULL
  • bank (은행) — NOT NULL
  • deviceToken (기기 고유 식별 토큰) — NOT NULL
  • isNotification (알림 받기 여부) — NOT NULL
  • isDelete (탈퇴 여부) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • created_at (생성일) — NOT NULL

MEMBER_LOCATION (회원 위치)

  • member_location_id (Key) — Primary key — NOT NULL
  • address (주소) — NOT NULL
  • isMain (대표 위치) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL

MEMBER_RESUME (노동자 이력서)

  • member_info_id (Key) — Primary key — NOT NULL
  • position (직책) — NOT NULL
  • experienceYear (경력) — NOT NULL
  • available_info (가능 여부 정보) — NOT NULL
  • work_start_date (근무 가능 시작 일짜) — NOT NULL
  • work_end_date (근무 가능 종료 일짜) — NOT NULL
  • prefer_time (선호 시간) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL

NOTIFICATION (알림)

  • notification_id (Key) — Primary key — NOT NULL
  • content (알림 내용) — NOT NULL
  • url (이동 url)
  • isRead (읽음처리) — NOT NULL
  • notification_type (알림 타입) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL

OFFER (헤드헌팅)

  • offer_id (Key) — Primary key — NOT NULL
  • offerStatus (제안 상태) — NOT NULL
  • company_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • worker_id (Key3) — Foreign key → MEMBER.member_id — NOT NULL
  • post_id (Key4) — Foreign key → JOB_POST.post_id — NOT NULL
  • Field

OFFER_WORK_DATE (제안 날짜)

  • offer_date_id (Key) — Primary key — NOT NULL
  • offer_id (Key2) — Foreign key → OFFER.offer_id — NOT NULL
  • work_day_id (Key3) — Foreign key → WORK_DATE.work_day_id — NOT NULL

PROJECT (프로젝트(카테고리))

  • project_id (Key) — Primary key — NOT NULL
  • name (프로젝트 명) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL

RESUME (Untitled2)

  • head_hunting_id (Key) — Primary key — NOT NULL
  • career (경력) — NOT NULL
  • available_info (가능 여부 정보) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL

SCRAP (스크랩)

  • Key — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • post_id (Key3) — Foreign key → JOB_POST.post_id — NOT NULL

Skill (Untitled3)

  • skill_id (Key) — Primary key — NOT NULL
  • tech (노동자 타입) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • head_hunting_id (Key2) — Foreign key → RESUME.head_hunting_id — NOT NULL

WAGE (지급 정보)

  • payment_id (Key) — Primary key — NOT NULL
  • wage_at (임금 지급일)
  • memo (간단한 메모)
  • daily_wage (일급)
  • created_at (생성일)
  • updated_at (수정일)
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL

WOKER(EMBEDDED) (노동자 계정 정보)

  • worker_name (노동자 이름)
  • rrn_prefix (생년월일(주민등록번호))
  • gender (성별)
  • nationality (국적)

WORK_DATE (일하는 날짜)

  • work_day_id (Key) — Primary key — NOT NULL
  • work_date (일하는 날짜) — NOT NULL
  • recruitNum (모집 인원) — NOT NULL
  • registeredNum (모집된 인원) — NOT NULL
  • post_id (Key2) — Foreign key → JOB_POST.post_id — NOT NULL