devCommunity

Tables (6)

Comment

  • id — int — Primary key — NOT NULL
  • id (userId) — int — Foreign key → User_Post.id — NOT NULL
  • id (postId) — int — Foreign key → User_Post.id — NOT NULL
  • content — text
  • createdAt — timestamp

Like

  • id — int — Primary key — NOT NULL
  • id (userId) — int — Foreign key → User_Post.id — NOT NULL
  • id (postId) — int — Foreign key → User_Post.id — NOT NULL

Post

  • id (postId) — int — Primary key — NOT NULL
  • title — text
  • content — text
  • createdAt — timestamp
  • updatedAt — timestamp

User

  • userId — int — Primary key — NOT NULL
  • email — text
  • encryptedPassword — text
  • createdAt — timestamp

UserProfile

  • userProfileId — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.userId — NOT NULL
  • nickname — text
  • name — text

User_Post

  • id — int — Primary key — NOT NULL
  • id (userId) — int — Foreign key → User.userId — NOT NULL
  • id (postId) — int — Foreign key → Post.id — NOT NULL