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)