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)