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