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