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