springBoot

Tables (4)

MPost (Untitled3)

  • postId — int — Foreign key → Post.postId — NOT NULL
  • musicId — int — Foreign key → Music.musicId — NOT NULL

Music (Untitled2)

  • musicId — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • mTitle — varchar(50)
  • Field

Post (Untitled)

  • postId — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • title — varchar(25)
  • content — varchar(255)

User

  • id — int — Primary key — NOT NULL
  • userId — varchar(25)
  • password — varchar(255)
  • name — varchar(25)
  • email — varchar(30)
  • nickname — varchar(25)
  • birthDate — TIMESTAMP
  • createAt — TIMESTAMP