AMP
Tables (12)
Bookmark (저장 공지)
- bookmark_id (저장 공지 ID) — bigint — Primary key — NOT NULL
- notice_id (공지사항 ID) — bigint — Foreign key → Notice.notice_id — NOT NULL
- festival_id (페스티벌 ID) — bigint — Foreign key → Notice.festival_id — NOT NULL
- organizer_id (주최사 ID) — bigint — Foreign key → Notice.organizer_id — NOT NULL
- user_id (사용자 ID) — bigint — Foreign key → Notice.user_id — NOT NULL
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
Category (카테고리)
- category_id (카테고리 ID) — bigint — Primary key — NOT NULL
- category_name (카테고리명) — varchar
- category_code (카테고리 코드) — varchar
- is_active (활성화 여부) — boolean
- deleted_at (삭제 일시) — timestamp
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
Congestion (혼잡도)
- congestion_id (혼잡도 ID) — bigint — Primary key — NOT NULL
- stage_id (무대 ID) — bigint — Foreign key → Stage.stage_id — NOT NULL
- festival_id (페스티벌 ID) — bigint — Foreign key → Stage.festival_id — NOT NULL
- organizer_id (주최사 ID) — bigint — Foreign key → Stage.organizer_id — NOT NULL
- user_id (사용자 ID2) — bigint — Foreign key → Stage.user_id — NOT NULL
- congestion_level (혼잡도) — enum
- measured_at (마지막 측정시간) — datetime
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
Festival (페스티벌)
- festival_id (페스티벌 ID) — bigint — Primary key — NOT NULL
- organizer_id (주최사 ID) — bigint — Foreign key → Organizer.organizer_id — NOT NULL
- user_id (사용자 ID2) — bigint — Foreign key → Organizer.user_id — NOT NULL
- title (제목) — varchar
- main_image_url (메인 이미지) — varchar
- location (개최 장소) — varchar
- start_date (시작일) — date
- end_date (종료일) — date
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
FestivalCategory (카테고리 매핑)
- festival_category_id (카테고리 매핑 ID) — bigint — Primary key — NOT NULL
- festival_id (페스티벌 ID) — bigint — Foreign key → Festival.festival_id — NOT NULL
- organizer_id (주최사 ID) — bigint — Foreign key → Festival.organizer_id — NOT NULL
- user_id (사용자 ID) — bigint — Foreign key → Festival.user_id — NOT NULL
- category_id (카테고리 ID) — bigint — Foreign key → Category.category_id — NOT NULL
- is_active (활성화 여부) — boolean
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestmap
- deleted_at (삭제 일시) — timestamp
FestivalSchedule (공연 스케줄)
- schedule_id (페스티벌 스케줄 ID) — bigint — Primary key — NOT NULL
- festival_id (페스티벌 ID) — bigint — Foreign key → Festival.festival_id — NOT NULL
- organizer_id (주최사 ID) — bigint — Foreign key → Festival.organizer_id — NOT NULL
- user_id (사용자 ID) — bigint — Foreign key → Festival.user_id — NOT NULL
- festival_date (공연 날짜) — date
- festival_time (공연 시간) — time
- deleted_at (삭제 일시) — timestamp
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
Notice (공지사항)
- notice_id (공지사항 ID) — bigint — Primary key — NOT NULL
- festival_id (페스티벌 ID) — bigint — Foreign key → Festival.festival_id — NOT NULL
- organizer_id (주최사 ID) — bigint — Foreign key → Festival.organizer_id — NOT NULL
- user_id (사용자 ID) — bigint — Foreign key → Festival.user_id — NOT NULL
- festival_category_id (연결된 카테고리 ID) — bigint
- title (제목) — varchar
- content (내용) — text
- image_url (이미지 url) — varchar
- is_pinned (상단고정) — boolean
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
- deleted_at (삭제 일시) — timestamp
Notification (알람)
- notification_id (알림 ID) — bigint — Primary key — NOT NULL
- category_id (카테고리 ID) — bigint — Foreign key → Category.category_id — NOT NULL
- title (알림 제목) — varchar
- message (알림 내용) — text
- is_read (읽음 여부) — timestamp
- created_at (생성 일시) — timestamp
Organizer (주최사)
- organizer_id (주최사 ID) — bigint — Primary key — NOT NULL
- user_id (사용자 ID) — bigint — Foreign key → User.user_id — NOT NULL
- festival_id (페스티벌 ID) — bigint
- organizer_name (주최사명) — varchar
- contact_email (연락처 이메일) — varchar
- contact_phone (연락처 전화번호) — varchar
- description (주최사 설명) — text
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
Stage (무대)
- stage_id (무대 ID) — bigint — Primary key — NOT NULL
- festival_id (페스티벌 ID) — bigint — Foreign key → Festival.festival_id — NOT NULL
- organizer_id (주최사 ID) — bigint — Foreign key → Festival.organizer_id — NOT NULL
- user_id (사용자 ID2) — bigint — Foreign key → Festival.user_id — NOT NULL
- title (무대 이름) — varchar
- location (위치) — varchar
- deleted_at (삭제 일시) — timestamp
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
User (유저)
- user_id (사용자 ID) — bigint — Primary key — NOT NULL
- email (이메일) — varchar
- nickname (사용자 닉네임) — varchar
- profile_image_url (프로필 이미지) — varchar
- provider (로그인 제공자) — enum
- provider_id (제공자 ID) — varchar
- user_type (사용자 유형) — enum
- last_login_at (최근 아이디) — timestamp
- is_active (활성화 여부) — boolean
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp
WishList (관람 예정 공연)
- wishList_id (관람 예정 공연 ID) — bigint — Primary key — NOT NULL
- festival_id (페스티벌 ID) — bigint — Foreign key → Festival.festival_id — NOT NULL
- organizer_id (주최사 ID) — bigint — Foreign key → Festival.organizer_id — NOT NULL
- user_id (사용자 ID) — bigint — Foreign key → Festival.user_id — NOT NULL
- isWishList (관람 희망) — boolean
- created_at (생성 일시) — timestamp
- updated_at (수정 일시) — timestamp