[HHH]basic_schema

Tables (6)

Comments (comments)

  • CommentIdx (commentidx) — INT() — Primary key — NOT NULL
  • UserIdx (useridx) — INT() — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • CommentText (commenttext) — others
  • DateTime (datetime) — datetime

Contexts (contexts)

  • UserIdx (useridx) — INT() — Primary key — NOT NULL
  • UserContextIdx (usercontextidx) — INT() — Primary key — NOT NULL
  • ContextIdx (contextidx) — INT() — Primary key — NOT NULL
  • Photo (photo) — others
  • Tags (tags) — others
  • DateTime (datetime) — datetime

Follows (follows)

  • Following (following) — INT() — Primary key — NOT NULL
  • Follower (follower) — INT() — Primary key — NOT NULL
  • UserIdx (useridx) — INT() — Primary key — NOT NULL

Hashtags (hashtags)

  • TagIdx (tagidx) — INT() — Primary key — NOT NULL
  • TagText (tagtext) — VARCHAR()

Likes (likes)

  • ContextIdx (contextidx) — INT() — Primary key — NOT NULL
  • LikeUser (likeuser) — INT() — Primary key — NOT NULL
  • DateTime (datetime) — datetime

Users (users)

  • ID (id) — VARCHAR(255) — Primary key — NOT NULL
  • Index (index) — INT() — Primary key — NOT NULL
  • Password (password) — VARCHAR(255)
  • Phone (phone) — VARCHAR(255)
  • Email (email) — VARCHAR(255)