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