딩가딩

테이블 (31)

Band

  • band_id — bigint
  • name — varchar(255) — NOT NULL
  • band_master_id — uuid — NOT NULL
  • description — text
  • genre_id — bigint — NOT NULL
  • sigun — varchar(255) — NOT NULL
  • tags — varchar(255)
  • contact_id — bigint
  • profile_url — text
  • max_size — integer
  • job_opening — boolean — NOT NULL — 구인 중 여부

BandGenre

  • band_genre_id — bigint
  • band_id — bigint — 외래 키 → Band.band_id — NOT NULL
  • genre — ENUM — ROCK, JAZZ

BandMember

  • band_member_id — uuid
  • band_id — bigint — 외래 키 → Band.band_id — NOT NULL
  • member_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • instrument — ENUM — KEYBOARD, GUITAR

BandRecruitment

  • band_recruitment_id — bigint — NOT NULL
  • band_id — integer — 외래 키 → Band.band_id — NOT NULL
  • title — varchar(255) — NOT NULL
  • description — varchar(255)
  • audition_date — datetime — NOT NULL
  • audition_song — Song — NOT NULL

BandRecruitmentApplicant

  • band_recruitment_applicant_id — bigint — NOT NULL
  • band_recruitment_instruments_id — bigint — 외래 키 → BandRecruitmentInstrument.band_recruitment_instruments_id — NOT NULL — 어떤 악기 포지션 지원자인지
  • applicant_id — uuid — NOT NULL

BandRecruitmentInstrument

  • band_recruitment_instruments_id — bigint — NOT NULL
  • band_recruitment_id — bigint — 외래 키 → BandRecruitment.band_recruitment_id — NOT NULL
  • instrument — ENUM — NOT NULL
  • required_tier — ENUM — NOT NULL
  • max_size — integer — NOT NULL — 인원 모집 수

BandRecruitmentSong

  • band_recruitment_song_id — bigint — NOT NULL
  • band_recruitment_id — bigint — 외래 키 → BandRecruitment.band_recruitment_id
  • song_id — bigint — 외래 키 → Song.song_id

Challenge

  • challenge_id — bigint — NOT NULL
  • member_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • challengeType — ENUM — NOT NULL — FIRST, PRACTICE, CHALLENGE, DEFENSE
  • instrument — ENUM — NOT NULL — VOCAL, GUITAR, DRUM, BASS
  • tier — ENUM — NOT NULL — UNRANKED, IRON, BRONZE, SILVER, GOLD, PLATINUM, DIAMOND
  • created_at — date — NOT NULL
  • expire_date — date — 도전 만료일 (7일 또는 30일)
  • status — ENUM — NOT NULL — IN_PROGRESS, COMPLETED, EXPIRED

ChallengeAttempt

  • attempt_id — bigint — NOT NULL
  • challenge_id — bigint — 외래 키 → Challenge.challenge_id — NOT NULL
  • song_by_instrument_id — bigint — 외래 키 → SongsByInstrument.song_by_instrument — NOT NULL
  • score — int — 도전 시도 점수
  • attempt_date — date — NOT NULL
  • status — ENUM — NOT NULL — SUCCESS, FAIL

ChallengeSession

  • session_id — bigint — NOT NULL
  • challenge_id — bigint — 외래 키 → Challenge.challenge_id — NOT NULL
  • song_pack_id — bigint — 외래 키 → SongPack.song_pack_id — NOT NULL
  • started_at — date — NOT NULL
  • status — ENUM — NOT NULL — IN_PROGRESS, COMPLETED, EXPIRED

ChatMessage

  • chat_message_id — bigint — NOT NULL
  • chat_room_id — bigint — 외래 키 → ChatRoom.chatroom_id — NOT NULL — 어느 방 메세지 로그인지
  • member_id — uuid — NOT NULL
  • message — text — NOT NULL
  • writed_at — datetime — NOT NULL

ChatRoom

  • chatroom_id — bigint — NOT NULL
  • title — varchar(255) — NOT NULL
  • latest_chat — text — 마지막 메세지, 새로 생성한 방은 없을 수 있으니까 null
  • latest_chat_date — date — 마지막 채팅 날짜, 새로 생성한 방은 없을 수 있으니까 null
  • chat_profile_url — varchar(255) — NOT NULL — 기본 이미지 넣어주기
  • room_type — varchar(255) — NOT NULL — 밴드 채팅, 개인 채팅

ChatRoomParticipant

  • chat_room_participant_id — bigint — NOT NULL
  • chatroom_id — bigint — 외래 키 → ChatRoom.chatroom_id — NOT NULL — 어느 방 참가자인지
  • member_id — uuid — NOT NULL — 참가자
  • role — varchar(255) — NOT NULL — 방장, 참가자, 있어야 할까?

ChatRoomSetting

  • chat_room_setting_id — bigint — NOT NULL
  • chat_room_id — bigint — 외래 키 → ChatRoom.chatroom_id — NOT NULL
  • member_id — uuid — NOT NULL
  • alert — boolean — NOT NULL — 해당 방 알림 여부
  • unread_chat_count — int — NOT NULL — 안 읽은 메세지 개수

