Wef
Tables (11)
Admin (Untitled7)
- Key — Primary key — NOT NULL
- 맴버 ID (member_id) — BIGINT — Foreign key → Member.맴버 ID — NOT NULL
- 그룹 ID (party_id) — BIGINT — Foreign key → Party.그룹 ID — NOT NULL
Album (Untitled6)
- 앨범 ID (id) — BIGINT — Primary key — NOT NULL
- 그룹 ID (party_id) — BIGINT — Foreign key → Party.그룹 ID — NOT NULL
- 맴버 ID (member_id) — BIGINT — Foreign key → Member.맴버 ID — NOT NULL
- 내용 (content) — VARCHAR(255)
- 장소 (place) — VARCHAR(255)
- 사진 (imageUrl) — VARCHAR(255)
- 생성시간 (created_at) — DATETIME
ChatRoom (Untitled8)
- 채팅방 ID (id) — BIGINT — Primary key — NOT NULL
- 그룹 ID (party_id) — BIGINT — Foreign key → Party.그룹 ID — NOT NULL
- 이름 (chatRoomName) — VARCHAR(255)
Comment (Untitled10)
- 댓글 ID (id) — BIGINT — Primary key — NOT NULL
- 맴버 ID (member_id) — BIGINT — Foreign key → Member.맴버 ID — NOT NULL
- 앨범 ID (album_id) — BIGINT — Foreign key → Album.앨범 ID — NOT NULL
- 내용 (content) — VARCHAR(255)
- 생성시간 (created_at) — DATETIME
Member (Untitled)
- 맴버 ID (id) — BIGINT — Primary key — NOT NULL
- 카카오 ID (kakaoId) — BIGINT
- 구글 ID (googleId) — BIGINT
- 이메일 (email) — VARCHAR(255)
- 이름 (name) — VARCHAR(255)
- 비밀번호 (password) — VARCHAR(255)
- 프로필사진 (imageUrl) — VARCHAR(255)
- 생성시간 (created_at) — DATETIME
MemberParty (Untitled5)
- Key — Primary key — NOT NULL
- 그룹 ID (party_id) — BIGINT — Foreign key → Party.그룹 ID — NOT NULL
- 맴버 ID (member_id) — BIGINT — Foreign key → Member.맴버 ID — NOT NULL
Message (Untitled11)
- 채팅 ID (id) — BIGINT — Primary key — NOT NULL
- 맴버 ID (member_id) — BIGINT — Foreign key → Member.맴버 ID — NOT NULL
- 채팅방 ID (chatRoom_id) — BIGINT — Foreign key → ChatRoom.채팅방 ID — NOT NULL
- 내용 (content) — VARCHAR(255)
- 생성시간 (created_at) — DATETIME
Notification (Untitled3)
- 알림 ID (id) — BIGINT — Primary key — NOT NULL
- 맴버 ID (member_id) — BIGINT — Foreign key → Member.맴버 ID — NOT NULL
- 프로필사진 (profileUrl) — VARCHAR(255)
- 알람종류 (alarmType) — VARCHAR(255)
- 알람내용 (message) — VARCHAR(255)
- 댓글내용 (content) — VARCHAR(255)
- 그룹이름 (partyName) — VARCHAR(255)
- 일정제목 (title) — VARCHAR(255)
- URL (url) — VARCHAR(255)
- 작성자 (writer) — VARCHAR(255)
- 읽음 (isRead) — BOOLEAN
- 생성시간 (created_at) — DATETIME
Participant (Untitled9)
- Key — Primary key — NOT NULL
- 맴버 ID (member_id) — BIGINT — Foreign key → Member.맴버 ID — NOT NULL
- 일정 ID (schedule_id) — BIGINT — Foreign key → Schedule.일정 ID — NOT NULL
Party (Untitled2)
- 그룹 ID (id) — BIGINT — Primary key — NOT NULL
- 그룹 이름 (name) — VARCHAR(255)
- 그룹 소개글 (introduction) — VARCHAR(255)
- 그룹 초대코드 (code) — VARCHAR(255)
Schedule (Untitled4)
- 일정 ID (id) — BIGINT — Primary key — NOT NULL
- 맴버 ID (member_id) — BIGINT — Foreign key → Member.맴버 ID — NOT NULL
- 그룹 ID (party_id) — BIGINT — Foreign key → Party.그룹 ID — NOT NULL
- 제목 (title) — VARCHAR(255)
- 내용 (content) — VARCHAR(255)
- 약속장소 (place) — VARCHAR(255)
- 약속시간 (time) — VARCHAR(255)
- 생성시간 (created_at) — DATETIME