insta
Tables (7)
Comment (댓글)
- comment_id (댓글 번호) — Integer — Primary key — NOT NULL
- comment_content (댓글 내용) — varchar(2000)
- Field
- post_id (게시글 번호) — Integer — Foreign key → Post.post_id — NOT NULL
- user_id (아이디) — Integer — Foreign key → User.user_id — NOT NULL
Feed (피드)
- feed_id (피드 번호) — Integer — Primary key — NOT NULL
- Field
Message (메세지)
- dm_id (디엠 번호) — Integer — Primary key — NOT NULL
- dm_content (디엠 내용) — varchar(2000)
- dm_date (디엠 보낸 시간) — date
- Field3
- user_id (send_id) — Integer — Foreign key → User.user_id — NOT NULL
- user_id (아이디2) — Integer — Foreign key → User.user_id — NOT NULL
Post (게시글)
- post_id (게시글 번호) — Integer — Primary key — NOT NULL
- post_content (게시글 내용) — varchar(2000)
- post_image (게시글 이미지) — varchar(200)
- user_id (게시글 작성 아이디) — Integer — Foreign key → User.user_id — NOT NULL
Reply (답글)
- Reply_id (답글 번호) — Integer — Primary key — NOT NULL
- Reply_content (답글 내용) — varchar(2000)
- comment_id (댓글 번호) — Integer — Foreign key → Comment.comment_id — NOT NULL
- user_id (아이디) — Integer — Foreign key → User.user_id — NOT NULL
User (유저)
- user_id (아이디) — Integer — Primary key — NOT NULL
- user_email (이메일) — varchar(200)
- user_image (프로필 사진) — varchar(200)