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