Designing a Social Network Database Schema

Problem

Design a database schema for a social network that includes posts, comments, and likes.
Input:
CREATE TABLE posts (
  id INTEGER PRIMARY KEY,
  content TEXT,
  user_id INTEGER,
  FOREIGN KEY (user_id) REFERENCES users(id)
);
CREATE TABLE comments (
  id INTEGER PRIMARY KEY,
  content TEXT,
  post_id INTEGER,
  user_id INTEGER,
  FOREIGN KEY (post_id) REFERENCES posts(id),
  FOREIGN KEY (user_id) REFERENCES users(id)
);
CREATE TABLE likes (
  id INTEGER PRIMARY KEY,
  post_id INTEGER,
  user_id INTEGER,
  FOREIGN KEY (post_id) REFERENCES posts(id),
  FOREIGN KEY (user_id) REFERENCES users(id)
);
Output:
id | content | user_id
1  | Hello!  | 1 2  | Bye!    | 2
id | content | post_id | user_id
1  | Nice!   | 1       | 2
2  | Lol     | 2       | 1
id | post_id | user_id
1  | 1       | 2
2  | 2       | 1

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

/*

Solution:

The solution is optimal because it uses foreign keys to ensure data integrity.

*/