CookTak

Tables (5)

category (categories)

  • _id — ObjectID — Primary key — NOT NULL
  • content — String
  • parentCategory (parentCg) — ObjectID — Foreign key → category._id

comment (comments)

  • _id — ObjectID — Primary key — NOT NULL
  • userId — ObjectID — Foreign key → user._id — NOT NULL
  • content — String

likeUnlike (likesUnlikes)

  • _id — ObjectID — Primary key — NOT NULL
  • userId — ObjectID — Foreign key → user._id — NOT NULL
  • postId — ObjectID — Foreign key → post._id — NOT NULL
  • isLike — boolean
  • isUnlike — boolean

post (posts)

  • _id — ObjectID — Primary key — NOT NULL
  • userId — ObjectID — Foreign key → user._id — NOT NULL
  • tagId — ObjectID[] — Foreign key → category._id — NOT NULL
  • title — String
  • content — String
  • likeNo — int
  • unlikeNo — int
  • hit — int

user (users)

  • _id — ObjectID — Primary key — NOT NULL
  • nickName — String
  • age — int
  • email — String
  • password (pwd) — String
  • gender — boolean