community-hub

Tables (4)

Comments

  • commentsId — Int — Primary key — NOT NULL
  • UserId — Int — Foreign key → Users.userId — NOT NULL
  • PostId — Int — Foreign key → Posts.postId — NOT NULL
  • content — String
  • createdAt — DateTime
  • updatedAt — DateTime
  • deletedAt — DateTime

Posts

  • postId — Int — Primary key — NOT NULL
  • UserId — Int — Foreign key → Users.userId — NOT NULL
  • title (email) — String — NOT NULL
  • content — String — NOT NULL
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

Users

  • userId — Int — Primary key — NOT NULL
  • email — String — NOT NULL
  • password — String — NOT NULL
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DateTime

UsersInfos

  • userInfoId — Int — Primary key — NOT NULL
  • UserId — Int — Foreign key → Users.userId — NOT NULL
  • name — String — NOT NULL
  • age — Int
  • gender — String — NOT NULL
  • profileImage — String
  • createdAt — DateTime — NOT NULL
  • updatedAt — DateTime — NOT NULL
  • deletedAt — DataTime