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