instargram_test

Tables (6)

follower (Untitled2)

  • Key (follower_uuid) — UUID — Primary key — NOT NULL
  • Key (user_uuid) — UUID — Foreign key → user.Key — NOT NULL — FK(user.user_uuid)
  • Field2 (follower) — UUID — FK(user.user_uuid)
  • Field (wdate) — DATETIME — NOT NULL

post (Untitled3)

  • Key (post_uuid) — UUID — Primary key — NOT NULL
  • Key (user_uuid) — UUID — Foreign key → user.Key — FK(user.user_uuid)
  • Field3 (content) — TEXT
  • Field4 (point) — DECIMAL
  • Field (wdate) — DATETIME — NOT NULL

post_comment (Untitled6)

  • Key (post_comment_uuid) — UUID — Primary key — NOT NULL
  • Key (user_uuid) — UUID — Foreign key → user.Key — NOT NULL — FK(user.user_uuid)
  • Key (post_uuid) — UUID — Foreign key → post.Key — NOT NULL — FK(post.post_uuid)
  • Field2 (comment) — TEXT

post_img (Untitled4)

  • Key (post_img_uuid) — UUID — Primary key — NOT NULL
  • Key (post_uuid) — UUID — Foreign key → post.Key — NOT NULL — FK(post.post_uuid)
  • Field2 (url) — TEXT

post_like (Untitled5)

  • Key (post_like_uuid) — UUID — Primary key — NOT NULL
  • Key (user_uuid) — UUID — Foreign key → user.Key — FK(user.user_uuid)
  • Key (post_uuid) — UUID — Foreign key → post.Key — FK(post.post_uuid)

user (Untitled)

  • Key (user_uuid) — UUID — Primary key — NOT NULL
  • Field (user_id) — VARCHAR(20) — NOT NULL
  • Field2 (email) — VARCHAR(30) — NOT NULL
  • Field3 (pwd) — TEXT — NOT NULL
  • Field4 (name) — VARCHAR(30) — NOT NULL
  • Field5 (phone) — VARCHAR(15) — NOT NULL
  • Field6 (sex) — BOOLEAN — NOT NULL
  • Field7 (follow_num) — INT — NOT NULL
  • Field (following_num) — INT — NOT NULL
  • Field2 (profile) — TEXT
  • Field3 (wdate) — DATETIME — NOT NULL