Contact

  • contact_id — bigint
  • band_id — bigint — 외래 키 → Band.band_id — NOT NULL
  • sns — ENUM — NOT NULL
  • title — varchar(255) — CUSTOM한 경우에만 작성
  • URL — varchar(255) — NOT NULL

FavoriteBand

  • favorite_band_id — bigint — NOT NULL
  • member_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • band_id — bigint — 외래 키 → Band.band_id — NOT NULL

InstrumentSkill

  • instrument_skill_id — bigint — NOT NULL
  • member_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • instrumentType — ENUM — NOT NULL
  • beat — int — 박자
  • tune — int — 음정
  • tone — int — 음색

LiveHouse

  • live_house_id — bigint
  • master_id — uuid — 외래 키 → Member.member_id — NOT NULL — 방장
  • vice_id — uuid — 부방장
  • title — varchar(255) — NOT NULL
  • description — text
  • tags — varchar(255)
  • is_public — boolean — NOT NULL
  • password — varchar(255)
  • invite_url — varchar(255)
  • pinned_message — text
  • max_size — integer — NOT NULL

LiveHouseParticipant

  • live_house_participant_id — bigint — NOT NULL
  • live_house_id — bigint — 외래 키 → LiveHouse.live_house_id — NOT NULL
  • participant_id — uuid — NOT NULL

Member

  • member_id — uuid
  • username — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • age — int
  • gender — varchar(255) — MALE, FEMALE, OTHER
  • favorite_band_id — bigint
  • profile_img_url — varchar(255) — NOT NULL
  • created_at — date — NOT NULL — 이 날짜로부터 7일 이내에 배치고사 완료하지 않으면 아이언
  • email — varchar(255) — 03/20 추가

MemberInstrumentTier

  • member_instrument_tier_id — bigint
  • member_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • instrument — ENUM — KEYBOARD, GUITAR
  • tier — ENUM — 배치고사 치기 전엔 언랭
  • last_challenged — date — 해당 악기의 티어를 이 날로부터 30일? 유지
  • challenge_count — int — NOT NULL — 챌린지 최대 횟수
  • success_count — int — NOT NULL — 해당 티어에 챌린지에 대한 성공 카운트
  • first_challenge — boolean — 해당 악기, 해당 티어에 대한 배치고사 진행 여부

Notification

  • notification_id — bigint — NOT NULL
  • receiver_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • message — varchar(255) — NOT NULL
  • read_or_not — boolean — NOT NULL
  • type — ENUM — NOT NULL — 알림 타입
  • created_at — timestamp — NOT NULL

PracticeRecord

  • practice_record_id — bigint — NOT NULL
  • member_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • song_by_instrument_id — bigint — 외래 키 → SongsByInstrument.song_by_instrument — NOT NULL
  • instrument — ENUM — NOT NULL — VOCAL, GUITAR, DRUM, BASS
  • score — int — 연습 점수
  • recorded_at — date — NOT NULL
  • record_url — varchar(255) — NOT NULL — 녹음 파일 URL

Record

  • record_id — bigint — NOT NULL
  • member_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • challenge_id — bigint
  • dtype — ENUM — NOT NULL — CHALLENGE, LIVE_HOUSE 등 어떤 항목에 대한 녹음인지
  • title — varchar(255) — NOT NULL — #월 #일 {악기} 도전 기록
  • record_url — varchar(255) — NOT NULL — 내 노래 음성파일 저장된 서버 url

Schedule

  • schedule_id — bigint
  • band_id — bigint — 외래 키 → Band.band_id — NOT NULL
  • title — varchar(255) — NOT NULL
  • time — date — NOT NULL
  • location — varchar(255)
  • description — varchar(255)
  • sticker — varchar(255)

Song

  • song_id — bigint — NOT NULL
  • title — varchar(255) — NOT NULL
  • youtube_url — varchar(255) — NOT NULL
  • tier — ENUM — NOT NULL

SongPack

  • song_pack_id — bigint — NOT NULL
  • pack_name — varchar(255) — NOT NULL
  • tier — ENUM — NOT NULL — IRON, BRONZE, SILVER, GOLD, PLATINUM, DIAMOND
  • instrument — ENUM — NOT NULL — VOCAL, GUITAR, DRUM, BASS

SongPackDetail

  • song_pack_detail_id — bigint — NOT NULL
  • song_pack_id — bigint — 외래 키 → SongPack.song_pack_id — NOT NULL
  • song_by_instrument_id — bigint — 외래 키 → SongsByInstrument.song_by_instrument — NOT NULL

SongsByInstrument

  • song_by_instrument — bigint — NOT NULL
  • song_id — bigint — 외래 키 → Song.song_id — NOT NULL — 이 한 곡에 대한 여러 악기별 음원
  • instrument — ENUM — NOT NULL

TierLog

  • tier_log_id — bigint — NOT NULL
  • member_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • tier — ENUM — NOT NULL
  • changed_date — date — NOT NULL
  • instrument — ENUM — NOT NULL

follow

  • follow_id — bigint — NOT NULL
  • following_user_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • followed_user_id — uuid — 외래 키 → Member.member_id — NOT NULL
  • followed_eachother — boolean — NOT NULL — 쿼리로 처리하는게 나을지, 저장해두는게 나을지?