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