deulbull
Tables (10)
admin
- id — BIGINT
- performance_id — BIGINT
- role — ENUM('OWNER','MANAGER','STAFF')
- password — VARCHAR(100)
band
- id — BIGINT — Primary key
- logo_url — VARCHAR(255)
- name — VARCHAR(100)
- instagram_url — VARCHAR(255)
- youtube_url — VARCHAR(255)
band_performance
- band_id — BIGINT
- performance_id — BIGINT
band_session
- id — BIGINT
- song_id — BIGINT
- band_id — BIGINT
- session_type — ENUM('Guitar','Vocal','Drum','Bass','Keyboard','Etc')
- person_id — VARCHAR(20)
booking
- id — BIGINT
- performance_id — BIGINT
- name — VARCHAR(50)
- phone_number — VARCHAR(20)
- head_count — INT
- booking_time — DATETIME
performance
- id — BIGINT
- title — VARCHAR(100)
- subtitle — VARCHAR(100)
- description — TEXT
- location — VARCHAR(100)
- date — DATE
- venue — VARCHAR(100)
- time — VARCHAR(20)
- entrance_fee — VARCHAR(20)
- poster_url — VARCHAR(255)
- s3_url — VARCHAR(255)
- current_song — VARCHAR(100)
- openchat_url — VARCHAR(255)
performance_image
- id — BIGINT
- performance_id — BIGINT
- image_url — VARCHAR(255)
performance_song
- performance_id — BIGINT
- song_id — BIGINT
- order_in_performance — INT
- liked — BOOLEAN
person
- student_number — VARCHAR(20)
- name — VARCHAR(50)
- phone_number — VARCHAR(20) — NOT NULL
- instagram_url — VARCHAR(255)
- photo_url — VARCHAR(255)
song
- id — BIGINT
- title — VARCHAR(100)
- artist — VARCHAR(100)
- album — VARCHAR(100)
- release_date — DATE
- genre — VARCHAR(50)
- youtube_url — VARCHAR(255)
- lyrics — TEXT
- likes — INT