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