mini

Tables (4)

comment (Untitled3)

  • commentId (Key) — Long — Primary key — NOT NULL
  • postId (Key2) — Long — Foreign key → post.postId — NOT NULL
  • userId (Key3) — Long — Foreign key → user.userId — NOT NULL
  • comment (Field) — String
  • username (Field2) — String
  • createdAt (Field3) — String

post (Untitled2)

  • postId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → user.userId — NOT NULL
  • title (Field) — String
  • username (Field2) — String
  • artist (Field3) — String
  • genre (Field4) — String
  • contents (Field5) — String
  • image (Field6) — String
  • video (Field7) — String
  • likeCnt (Field8) — Long
  • createdAt (Field9) — String
  • modifiedAt (Field10) — String

postLike (Untitled4)

  • likeId (Key) — Long — Primary key — NOT NULL
  • postId (Key2) — Long — Foreign key → post.postId — NOT NULL
  • userId (Key3) — Long — Foreign key → user.userId — NOT NULL

user (Untitled)

  • userId (Key) — Long — Primary key — NOT NULL
  • username (Field) — String
  • password (Field2) — String