HITTER

Tables (7)

board

  • board_id — BIGINT — Primary key — NOT NULL
  • board_title — VARCHAR(200) — NOT NULL
  • board_content — TEXT — NOT NULL
  • board_count — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • category_id — BIGINT
  • user_nickname — VARCHAR(255)

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • comment_writer_Id — BIGINT — Foreign key → user.user_id — NOT NULL
  • comment_nickname — VARCHAR(16) — Foreign key → user.user_nickname — NOT NULL
  • comment_contents — VARCHAR(500) — NOT NULL
  • board_id — BIGINT — Foreign key → board.board_id — NOT NULL
  • created_at — DATETIME — NOT NULL

like_song2

  • like_song_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id
  • song_id — BIGINT — Foreign key → song.song_id

notice

  • notice_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id
  • use_nickname — VARCHAR(16) — Foreign key → user.user_nickname
  • notice_title — VARCHAR(400) — NOT NULL
  • created_at — DATETIME
  • notice_content — TEXT — NOT NULL
  • notice_count — BIGINT — NOT NULL

refresh_token

  • rt_key — VARCHAR(255) — Primary key — NOT NULL
  • rt_value — VARCHAR(255)

song

  • song_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • user_nickname — VARCHAR(16)
  • song_title — VARCHAR(500) — NOT NULL
  • file_sys_name — VARCHAR(1000) — NOT NULL
  • prediction — FLOAT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • genre — VARCHAR(50) — NOT NULL
  • lyrics_sys_name — VARCHAR(500)
  • song_like — INT
  • song_tag — VARCHAR(1000)

user

  • user_id — BIGINT — Primary key — NOT NULL
  • user_email — VARCHAR(50) — NOT NULL
  • user_nickname — VARCHAR(16) — NOT NULL
  • user_name — VARCHAR(16) — NOT NULL
  • user_password — VARCHAR(1000) — NOT NULL
  • user_admin — TINYINT(1)
  • roles — VARCHAR(255)
  • authority — VARCHAR(255)