instagram

Tables (5)

Comment (댓글테이블)

  • id (Key) — Primary key — NOT NULL
  • content (Field)
  • USER (Field2)
  • image (Field3)
  • id (Key2) — Foreign key → Image.id — NOT NULL
  • id (Key3) — Foreign key → User.id — NOT NULL

Image (이미지테이블)

  • id (Key) — Primary key — NOT NULL
  • caption (Field)
  • postImageUrl (Field2)
  • USER (Field3)
  • like (Field4)
  • comment (Field5)
  • likeCount (Field7)
  • id (Key2) — Foreign key → User.id — NOT NULL

Subscribe (구독테이블)

  • id (Field) — Primary key
  • toUser (Field3)
  • fromUser (Field2)
  • id (Key) — Foreign key → User.id — NOT NULL

User (유저)

  • id (Key) — Primary key — NOT NULL
  • username (유저네임)
  • password (비밀번호)
  • name (이름)
  • bio (Field5)
  • email (Field6)
  • phon (Field7)
  • gender (Field8)
  • profileImageUrl (사진주소)
  • role (권한)

like (좋아요테이블)

  • id (Key) — Primary key — NOT NULL
  • Image (Field)
  • User (Field2)
  • id (Key2) — Foreign key → Image.id — NOT NULL