Instagram Clone Coding

Tables (7)

Comment (코멘트)

  • commentIdx (PK) — INT — Primary key — NOT NULL
  • postidx (FK) — INT — Foreign key → Post.postidx
  • useridx (FK2) — INT — Foreign key → Post.useridx
  • content (Field) — VARCHAR
  • parentcommentudx (Field2) — INT — 대댓글 식별자
  • status (Field3) — VARCHAR
  • createdAt (Field4) — TimeStamp
  • updatedAt (Field5) — TimeStamp

CommentLike (코멘트 연동)

  • CommentLikeIdx (PK) — INT — Primary key — NOT NULL
  • commentIdx (FK) — INT — Foreign key → Comment.commentIdx — NOT NULL
  • useridx (FK2) — INT — Foreign key → Comment.useridx
  • status (Field1) — VARCHAR
  • createdAt (Field2) — TimeStamp
  • updatedAt (Field3) — TimeStamp

Follow (팔로우 테이블)

  • followIdx (PK) — INT — Primary key — NOT NULL
  • followerIdx (FK) — INT — Foreign key → User.useridx
  • status (Field) — VARCHAR
  • createdAt (Field2) — TimeStamp
  • updatedAt (Field3) — TimeStamp

Post (포스트)

  • postidx (PK, FK) — INT — Foreign key → Posting_URL.postidx
  • useridx (FK) — INT — Foreign key → User.useridx
  • content (Field) — VARCHAR
  • status (Field2) — VARCHAR
  • createdAt (Field3) — TimeStamp
  • updatedAt (Field4) — TimeStamp

PostLike (포스트 연동)

  • PostLikeIdx (PK) — INT — Primary key — NOT NULL
  • postingUrlIdx (FK) — INT — Foreign key → Posting_URL.postingUrlIdx — NOT NULL
  • postidx (FK2) — INT — Foreign key → Posting_URL.postidx
  • status (Field1) — VARCHAR
  • createdAt (Field2) — TimeStamp
  • updatedAt (Field3) — TimeStamp

Posting_URL (포스트 Url 관리)

  • postingUrlIdx (PK) — INT — Primary key — NOT NULL
  • postidx (FK) — INT — Primary key
  • imgUrl (Field2) — TEXT
  • status (Field3) — VARCHAR
  • createdAt (Field4) — TimeStamp
  • UpdatedAt (Field5) — TimeStamp

User (유저테이블)

  • useridx (PK, FK) — INT — Primary key
  • User_Nickname (Field1) — VARCHAR
  • Name (Field2) — VARCHAR
  • email (Field3) — VARCHAR
  • pwd (Field4) — VARCHAR
  • Profile_img (Field5) — VARCHAR
  • Status (Field6) — VARCHAR
  • createdAt (Field7) — TimeStamp
  • updatedAt (Field8) — TimeStamp