ERC_prac
Tables (7)
comments (Untitled4)
- comments_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL
- post_id (Key3) — BIGINT — Foreign key → posts.post_id — NOT NULL
- content (Field) — VARCHAR(100)
- timestamp (Field2) — TIMESTAMP
follower_map (Untitled2)
- follower_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL
likes (Untitled3)
- like_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL
- timestamp (Field) — TIMESTAMP
- target_type (Field2) — INTEGER
posts (Untitled)
- post_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL
- timestamp (Field) — TIMESTAMP
- content (Field2) — VARCHAR(100)
tag_post_map (Untitled5)
- tag_post_map_id (Key) — BIGINT — Primary key — NOT NULL
- tags_id (Key2) — BIGINT — Foreign key → tags.tags_id — NOT NULL
- post_id (Key3) — BIGINT — Foreign key → posts.post_id — NOT NULL
tags (Untitled6)
- tags_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
users
- user_id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(50)
- password (Field2) — VARCHAR(50)
- name (Field3) — VARCHAR(50)