[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)