boom

Tables (12)

Board (게시글)

  • board_id (primeKey) — Long — Primary key — NOT NULL
  • member_id (FK) — Long — Foreign key → Member.member_id — NOT NULL — By Host
  • title (제목) — String — NOT NULL
  • content (내용) — String

Media (이미지)

  • media_id (primeKey) — Long — Primary key — NOT NULL
  • board_id (FK) — Long — Foreign key → Board.board_id — NOT NULL
  • imgUrl (이미지 링크) — String — NOT NULL

Member (회원)

  • member_id (primeKey) — Long — Primary key — NOT NULL
  • email (카카오계정) — String — NOT NULL
  • username (토큰 용 회원명) — String — NOT NULL
  • role (서버 설정 역할) — String
  • profile_img (프로필 이미지) — String
  • name (성명) — String
  • nickname (서비스 사용 이름) — String — NOT NULL

Music (노래링크)

  • song_id (PK) — Long — Primary key — NOT NULL
  • artist (가수) — String
  • title (제목) — String

Notification (알림)

  • notification_id (primeKey) — Long — Primary key — NOT NULL
  • reciever_id (primeKey2) — Long — Foreign key → Member.member_id — NOT NULL
  • type (알림 종류) — String
  • target_id (알림 생성 주체 아이디) — Long — NOT NULL

Promotion (홍보용(extends Board))

  • null (상속을 위한 허위 키) — Primary key
  • board_id (FK) — Long — Foreign key → Board.board_id — NOT NULL
  • maximum_audience (최대 관객 수)
  • team (소속 팀) — String — NOT NULL

Ticket (티켓)

  • ticket_id (PK) — Long — Primary key — NOT NULL
  • data (qr인식값) — Long — NOT NULL
  • dueDate (만료기간) — LocalDate — NOT NULL
  • null (상속을 위한 허위 키) — Foreign key → Promotion.null

board_like (게시글 좋아요)

  • like_id (unique)
  • member_id (primeKey) — Long — Foreign key → Member.member_id — NOT NULL
  • board_id (primeKey2) — Long — Foreign key → Board.board_id — NOT NULL

guest (게스트 명단)

  • guest_id (PK) — Long — Primary key — NOT NULL
  • isEntered (입장여부) — NOT NULL
  • member_id (FK) — Long — Foreign key → Member.member_id — NOT NULL
  • promotion_id (FK2) — Foreign key → Promotion.null

manager (관리자)

  • manager_id (PK) — Long — Primary key — NOT NULL
  • member_id (FK1) — Long — Foreign key → Member.member_id — NOT NULL
  • null (상속을 위한 허위 키) — Foreign key → Promotion.null

music_like (setlist좋아요)

  • like_id (unique)
  • member_id (primeKey) — Long — Foreign key → Member.member_id — NOT NULL
  • promotion_music_id (PK) — Long — Foreign key → promotion_music.promotion_music_id — NOT NULL

promotion_music (Untitled)

  • promotion_music_id (PK) — Long — Primary key — NOT NULL
  • isOpen (공개/비공개) — boolean — NOT NULL
  • song_id (PK2) — Long — Foreign key → Music.song_id — NOT NULL
  • null (상속을 위한 허위 키) — Foreign key → Promotion.null