nikita150187
nikita150187
/ create_tables.sql
Created
April 28, 2025 11:08
PostgreSQL Advanced Queries & Relationships
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE players ( | |
| id SERIAL PRIMARY KEY, | |
| name VARCHAR(100), | |
| join_date DATE | |
| ); | |
| CREATE TABLE games ( | |
| id SERIAL PRIMARY KEY, | |
| title VARCHAR(100), | |
| genre VARCHAR(50) |
nikita150187
/ create_tables.sql
Created
April 28, 2025 10:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE players ( | |
| id SERIAL PRIMARY KEY, | |
| name VARCHAR(100), | |
| join_date DATE | |
| ); | |
| CREATE TABLE games ( | |
| id SERIAL PRIMARY KEY, | |
| title VARCHAR(100), | |
| genre VARCHAR(50) |