LINKY-B
Tables (15)
SchoolCertification
- (schoolCertificationIdk) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- (schoolCertification) — TEXT — NOT NULL
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
Untitled (UserMbtiForFilter)
- (userMbtiIdx) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- Field2 (blockedMbti) — VARCHAR
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
Untitled (UserGradeForFilter)
- (userGradeIdx) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- (gradeStart) — Integer
- (gradeEnd) — Integer
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
Untitled (UserChattingRoom)
- (userChattingRoomIdx) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
Untitled (UserChattingRoomLikeManage)
- (userChattingRoomLikeManageIdx) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- (createdAt) — timestamp
- (updatedAt) — timestamp — NOT NULL
Untitled (UserChattingRoomReport)
- (userChattingRoomReportIdx) — Integer — Primary key — NOT NULL
- Key (userIdx) — Integer — Primary key — NOT NULL
- Field (userChattingRoomReportDetail) — VARCHAR(200) — NOT NULL
- (status) — Integer — 옵션 1,2,3,4,5,6
- (createdAt) — timestamp
- (updatedAt) — timestamp
User
- (userIdx) — Integer — Primary key — NOT NULL
- (userPhonenNum) — VARCHAR — NOT NULL
- (userNickName) — VARCHAR — NOT NULL
- (userName) — VARCHAR — NOT NULL
- (userBirth) — VARCHAR — NOT NULL
- (userPassword) — VARCHAR — NOT NULL
- (userSchoolName) — VARCHAR — NOT NULL
- (userMajorName) — VARCHAR — NOT NULL
- (userStudentNum) — VARCHAR — NOT NULL
- (gradStatus) — boolean — NOT NULL — 졸업생이 아니면 0, 졸업생이면 1
- (userGender) — Integer — NOT NULL — 남성이면 1, 여성이면 2
- (userMbti) — VARCHAR — NOT NULL
- (userPersonality) — VARCHAR — NOT NULL
- (userInterest) — VARCHAR — NOT NULL
- (userInfo) — TEXT — NOT NULL
- Field (userProfileImg) — TEXT — NOT NULL
- Field (userNotification) — VARCHAR — NOT NULL
- (statusForMyInfo) — VARCHAR — NOT NULL — ACTIVE=활성화, INACTIVE=비활성화
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
UserBlock
- (userBlockIdx) — Integer — Primary key — NOT NULL
- (userGiveBlock) — Integer — Foreign key → User.userIdx — NOT NULL
- (userGetBlocked) — Integer — Foreign key → User.userIdx — NOT NULL
- (status) — VARCHAR
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
UserFilter
- (userFilterIdx) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- Key (userMajorIdx) — Integer — Foreign key → UserMajor.Key — NOT NULL
- (userMbtiIdx) — Integer — Foreign key → Untitled.userMbtiIdx — NOT NULL
- (userGradeIdx) — Integer — Foreign key → Untitled.userGradeIdx — NOT NULL
- (userGender) — Integer — default=0,(모든성별) male=1, female=2
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
UserInterest
- (userInterestIdx) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- (Interest) — VARCHAR — NOT NULL
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
UserLike
- Key (userLikeIdx) — Integer — Primary key — NOT NULL
- (userGetLike) — Integer — Foreign key → User.userIdx — NOT NULL
- (userGiveLike) — Integer — Foreign key → User.userIdx — NOT NULL
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
UserMajor (UserMajorForFilter)
- Key (userMajorIdx) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- Field (blockedMajor) — VARCHAR
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
UserMatch
- (userMatchIdx) — Integer — Primary key — NOT NULL
- (userGetMatched) — Integer — Foreign key → User.userIdx — NOT NULL
- (userMatching) — Integer — Foreign key → User.userIdx — NOT NULL
- (userMatchStatus) — VARCHAR — NOT NULL
- (status) — boolean — NOT NULL — 0이면 매칭 수락, 1이면 매칭거절
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
UserPersonality
- (userPersonalityIdx) — Integer — Primary key — NOT NULL
- (userIdx) — Integer — Foreign key → User.userIdx — NOT NULL
- (personality) — VARCHAR — NOT NULL
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL
UserReport
- (userReportIdx) — Integer — Primary key — NOT NULL
- (userGetReported) — Integer — Foreign key → User.userIdx — NOT NULL
- (userReport) — Integer — Foreign key → User.userIdx — NOT NULL
- (userReportDetail) — VARCAHR(200) — NOT NULL
- (status) — Integer — NOT NULL — 순서대로 option 1,2,3,4,5,6
- (createdAt) — timestamp — NOT NULL
- (updatedAt) — timestamp — NOT NULL