Mindpairing

Tables (19)

Agreement (terms agreements)

  • agreement id (id) — INT — Primary key — NOT NULL
  • User id (user_id) — INT — Foreign key → User.User id — NOT NULL
  • Terms id (terms_id) — INT — Foreign key → Terms.Terms id — NOT NULL
  • Agreement (agreement) — BOOL
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME

BeMBTI (User is MBTI)

  • id — INT — Primary key — NOT NULL
  • User id (user_id) — INT — Foreign key → User.User id — NOT NULL
  • Energy (energy) — VARCHAR(1)
  • Information (information) — VARCHAR(1)
  • Decision (decision) — VARCHAR(1)
  • Lifestyle (lifestyle) — VARCHAR(1)
  • Created time (create_at) — DATETIME — NOT NULL

Board (Board category)

  • Board id (id) — INT — Primary key — NOT NULL
  • Board index (index) — INT
  • Main category (hashtag_id) — INT — Foreign key → Hashtag.Hashtag id — NOT NULL
  • hidden — BOOL
  • Board name (name) — VARCHAR(20)
  • Description (description) — TEXT

Comment

  • Comment id (id) — INT — Primary key — NOT NULL
  • Author (user_id) — INT — Foreign key → User.User id — NOT NULL
  • Content (content) — VARCHAR
  • Like count (like) — INT
  • Report count (report) — INT
  • hidden — BOOL
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • Deleted time (delete_at) — DATETIME
  • Post id (post_id) — INT — Foreign key → Post.Post id — NOT NULL
  • Parent comment id (parent_comment_id) — INT — Foreign key → Comment.Comment id — NOT NULL

CommentReportAssoc (Commans-Report Association)

  • assoc id (id) — INT — Primary key — NOT NULL
  • Comment id (comment_id) — INT — Foreign key → Comment.Comment id — NOT NULL
  • Report id (report_id) — INT — Foreign key → Report.Report id — NOT NULL

Hashtag (Hash tag)

  • Hashtag id (id) — INT — Primary key — NOT NULL
  • content — VARCHAR(20)
  • Reference count (ref_count) — INT

LikeMBTI (User like MBTI)

  • id — INT — Primary key — NOT NULL
  • User id (user_id) — INT — Foreign key → User.User id — NOT NULL
  • Energy (energy) — VARCHAR(1)
  • Information (information) — VARCHAR(1)
  • Decision (decision) — VARCHAR(1)
  • Lifestyle (lifestyle) — VARCHAR(1)
  • Created time (create_at) — DATETIME — NOT NULL

MBTIQuestion (MBTI Questions)

  • id — INT — Primary key — NOT NULL
  • question index (index) — INT
  • category — INT
  • text — VARCHAR
  • Never (select0_score) — INT
  • No (select1_score) — INT
  • Yes (select2_score) — INT
  • Absolutely Yes (select3_score) — INT

Message

  • message id (id) — INT — Primary key — NOT NULL
  • Sender id (sender_id) — INT — Foreign key → User.User id — NOT NULL
  • Receiver id (receiver_id) — INT — Foreign key → User.User id — NOT NULL
  • Content (content) — VARCHAR
  • Created time (create_at) — DATETIME
  • Deleted time (delete_at) — DATETIME

MessageReportAssoc (Message-Report association)

  • id — INT — Primary key — NOT NULL
  • Report id (report_id) — INT — Foreign key → Report.Report id — NOT NULL
  • Message id (msg_id) — INT — Foreign key → Message.message id — NOT NULL

OpenAuth (Open Authentication)

  • id — INT — Primary key — NOT NULL
  • User id (user_id) — INT — Foreign key → User.User id — NOT NULL
  • Kakao social id (kakao) — VARCHAR(50)
  • Naver social id (naver) — VARCHAR(50)
  • Google social id (google) — VARCHAR(50)
  • Apple social id (apple) — VARCHAR(50)
  • Kakao update time (kakao_update_at) — DATETIME
  • Naver update time (naver_update_at) — DATETIME
  • Google update time (google_update_at) — DATETIME
  • Apple update time (apple_update_at) — DATETIME

Penalty (User penalty)

  • Penalty id (id) — INT — Primary key — NOT NULL
  • User id (user_id) — INT — Foreign key → User.User id — NOT NULL
  • Start time (start_at) — DATETIME
  • End time (end_at) — DATETIME
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • Evidence (evidence) — VARCHAR(50)
  • Comment (comment) — TEXT

Post

  • Post id (id) — INT — Primary key — NOT NULL
  • Board id (board_id) — INT — Foreign key → Board.Board id — NOT NULL
  • Author (user_id) — INT — Foreign key → User.User id — NOT NULL
  • Title (title) — VARCHAR(50)
  • Content (content) — VARCHAR
  • View count (view) — INT
  • Like count (like) — INT
  • Report count (report) — INT
  • hidden — BOOL
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • Deleted time (delete_at) — DATETIME
  • Reserved time (reserve_at) — DATETIME

PostHashtagAssoc (Post-Hashtag Association)

  • Reference id (id) — INT — Primary key — NOT NULL
  • Post id (post_id) — INT — Foreign key → Post.Post id — NOT NULL
  • Hashtag id (hashtag_id) — INT — Foreign key → Hashtag.Hashtag id — NOT NULL
  • Created time (create_at) — DATETIME
  • Deleted time (delete_at) — DATETIME

PostReportAssoc (Post-Report association)

  • id — INT — Primary key — NOT NULL
  • Report id (id2) — INT — Foreign key → Report.Report id — NOT NULL
  • Post id (id3) — INT — Foreign key → Post.Post id — NOT NULL

Report

  • Report id (id) — INT — Primary key — NOT NULL
  • Complainant id (complainant_id) — INT — Foreign key → User.User id — NOT NULL
  • Dedendant id (defendant_id) — INT — Foreign key → User.User id — NOT NULL
  • Reason id (reason_id) — INT — Foreign key → ReportReason.reason id — NOT NULL
  • Processing status (status) — INT
  • report comment (comment) — VARCHAR
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME

ReportReason (Report reason)

  • reason id (id) — INT — Primary key — NOT NULL
  • Reason index (index) — INT
  • Reason (content) — VARCHAR(20)

Terms

  • Terms id (id) — INT — Primary key — NOT NULL
  • Title (title) — VARCHAR(50)
  • Content (content) — VARCHAR
  • Mandatory (mandatory) — BOOL
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME

User (membership)

  • User id (id) — INT — Primary key — NOT NULL
  • Nickname (nickname) — VARCHAR(20) — NOT NULL
  • Password (password) — VARCHAR(50)
  • Name (name) — VARCHAR(50)
  • Gender (gender) — INT
  • Phone (phone) — VARCHAR(12)
  • Email (email) — VARCHAR(50)
  • Profile image (image) — VARCHAR(255)
  • Created time (create_at) — DATETIME
  • Updated time (update_at) — DATETIME
  • User initialized (is_init) — BOOL