ㅇㅇ
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