Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE categories(
- id VARCHAR(4) PRIMARY KEY,
- name VARCHAR(255) NOT NULL UNIQUE
- );
- CREATE TABLE posts(
- id SERIAL PRIMARY KEY,
- head TEXT NOT NULL,
- body TEXT,
- image VARCHAR,
- category_id VARCHAR(4) NOT NULL,
- author_id INTEGER,
- rating INTEGER,
- deleted BOOL,
- FOREIGN KEY(category_id) REFERENCES categories(id)
- );
- CREATE TABLE comments(
- id SERIAL PRIMARY KEY,
- body TEXT,
- image VARCHAR,
- post_id INTEGER NOT NULL,
- prev_id INTEGER,
- author_id INTEGER,
- rating INTEGER,
- deleted BOOL,
- FOREIGN KEY(post_id) REFERENCES posts(id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement