insta

Tables (7)

ChatingRoom (채팅방)

    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)