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) (직업)