cloud_final

Tables (6)

book (Untitled5)

  • bookId (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • author (Field4) — String
  • description (Field2) — String
  • image (Field3) — String
  • recomId (Key2) — Long — Foreign key → recommended_content.recomId — NOT NULL

movie (Untitled3)

  • movieId (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • releaseDate (Field4) — Date
  • description (Field2) — String
  • poster (Field3) — String
  • recomId (Key2) — Long — Foreign key → recommended_content.recomId — NOT NULL

music (Untitled4)

  • musicId (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • artist (Field4) — String
  • elbum (Field3) — String
  • recomId (Key2) — Long — Foreign key → recommended_content.recomId — NOT NULL

recommended_content (Untitled2)

  • recomId (Key) — Long — Primary key — NOT NULL
  • testId (Key2) — Long — Foreign key → test.testId — NOT NULL

test (Untitled)

  • testId (Key) — Long — Primary key — NOT NULL
  • userType (Field3) — String (적극 참여형)
  • createdAt (Field4) — Datetime
  • typeDescription (Field5) — String
  • userId (Key2) — Long — Foreign key → user.userId — NOT NULL

user (Untitled6)

  • userId (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • email (Field2) — String
  • password (Field3) — String