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