Advertisement
Guest User

Untitled

a guest
Jan 25th, 2020
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. CREATE TABLE categories(
  2. id VARCHAR(4) PRIMARY KEY,
  3. name VARCHAR(255) NOT NULL UNIQUE
  4. );
  5. CREATE TABLE posts(
  6. id SERIAL PRIMARY KEY,
  7. head TEXT NOT NULL,
  8. body TEXT,
  9. image VARCHAR,
  10. category_id VARCHAR(4) NOT NULL,
  11. author_id INTEGER,
  12. rating INTEGER,
  13. deleted BOOL,
  14. FOREIGN KEY(category_id) REFERENCES categories(id)
  15. );
  16. CREATE TABLE comments(
  17. id SERIAL PRIMARY KEY,
  18. body TEXT,
  19. image VARCHAR,
  20. post_id INTEGER NOT NULL,
  21. prev_id INTEGER,
  22. author_id INTEGER,
  23. rating INTEGER,
  24. deleted BOOL,
  25. FOREIGN KEY(post_id) REFERENCES posts(id)
  26. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement