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