floread

Tables (6)

Book

  • id — BIGINT — Primary key
  • fileName — VARCHAR(255) — NOT NULL
  • originName — VARCHAR(255) — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • genre — VARCHAR(100) — NOT NULL
  • image — VARCHAR(500)
  • user_id — BIGINT — Foreign key → User.id

BookEmotion

  • id — BIGINT — Primary key
  • book_id — BIGINT — Foreign key → Book.id
  • emotion_id — BIGINT — Foreign key → Emotion.id

Emotion

  • id — BIGINT — Primary key
  • emotion — VARCHAR(100) — NOT NULL

Music

  • id — BIGINT — Primary key
  • fileName — VARCHAR(255)
  • url — VARCHAR(500)
  • genre — VARCHAR(100)

MusicEmotion

  • id — BIGINT — Primary key
  • music_id — BIGINT — Foreign key → Music.id
  • emotion_id — BIGINT — Foreign key → Emotion.id

User

  • id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • userId — VARCHAR(255)
  • role — VARCHAR(50) — NOT NULL