asdf
Tables (5)
Diary
- diaryId — INT — Primary key — NOT NULL — AUTO_INCREMENT
- id — INT — Foreign key → User.id — NOT NULL
- month — INT — Foreign key → Platlist.month — NOT NULL
- title — VARCHAR(255)
- date — DATE
- content — TEXT
- image — VARCHAR(255)
Music
- musicId — INT — Primary key — NOT NULL
- month — INT — Foreign key → Platlist.month — NOT NULL
- title — VARCHAR(255)
- artist — VARCHAR(255)
Platlist
- month — INT — Primary key — NOT NULL
- musicId — INT — FK
Preference
- id (preferenceId) — INT — NOT NULL
- id (userId) — INT — Foreign key → User.id — NOT NULL
- artist (artistname) — VARCHAR(255)
User
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- userId — VARCHAR(255)
- password — VARCHAR(255)
- pin — INT — 일기 삭제 시 필요