Citistagram

Tables (7)

Untitled (contents)

  • Key (post_id) — BICINT — Primary key — NOT NULL
  • Key (user_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
  • Field2 (image)
  • Field3 (desc) — VARCHAR(100)
  • Field (timestamp) — TIMESTAMP

Untitled (users)

  • Key (user_id) — BICINT — Primary key — NOT NULL
  • Field (email) — VARCHAR(50)
  • Field2 (password) — VARCHAR(50)
  • Field3 (name) — VARCHAR(50)

Untitled (likes)

  • Key (like_id) — BICINT — Primary key — NOT NULL
  • Key (user_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (post_type) — INTERGER

Untitled (follower_map)

  • Key (follow_id) — BICINT — Primary key — NOT NULL
  • Key (follower_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
  • Field (following_id)

Untitled (tags)

  • Key (tag_id) — BICINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(20)

Untitled (tag_post_map)

  • Key (tag_post_id) — BICINT — Primary key — NOT NULL
  • Key (tag_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — BICINT — Foreign key → Untitled.Key — NOT NULL

comments

  • Key (comment_id) — BICINT — Primary key — NOT NULL
  • Key (user_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — BICINT — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — VARCHAT(100)
  • Field2 (timestamp) — TIMESTAMP