딩가딩
테이블 (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 — 쿼리로 처리하는게 나을지, 저장해두는게 나을지?