Team#1[23F]

Tables (17)

Crew (크루)

  • id (ID) — INT — Primary key — NOT NULL
  • name (이름) — VARCHAR
  • description (설명) — VARCHAR
  • maximumMember (멤버 정원 수)
  • createdAt (생성일) — DATETIME

CrewMember (크루 멤버)

  • id (ID) — INT — Primary key — NOT NULL
  • crewId (Crew.id) — INT — Foreign key → Crew.id — NOT NULL
  • userId (User.id) — INT — Foreign key → User.id — NOT NULL
  • point (획득 점수) — INT
  • isCreator (방장 여부) — Bool
  • joinedAt (참여일) — DATETIME

CrewTag (Untitled)

  • Key — Primary key — NOT NULL
  • crewId (크루 ID) — INT — Foreign key → Crew.id — NOT NULL
  • tagId (태그 ID) — INT — Foreign key → Tag.id — NOT NULL

Goal (주기적인 목표)

  • id (ID) — INT — Primary key — NOT NULL
  • studyGroupId (StudyGroup.id) — INT — Foreign key → StudyGroup.id — NOT NULL
  • id (Key) — INT — Foreign key → StudyGroup.owner — NOT NULL
  • name (이름)
  • point (점수)

GoalFeed (목표 달성 피드)

  • id (ID) — INT — Primary key — NOT NULL
  • goalId (Goal.id) — INT — Foreign key → Goal.id — NOT NULL
  • studyGroupId (StudyGroup.id) — INT — Foreign key → StudyGroup.id — NOT NULL
  • userId (User.id) — INT — Foreign key → User.id — NOT NULL
  • title (제목)
  • content (내용)

GoogleAuth (구글 소셜로그인)

  • user_id (Key) — INT — Foreign key → User.id — NOT NULL

Member (스터디 그룹 멤버)

  • userId (User.id) — INT — Foreign key → User.id — NOT NULL
  • studyGroupId (StudyGroup.id) — INT — Foreign key → StudyGroup.id — NOT NULL
  • point (획득한 포인트)

Password (Deprecated 비밀번호)

  • userId (User.id) — INT — Foreign key → User.id — NOT NULL
  • password (비밀번호)

Password (비밀번호)

  • userId (사용자 PK) — INT — Foreign key → User.id — NOT NULL
  • password (비밀번호) — VARCHAR

Routine (루틴)

  • id (Key) — INT — Primary key — NOT NULL
  • crewId (Crew.id) — INT — Foreign key → Crew.id — NOT NULL
  • name (루틴 이름) — VARCHAR

RoutineProof (루틴 인증)

  • id (ID) — INT — Primary key — NOT NULL
  • crewMemberId (CrewMember.id) — INT — Foreign key → CrewMember.id — NOT NULL
  • routineId (Routine.id) — INT — Foreign key → Routine.id — NOT NULL
  • imgUrl (사진) — VARCHAR
  • description (설명) — VARCHAR
  • isBlocked (신고 여부) — Bool
  • createdAt (생성일) — DATETIME

Social Login (소셜 로그인)

  • userId (User.id) — INT — Foreign key → User.id — NOT NULL
  • type (타입)
  • Field

StudyGroup (스터디 그룹)

  • id (ID) — INT — Primary key — NOT NULL
  • owner (User.id) — INT — Foreign key → User.id — NOT NULL
  • name (이름)
  • maximumMember (멤버 정원 수)

StudyMemberApplication (스터디 그룹 멤버 신청)

  • userId (User.id) — INT — Foreign key → User.id — NOT NULL
  • studyGroupId (StudyGroup.id) — INT — Foreign key → StudyGroup.id — NOT NULL
  • status (수락 여부)

Tag (태그)

  • id (ID) — INT — Primary key — NOT NULL
  • name (태그명) — VARCHAR

User (사용자)

  • id (Key) — INT — Primary key — NOT NULL
  • email (이메일) — VARCHAR — NOT NULL
  • nickname (닉네임) — VARCHAR — NOT NULL
  • job (직업) — NOT NULL
  • login_method (로그인 방식) — NOT NULL

User (Deprecated 사용자)

  • id (Key) — INT — Primary key — NOT NULL
  • email (이메일) — VARCHAR
  • nickname (닉네임)
  • job(nullable) (직업)