ticket-mate

Tables (14)

Application (신청서)

  • application_id (PK) — UUID — Primary key — NOT NULL
  • user_id (PK2) — UUID — Foreign key → User.user_id — NOT NULL
  • ticket_id (PK3) — UUID — Foreign key → Ticket.ticket_id — NOT NULL
  • ticket_count (매수) — int
  • date (공연 날짜) — LocalDateTime
  • status (상태) — enum
  • reward (보상) — int

ApplicationArea (신청구역)

  • application_area_id (PK) — UUID — Primary key — NOT NULL
  • application_id (PK2) — UUID — Foreign key → Application.application_id — NOT NULL
  • area (희망위치) — String
  • price (희망가격) — int

BaseEntity (Auditing)

  • created_date (생성일) — LocalDateTime
  • modified_date (수정일) — LocalDateTime
  • is_edited (수정여부) — Boolean
  • is_deleted (삭제여부) — Boolean

ChatRoom (채팅방)

  • chat_room_id (PK) — UUID — Primary key — NOT NULL
  • application_id (PK2) — UUID — Foreign key → Application.application_id — NOT NULL
  • ticket_id (PK3) — UUID — Foreign key → Ticket.ticket_id — NOT NULL
  • name (채팅방 이름) — String

Comment (댓글)

  • comment_id (PK) — UUID — Primary key — NOT NULL
  • user_id (PK2) — UUID — Foreign key → User.user_id — NOT NULL
  • concert_request_id (PK4) — UUID — Foreign key → ConcertRequest.concert_request_id — NOT NULL
  • hall_id (PK3) — UUID — Foreign key → Hall.hall_id — NOT NULL
  • content (본문) — String
  • content_type (타입) — enum

ConcertRequest (콘서트요청)

  • concert_request_id (PK) — UUID — Primary key — NOT NULL
  • user_id (PK2) — UUID — Foreign key → User.user_id — NOT NULL
  • title (제목) — String
  • content (본문) — String
  • like_count (추천) — int
  • dislike_count (비추) — int

Hall (공연장)

  • hall_id (PK) — UUID — Primary key — NOT NULL
  • name (공연장 이름) — String
  • location_do (공연장 도) — enum
  • location_si (공연장 시) — enum
  • address (주소) — String
  • seating_chart_url (좌석배치도) — String
  • seat_count (총 좌석 수) — int
  • phone (연락처) — String
  • web_site_url (웹사이트 URL) — String
  • query_score (검색점수) — Long

LikeHistory (좋아요 내역)

  • like_history_id (PK) — UUID — Primary key — NOT NULL
  • user_id (PK2) — UUID — Foreign key → User.user_id — NOT NULL
  • concert_request_id (PK3) — UUID — Foreign key → ConcertRequest.concert_request_id — NOT NULL
  • like_type (좋아요/싫어요) — enum

Message (메시지)

  • message_id (PK) — UUID — Primary key — NOT NULL
  • user_id (PK3) — UUID — Foreign key → User.user_id — NOT NULL
  • content (메시지 내용) — String

Notification (알림)

  • notification_id (PK) — UUID — Primary key — NOT NULL
  • user_id (PK2) — UUID — Foreign key → User.user_id — NOT NULL
  • is_read (읽음처리) — boolean

Score (점수)

  • score_id (PK) — UUID — Primary key — NOT NULL
  • user_id (PK2) — UUID — Foreign key → User.user_id — NOT NULL
  • score (점수) — Long
  • rate (평점) — double
  • success_count (성공 횟수) — int
  • fail_count (실패 횟수) — int

Ticket (티켓정보)

  • ticket_id (PK) — UUID — Primary key — NOT NULL
  • hall_id (PK2) — UUID — Foreign key → Hall.hall_id — NOT NULL
  • title (공연 제목) — String
  • artist (아티스트) — String
  • thumb_nail_url (썸네일) — String
  • date (티켓 오픈일) — LocalDateTime
  • status (상태) — enum (예정, 진행중, 종료)
  • seller_count (대리자 수) — int

User (회원)

  • user_id (PK) — UUID — Primary key — NOT NULL
  • username (아이디) — String
  • password (비밀번호) — String
  • email (이메일) — String
  • nickname (닉네임) — String
  • phone_number (전화번호) — String
  • birth (생년월일) — LocalDateTime
  • role (권한) — enum
  • status (구매자/판매자) — enum

UserChatRoom (매개테이블)

  • user_chat_room_id (PK) — UUID — Primary key — NOT NULL
  • chat_room_id (PK2) — UUID — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • message_id (PK3) — UUID — Foreign key → Message.message_id — NOT NULL