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