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)