1. user

CREATE TABLE `user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  `is_admin` enum('yes','no') COLLATE utf8_czech_ci DEFAULT NULL,
  `registration_date` date DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci

2. artist

CREATE TABLE `artist` (
  `artist_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `artist_name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `spotify_src` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `discogs_link` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`artist_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci

3. master (album)

CREATE TABLE `master` (
  `master_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `artist_id` bigint(20) NOT NULL,
  `spotify_src` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `discogs_link` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `master_name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `master_release_date` year(4) NOT NULL,
  `genre` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `styles` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `img_link` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`master_id`),
  KEY `artist_id` (`artist_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_c