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)