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