Allreva

Tables (20)

Chat (chat)

  • Key — Primary key — NOT NULL

Concert (콘서트)

  • id (Key) — Primary key — NOT NULL
  • title (공연명) — String — NOT NULL
  • stdate (공연시작일) — Date — NOT NULL
  • eddate (공연종료일) — Date — NOT NULL
  • poster (포스터) — String
  • price (티켓가격) — price
  • prfstate (공연상태(완료,예정..)) — ENUM
  • relate_name (판매처명) — String
  • relate_url (판매처url) — String
  • hallCode (콘서트홀 code) — String — NOT NULL
  • concertCode (콘서트 code) — String — NOT NULL
  • timeTable (회차정보) — String — NOT NULL
  • viewCount (조회수) — BigInt — NOT NULL

ConcertDiary (공연기록)

  • id (Key) — Primary key — NOT NULL
  • memberId (Key2) — Long — Foreign key → member.id — NOT NULL
  • concertId (Key3) — Foreign key → Concert.id — NOT NULL
  • date (날짜) — Date — NOT NULL
  • episode (회차) — String — NOT NULL
  • content (Field)
  • seatName (Field2)
  • concertPoster (Field3)

ConcertEpisode (Untitled5)

  • id (Key) — Foreign key → Concert.id — NOT NULL
  • episode (회차정보) — String

ConcertHall (홀)

  • id (콘서트홀 code) — String — Primary key — NOT NULL
  • name (인스파이어 + 아레나) — String — NOT NULL
  • seat_scale (좌석수) — int — NOT NULL
  • longitude (경도) — Double — NOT NULL
  • latitude (위도) — Double — NOT NULL
  • address (주소(정확한)) — String — NOT NULL
  • parking (주차시설여부) — Boolean
  • restaurant (식당여부) — Boolean
  • cafe (카페여부) — Boolean
  • store (편의점여부) — Boolean
  • park_barrier (장애인주차장여부) — Boolean
  • rest_barrier (장애인화장실여부) — Boolean
  • elev_barrier (엘레베이터여부) — Boolean
  • runw_barrier (경사로여부) — Boolean
  • star (리뷰평균별점) — double

ConcertImages (Untitled)

  • id (Key) — Foreign key → Concert.id — NOT NULL
  • url (이미지 url) — String

DiaryImages (Untitled3)

  • Key — Foreign key → ConcertDiary.id — NOT NULL
  • Field (이미지 url) — String — NOT NULL

Notification (알람)

  • id (Key) — Long — Primary key — NOT NULL
  • notification_type — ENUM — NOT NULL
  • title (제목) — String — NOT NULL
  • content (내용) — String — NOT NULL
  • target_id (관련글 id) — Long — 관련 수요조사, 차대절, 공연 ..
  • Field

RentForm (대절폼)

  • Key — Primary key — NOT NULL
  • id (member_id) — Long — Foreign key → member.id — NOT NULL
  • id (concert_id) — Long — Foreign key → Concert.id — NOT NULL
  • title (글제목) — String — NOT NULL
  • image (메인이미지) — String — NOT NULL
  • artist_name (아티스트명) — String — NOT NULL
  • region (지역코드) — ENUM — NOT NULL
  • boarding_area (탑승장소) — String — NOT NULL
  • bus_size (버스 크기) — Enum — NOT NULL — 버스
  • bus_type (버스 종류) — Enum — NOT NULL — 버스
  • max_ passenger (버스 인원) — Integer — NOT NULL — 버스
  • deposit_account (입금계좌) — String — NOT NULL — 로그인 후 확인할 수 있습니다.
  • up_time (상행 시각) — String — NOT NULL
  • down_time (하행 시각) — String — NOT NULL
  • round_price (왕복 이용 요금) — Integer — NOT NULL — 이용요금
  • up_time_price (상행 이용 요금) — Integer — NOT NULL — 이용요금
  • down_time_price (하행 이용 요금) — Integer — NOT NULL — 이용요금
  • recruitment_count (모집인원) — Integer — NOT NULL
  • chat_url (채팅방링크) — String — NOT NULL
  • refund_type (환불정책) — Enum — NOT NULL — 추가입금, 환불, 둘다
  • information (기타 안내 사항) — String
  • eddate (모집 마감 날짜) — Date — NOT NULL
  • isClosed (마감 여부) — boolean — NOT NULL

