MBTI SNS
Tables (6)
Userchatting (Untitled)
- user_id (Key) — int — Foreign key → user.user_id — NOT NULL
- chatting_id (Key2) — int — Foreign key → chatting.chatting_id — NOT NULL
chatting (Untitled12)
- chatting_id (Key) — int — Primary key — NOT NULL
- createdtime (Field3) — datetime
comment (Untitled11)
- comment_id (Key) — int — Primary key — NOT NULL
- post_id (Key2) — int — Foreign key → post.post_id — NOT NULL
- user_id (Key22) — int — Foreign key → post.user_id — NOT NULL
- user_id (Key3) — int — Foreign key → user.user_id — NOT NULL
- content (Field) — string
- createdAt (Field3) — datetime
message (Untitled13)
- message_id (Key) — int — Primary key — NOT NULL
- chatting_id (Key2) — int — Foreign key → chatting.chatting_id — NOT NULL
- content (Field4) — string
- createdAt (Field3) — datetime
- user_id (Field) — int
post (Untitled10)
- post_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → user.user_id — NOT NULL
- title (Field) — string
- content_text (Field2) — string
- content_img (Field3) — BLOB
- createdAt (Field5) — datetime
- updatedAt (Field8) — datetime
- like (Field6) — int
- boardType (Field4) — Enum
user (Untitled7)
- user_id (Key) — int — Primary key — NOT NULL
- firstName (Field) — string
- lastName (Field2) — string
- email (Field4) — string
- password (Field5) — string
- profileImg (Field6) — BLOB
- phonNumber (Field3) — string
- isVerificated (Field10) — boolean
- nickname (Field7) — string
- gender (Field8) — boolean
- mbtiType (Field9) — ENUM