b4_after
Tables (4)
Posts (Comments)
- comment_id (댓글) — int — Primary key — NOT NULL
- user_id (댓글 작성자) — ForeignKey — Foreign key → Users.user_id — NOT NULL
- post_id (게시글) — ForeignKey — Foreign key → Posts.post_id — NOT NULL
- post_id (게시글2) — int — Foreign key → Users.post_id — NOT NULL
- content (내용) — varchar
- create_at (작성일자) — DateTime
- update_at (수정일자) — DateTime
Posts
- post_id (게시글) — int — Primary key — NOT NULL
- image_id (이미지) — OneToOne — Foreign key → Posts.image_id — NOT NULL
- user_id (사용자) — ForeignKey — Foreign key → Users.user_id — NOT NULL
- post_id (게시글2) — int — Foreign key → Users.post_id — NOT NULL
- content (내용) — Text
- create_at (작성일자) — DateTime
- update_at (수정일자) — DateTime
- like_count (좋아요 수) — PositiveInteger
Posts (Images)
- image_id (이미지) — int — Primary key — NOT NULL
- before_image (업로드 이미지) — Image
- after_image (결과 이미지) — Image
Users
- user_id (사용자) — Int — Primary key — NOT NULL
- post_id (게시글) — int — Foreign key → Posts.post_id — NOT NULL
- usermame (아이디) — varchar
- password (비밀번호) — varchar
- nickname (닉네임) — varchar
- bio (자기소개) — Text
- profile_image (프로필 이미지) — Image
- post_like (좋아요) — ManyToMany
- social_id (소셜 id) — varchar
- social_id2 (소셜 id2) — varchar