prac_with_kwon
Tables (9)
comment (Untitled3)
- comment_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
comment_likes (Untitled5)
- like_id (Key) — BIGINT — Primary key — NOT NULL
- comment_id (Key2) — BIGINT — Foreign key → comment.comment_id — NOT NULL
- user_id (Key22) — BIGINT — Foreign key → comment.user_id — NOT NULL
- post_id (Key3) — BIGINT — Foreign key → comment.post_id — NOT NULL
- timestamp (Field) — TIMESTAMP
- target_type (Field2) — INTEGER
follower (Untitled9)
- follower_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
follower_map (Untitled8)
- follower_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL
- follower_id (Key3) — BIGINT — Foreign key → follower.follower_id — NOT NULL
post_likes (Untitled4)
- like_id (Key) — BIGINT — Primary key — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → posts.post_id — NOT NULL
- user_id (Key22) — BIGINT — Foreign key → posts.user_id — NOT NULL
- timestamp (Field) — TIMESTAMP
- target_type (Field2) — INTEGER
posts (Untitled2)
- 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 (Untitled6)
- tag_id (Key) — BIGINT — Primary key — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → posts.post_id — NOT NULL
- tag_id (Key3) — BIGINT — Foreign key → tags.tag_id — NOT NULL
tags (Untitled7)
- tag_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
users (Untitled)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(50)
- password (Field2) — VARCHAR(50)
- name (Field3) — VARCHAR(50)