Food newsfeed

Tables (7)

comment (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • contents (Field) — String
  • createdAt (Field2) — LocalDateTime
  • likedCount (Field3) — Int
  • feedId (Key2) — Long — Foreign key → feed.id — NOT NULL
  • userId (Key3) — Long — Foreign key → user.id — NOT NULL

comment like (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • commentId (Key2) — Long — Foreign key → comment.id — NOT NULL
  • userId (Key3) — Long — Foreign key → user.id — NOT NULL

feed (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • description (Field2) — String
  • imageUrl (Field3) — String
  • createdAt (Field4) — LocalDateTime
  • likedCount (Field5) — Int
  • userId (Key2) — Long — Foreign key → user.id — NOT NULL

feed like (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • feedId (Key2) — Long — Foreign key → feed.id — NOT NULL
  • userId (Key3) — Long — Foreign key → user.id — NOT NULL

tag (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • cool (Field) — Boolean
  • dateCourse (Field2) — Boolean
  • hot (Field3) — Boolean
  • spicy (Field4) — Boolean
  • sweet (Field5) — Boolean
  • sweetMood (Field6) — Boolean
  • feedId (Key2) — Long — Foreign key → feed.id — NOT NULL

user (Untitled3)

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

user role (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • role (Field) — UserRole
  • userId (Key2) — Long — Foreign key → user.id — NOT NULL