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