KTLO_app

Tables (7)

Copy Of Copy Of Copy Of Copy Of Untitled (tag_post_map)

  • Key (tpm_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (post_id) — BIGINT — Foreign key → Copy Of Untitled.Key — NOT NULL

Copy Of Copy Of Copy Of Untitled (tags)

  • Key (tag_id) — BIGINT — Primary key — NOT NULL
  • Key (tpm_id) — BIGINT — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (post_id) — BIGINT — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled.Key — NOT NULL

Copy Of Copy Of Untitled (comments)

  • Key (cmt_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (content) — VARCHAR(100)

Copy Of Copy Of Untitled2 (follower_map)

  • Key (fw_id) — BIGINT — Primary key — NOT NULL
  • Key (target_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (follower_id) — BIGINT

Copy Of Untitled (post)

  • Key (post_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (like_id) — BIGINT — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Key (cmt_id) — BIGINT — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (content) — VARCHAR(100)
  • Field (photo) — VARBINARY(max)

Copy Of Untitled2 (likes)

  • Key (like_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (target_type) — INTEGER

Untitled (user_email)

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