ddd
Tables (9)
auth_phone
- phone_id — SERIAL — Primary key — NOT NULL
- user_id — SERIAL — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- token — VARCHAR(255) — NOT NULL
- is_auth — BOOLEAN — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE
concert_detail_images
- concert_images_id — SERIAL — Primary key — NOT NULL — 한 공연 내에서 이미지 순서가 중복되지 않도록 UNIQUE 제약 추가
- concert_id2 — SERIAL — NOT NULL — 공연이 삭제되면 이미지도 삭제
- image_url — VARCHAR(512) — NOT NULL — AWS S3에 저장될 예정
- image_order — INT — 같은 공연 내에서 이미지의 순서를 나타냄
- created_at — TIMESTAMP
- created_by — INT
- modified_at — TIMESTAMP
- modified_by — INT
- deleted_at — TIMESTAMP
- deleted_by — INT
concert_likes
- id — SERIAL — Primary key — NOT NULL — 한 사용자가 동일한 공연에 중복으로 좋아요를 누르지 못하도록 UNIQUE 제약 추가
- user_id — SERIAL — NOT NULL — 사용자가 삭제되면 좋아요도 삭제
- concert_id — SERIAL — NOT NULL — 공연이 삭제되면 좋아요도 삭제
- created_at — TIMESTAMP
concert_reviews
- concert_reviews_id — SERIAL — Primary key — NOT NULL
- user_id — SERIAL — NOT NULL
- concert_id — SERIAL — NOT NULL
- rating — INT — 공연에 대한 평점 (1~5)
- content — TEXT — NOT NULL
- like_count — INT — NOT NULL
- created_at — TIMESTAMP
- created_by — INT
- modified_at — TIMESTAMP
- modified_by — INT
- deleted_at — TIMESTAMP
- deleted_by — INT
- is_deleted — BOOLEAN
concerts
- concert_id — SERIAL — Primary key — NOT NULL
- concert_title — VARCHAR(255) — NOT NULL
- concert_date — DATE — NOT NULL
- concerts_time — TIME — NOT NULL
- poster_url — VARCHAR(512) — AWS S3에 저장될 예정
- location — VARCHAR(255) — NOT NULL
- duration — INT
- seat_type — VARCHAR(50)
- rating — VARCHAR(50)
- standing_price — INT
- seated_price — INT
- ticket_link — VARCHAR(512)
- view_count — INT
- like_count — INT
- concert_status — concert_status — NOT NULL — 공연 예정, 공연 진행중, 공연 종료, 공연 취소
- created_at — TIMESTAMP — NOT NULL
- created_by — INT — NOT NULL — 시스템/크롤러 ID
- modified_at — TIMESTAMP
- modified_by — INT — 시스템/크롤러 ID
- deleted_at — TIMESTAMP — (Soft Delete 구현)
- deleted_by — INT — 시스템/크롤러 ID (Soft Delete 구현)
- is_deleted — BOOLEAN — (Soft Delete 구현)
notifications
- notifrcation_id — SERIAL — Primary key — NOT NULL
- user_id — SERIAL — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN — 읽었으면 TRUE, 아니면 FALSE
- read_at — TIMESTAMP
- created_at — TIMESTAMP
- created_by — INT
- modified_at — TIMESTAMP
- modified_by — INT
- delete_at — TIMESTAMP
- delete_by — INT
payment_history
- payment_id — SERIAL — Primary key — NOT NULL
- user_id — SERIAL — NOT NULL
- concert_id — SERIAL — NOT NULL
- amount — INT — NOT NULL
- payment_method — ENUM('CreditCard', 'Paypal', 'BankTransfer')
- payment_status — ENUM('Success', 'Failed', 'Refunded') — NOT NULL
- created_at — TIMESTAMP
- modified_at — TIMESTAMP
tickets
- ticket_id — SERIAL — Primary key — NOT NULL
- user_id — SERIAL — NOT NULL
- concert_id — SERIAL — NOT NULL
- payment_id — SERIAL — NOT NULL
- seat_type — VARCHAR(50)
- seat_number — VARCHAR(50)
- purchase_price — INT
- purchase_timestamp — TIMESTAMP
- ticket_status — ENUM('Active', 'Cancelled', 'Used')
- qr_code_key — VARCHAR(255)
- qr_code_created_at — TIMESTAMP
users
- user_id — SERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- real_name — VARCHAR(255)
- nick_name — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(512) — AWS S3에 저장될 예정
- birth_date — DATE
- phone_number — VARCHAR(20) — NOT NULL
- gender — ENUM('M', 'F') — M: 남성, F: 여성
- authentication_type — ENUM('Kakao', 'Google', 'General') — 카카오, 구글, 일반
- account_status — ENUM('active', 'inactive', 'banned', 'deleted') — 계정 활성, 계정 비활성, 계정 정지, 계정 삭제
- role — ENUM('User', 'Admin') — User: 일반 사용자, Admin: 관리자
- last_login — TIMESTAMP — 2달 동안 로그인을 안하면 계정 비활성 상태로 변경
- last_password_modify — TIMESTAMP — 2달 동안 비밀번호 변경을 안하면 알림 발송
- created_at — TIMESTAMP — NOT NULL
- created_by — INT — NOT NULL
- modified_at — TIMESTAMP — NOT NULL
- modified_by — INT
- deleted_at — TIMESTAMP — (Soft Delete 구현)
- deleted_by — INT — (Soft Delete 구현)
- deleted_reason — VARCHAR(255) — (Soft Delete 구현)