ㅇㅇ

Tables (17)

admin_logs

  • admin_log_id — BIGINT — Primary key — NOT NULL
  • admin_id — BIGINT — NOT NULL
  • action_type — VARCHAR(50)
  • target_entity — VARCHAR(50)
  • target_id — BIGINT
  • details — TEXT
  • created_at — DATETIME — NOT NULL

band_genre

  • band_id — BIGINT — Primary key — NOT NULL
  • genre_id — BIGINT — Primary key — NOT NULL

bands

  • band_id — BIGINT — Primary key — NOT NULL
  • band_name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • contact — VARCHAR(50)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

genres

  • genre_id — BIGINT — Primary key — NOT NULL
  • genre_name — VARCHAR(50) — NOT NULL

match_comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • match_post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • parent_comment_id — BIGINT
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

match_posts

  • match_post_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • performance_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

matches

  • match_id — BIGINT — Primary key — NOT NULL
  • match_post_id — BIGINT — NOT NULL
  • applicant_id — BIGINT — NOT NULL
  • status — ENUM('PENDING', 'CONFIRMED', 'REJECTED', 'CANCELLED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payments

  • payment_id — BIGINT — Primary key — NOT NULL
  • performance_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • method — ENUM('CARD', 'BANK', 'CASH') — NOT NULL
  • status — ENUM('PENDING', 'COMPLETED', 'FAILED', 'CANCELED', 'REFUNDED') — NOT NULL
  • transaction_id — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • canceled_at — DATETIME
  • card_issuer — VARCHAR(50)
  • bank_name — VARCHAR(50)

performance_band

  • performance_id — BIGINT — Primary key — NOT NULL
  • band_id — BIGINT — Primary key — NOT NULL

performances

  • performance_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • date — DATE — NOT NULL
  • time — TIME — NOT NULL
  • venue — VARCHAR(200) — NOT NULL
  • total_tickets — INT — NOT NULL
  • sold_tickets — INT — NOT NULL
  • ticket_price — INT — NOT NULL
  • status — ENUM('PENDING', 'UPCOMING', 'ACTIVE', 'ENDED', 'CANCELLED') — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post_likes

  • user_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Primary key — NOT NULL

reports

  • report_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • reported_id — BIGINT — NOT NULL
  • reason — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

review_comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • parent_comment_id — BIGINT
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

review_posts

  • post_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • performance_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

tickets

  • ticket_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • performance_id — BIGINT — NOT NULL
  • payment_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • status — ENUM('ISSUED', 'USED', 'CANCELLED', 'REFUNDED') — NOT NULL
  • enter_code — VARCHAR(20) — NOT NULL
  • is_entered — BOOLEAN — NOT NULL
  • entered_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_profiles

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • introduction — TEXT
  • birthdate — DATE
  • gender — ENUM('MALE', 'FEMALE')
  • exciting_index — DECIMAL(3, 1) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • permission — ENUM('USER', 'ADMIN') — NOT NULL
  • provider — VARCHAR(20)
  • provider_id — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME