GreenGram

Tables (4)

t_favorite (좋아요)

  • ifeed (pk) — Foreign key → t_feed.ifeed — NOT NULL
  • iuser (pk2) — Foreign key → t_user.iuser — NOT NULL

t_feed (피드)

  • ifeed (pk) — Primary key — NOT NULL
  • iuser (pk2) — Foreign key → t_user.iuser — NOT NULL
  • cntns (컨텐츠) — varchar(1000)
  • location (장소)

t_feed_pics (피드 사진)

  • ifeed_pics (Key) — Primary key — NOT NULL
  • ifeed (pk) — Foreign key → t_feed.ifeed — NOT NULL
  • pic (사진) — varchar(100)

t_user (유저)

  • iuser (pk) — Primary key — NOT NULL
  • uid (아이디)
  • upw (비밀번호)
  • nm (이름)
  • pic (프로필사진)