Rentjoin (신청자 폼)

  • id (Key3) — Primary key — NOT NULL
  • id (member_id) — Long — Foreign key → member.id — NOT NULL
  • Key (rent_form_id) — Long — Foreign key → RentForm.Key — NOT NULL
  • depositor_name (입금자명) — String — NOT NULL — Depositor
  • depositor_time (입금 시각) — String — NOT NULL — Depositor
  • phone (전화번호) — String — NOT NULL — Depositor
  • passenger_num (탑승인원) — Integer — NOT NULL — 본인포함
  • boarding_type (이용편도) — ENUM — NOT NULL — 왕복, 상행 ,하행
  • refund_type (환불정보) — ENUM — NOT NULL — 추가 입급, 환불
  • refund_account (환불계좌) — String — NOT NULL
  • boadring_date (이용 날짜) — Date — NOT NULL

Survey (수요조사)

  • id (Key) — Primary key — NOT NULL
  • id (member id) — Long — Foreign key → member.id — NOT NULL
  • id (concert_id) — Long — Foreign key → Concert.id — NOT NULL
  • title (제목) — String — NOT NULL
  • artist_name (아티스트명) — Strign — NOT NULL
  • region (탑승지역) — Enum — NOT NULL
  • eddate (마감날짜) — Date — NOT NULL
  • max_passenger (참여인원수) — Integer — NOT NULL
  • information (기타안내사항) — String
  • isClosed (마감여부) — boolean — NOT NULL

SurveyBoardingDate (수요조사가용날짜)

  • id — Primary key — NOT NULL
  • survey_id — Foreign key → Survey.id — NOT NULL
  • date (LocalDate) — NOT NULL

SurveyJoin (수요조사응답)

  • id (Key) — Primary key — NOT NULL
  • id (survey_id) — Long — Foreign key → Survey.id — NOT NULL
  • id (member_id) — Long — Foreign key → member.id — NOT NULL
  • boarding_date (이용날짜) — Date — NOT NULL
  • boarding_type (이용편도) — Enum — NOT NULL
  • passenger_num (탑승인원) — int — NOT NULL
  • notified (알림받기) — boolean — NOT NULL

artist (Untitled4)

  • id (스포티파이 아티스트 키) — String — Primary key — NOT NULL
  • name (아티스트 명) — String — NOT NULL

member (회원)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Email) — String — NOT NULL
  • role (권한) — ENUM — NOT NULL
  • provider (소셜로그인타입) — ENUM — NOT NULL
  • nickname (닉네임) — String — NOT NULL
  • introduce (한줄소개) — String — 공백포함 40자 제한
  • profile_image_url (프로필이미지) — String — NOT NULL
  • refund_account (환불계좌) — String

memberArtist (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • id (member_id) — Long — Foreign key → member.id — NOT NULL
  • id (스포티파이 아티스트 키) — String — Foreign key → artist.id — NOT NULL

rentBoardingDate (차대절가용날짜)

  • id — Long — Primary key — NOT NULL
  • rent_id — Foreign key → RentForm.Key — NOT NULL
  • date (날짜) — NOT NULL

seatReview (좌석리뷰)

  • id (Key) — Long — Primary key — NOT NULL
  • member_id (member Id) — Long — Foreign key → member.id — NOT NULL
  • hall_id (concerthall id) — Long — Foreign key → ConcertHall.id — NOT NULL
  • seat (좌석 상세 층수/구역/열) — String — NOT NULL
  • content (내용) — String
  • star (별점) — Int — NOT NULL

seatReviewImage (좌석리뷰이미지)

  • id (Key) — Long — Primary key — NOT NULL
  • review_id (seatReview id) — Long — Foreign key → seatReview.id — NOT NULL
  • url (이미지 url) — String — NOT NULL

seatReviewLike (이 리뷰 좋아요)

  • id (Key) — Primary key — NOT NULL
  • member_id (member id) — Long — Foreign key → member.id — NOT NULL
  • review_id (review id) — Long — Foreign key → seatReview.id — NOT NULL