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