instagram

Tables (3)

post (Untitled2)

  • post_id (게시글_아이디) — Primary key — NOT NULL
  • user_id (유저_아이디)
  • created_at (생성날짜)
  • textcontent (글 내용)
  • media (이미지 & 영상)
  • post_type (릴스&게시글 구분)
  • place (장소)

story (Untitled3)

  • story_id (스토리_id) — Primary key — NOT NULL
  • user_id (유저 아이디)
  • media (Field2)
  • textcontent (Field3)
  • created_at (Field4)
  • tag_user_id (Field5)
  • Field6
  • Field7
  • Field8

user (Untitled)

  • user_id (아이디) — Primary key — NOT NULL
  • user_pw (비번)
  • user_name (이름)
  • nickname (닉네임)
  • birth (생년월일)
  • intro_name (프로필_이름)
  • intro_info (프로필_소개)
  • created_at (계정생성날짜)
  • intro_img (프로필_사진)