Music
Tables (4)
Music_File (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- origin_file_name (Field2) — varchar(255)
- stored_file_path (Field3) — varchar(500)
- file_size (Field4) — int
- created_datetime (Field5) — datetime
- updated_datetime (Field6) — datetime
- music_id (Key2) — int — Foreign key → Musics.music_id — NOT NULL
Musics (Untitled)
- music_id (Key) — int — Primary key — NOT NULL
- title (Field) — varchar(255)
- artist (Field2) — varchar(255)
- lyrics (Field3) — text
- release_date (Field4) — varchar(255)
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
user (Untitled3)
- No (Key) — int — Primary key — NOT NULL
- USER_ID (Field) — varchar(100)
- USER_PW (Field2) — varchar(200)
- NAME (Field3) — varchar(100)
- EMAIL (Field4) — varchar(200)
- REG_DATE (Field5) — timestamp
- UPD_DATE (Field6) — timestamp
- ENABLED (Field7) — int
user_auth (Untitled4)
- auth_no (Key) — int — Primary key — NOT NULL
- auth (Field2) — varchar(100)
- user_id (Key3) — int — Foreign key → user.No — NOT NULL