spacegram

Tables (8)

comment_like (CopyOflikes)

  • comment_like_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • target_comment_id (Key3) — BIGINT — Foreign key → comments.user_id — NOT NULL
  • timestamp (Field2) — TIMESTAMP

comments

  • comment_id (Key) — BIGINT — Primary key — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → posts.post_id — NOT NULL
  • user_id (Key3) — BIGINT — Foreign key → user.user_id — NOT NULL
  • content (Field) — VARCHAR(50)
  • timespamp (Field2) — TIMESTAMP

follower_map

  • follower_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • target_user_id (Field2) — BIGINT

posts

  • post_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • timestamp (Field) — TIMESTAMP
  • content (Field2) — VARCHAR(50)

posts_like (likes)

  • posts_like_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • target_post_id (Key4) — BIGINT — Foreign key → posts.post_id — NOT NULL
  • timestamp (Field2) — TIMESTAMP

tag_post_map

  • tag_post_id (Key) — BIGINT — Primary key — NOT NULL
  • tag_id (Key3) — BIGINT — Foreign key → tags.tag_id — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → posts.post_id — NOT NULL
  • user_id (Key22) — BIGINT — Foreign key → posts.user_id — NOT NULL

tags

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

user

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