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