RecruitFirst

Tables (7)

DisLike (CopyOfUntitled4)

  • 싫어요Id (likeId) — Primary key — NOT NULL
  • 회원고유ID (userId) — Foreign key → General_Member.회원고유ID — NOT NULL
  • 알바고유Id (recruitId) — Foreign key → Recruit.알바고유Id — NOT NULL

General_Member (Untitled)

  • 회원고유ID (userId) — Primary key — NOT NULL
  • 비밀번호 (password)
  • 이름 (name)
  • 지역 (location)
  • 나이 (age)
  • Field

Inquiry (Untitled3)

  • 문의사항고유Id (InquiryId) — Primary key — NOT NULL
  • 문의제목 (title)
  • 문의내용 (content)
  • 회원고유ID (userId) — Foreign key → General_Member.회원고유ID — NOT NULL

Like (Untitled4)

  • 좋아요Id (likeId) — Primary key — NOT NULL
  • 회원고유ID (userId) — Foreign key → General_Member.회원고유ID — NOT NULL
  • 알바고유Id (recruitId) — Foreign key → Recruit.알바고유Id — NOT NULL

Owner_Member (CopyOfUntitled)

  • 회원고유ID (userId) — Primary key — NOT NULL
  • 비밀번호 (password)
  • 이름 (name)
  • 사업자번호 (ownerNum)

Recruit (Untitled2)

  • 알바고유Id (recruitId) — Primary key — NOT NULL
  • 공고제목 (title)
  • 근로시작날짜 (startDate)
  • 근로종료날짜 (endDate)
  • 공고내용 (content)
  • 우대조건 (favor)
  • 회원고유ID (userId) — Foreign key → Owner_Member.회원고유ID — NOT NULL

comment (Untitled5)

  • 댓글Id (comId) — Primary key — NOT NULL
  • 회원고유ID (userId) — Foreign key → General_Member.회원고유ID — NOT NULL
  • 문의사항고유Id (InquiryId) — Foreign key → Inquiry.문의사항고유Id — NOT NULL
  • 댓글내용 (comment)