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 구현)