moonblog

Tables (6)

Category (Post Category Table)

  • Id (id) — varchar — Primary key — NOT NULL
  • Label (label) — varchar
  • Description (description) — varchar

Comment/ Guestbook (MONGO-COMMENT)

  • Id (id) — varchar — Primary key — NOT NULL
  • PostId (post_id) — id — Foreign key → Post.Id — NOT NULL
  • UserId (user_id) — id — Foreign key → User.Id — NOT NULL
  • Comment (comment) — varchar
  • CreatedDate (created_date) — date
  • UpdatedDate (updated_date) — date
  • LikeCount (like_count) — number
  • DislikeCount (dislike_count) — number
  • ParentId (parent_id) — id — Foreign key → Comment/ Guestbook.Id — NOT NULL

GuestComment (MONGO-GUEST-COMMENT)

  • Id (id) — varchar — Primary key — NOT NULL
  • UserId (user_id) — id — Foreign key → User.Id — NOT NULL
  • Content (content) — varchar
  • CreatedDate (created_date) — varchar
  • UpdatedDate (updated_date) — varchar
  • Likes (likes) — number
  • Dislikes (dislikes) — number
  • ParentId (parent_id) — varchar — Foreign key → GuestComment.Id — NOT NULL

Post (MONGO-POST)

  • Id (id) — varchar — Primary key — NOT NULL
  • CategoryId (category_id) — id — Foreign key → Category.Id — NOT NULL
  • TitleKor (title_kor) — varchar
  • TitleEng (title_eng) — varchar
  • ContentKor (content_kor) — varchar
  • ContentEng (content_eng) — varchar
  • CreatedDate (created_date) — date
  • UpdatedDate (updated_date) — date
  • Views (views) — number
  • ShareCount (share_count) — number
  • Likes (likes) — number
  • Dislikes (dislikes) — number

User (User Table)

  • Id (id) — varchar — Primary key — NOT NULL
  • LoginType (login_type) — varchar
  • Email (email) — varchar
  • Name (name) — varchar
  • Pw (pw) — varchar
  • CreatedDate (created_date) — date
  • UpdatedDate (updated_date) — date
  • Role (role) — varchar
  • Verified (verified) — boolean
  • MarketingConsent (marketing_consent) — boolean
  • PrivacyConsent (privacy_consent) — boolean

interactive_count (Untitled)

  • id — varchar — Primary key — NOT NULL
  • Id (id3) — varchar — Foreign key → Post.Id — NOT NULL
  • CategoryId (category_id) — id — Foreign key → Post.CategoryId — NOT NULL
  • userid (userId)
  • contentId
  • content_type (contentType)
  • interative_type (interactiveType)
  • Id (id2) — varchar — Foreign key → User.Id — NOT NULL
  • Id (id4) — varchar — Foreign key → Comment/ Guestbook.Id — NOT NULL