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