1# Simple table describing a vehicle
2
3CREATE TABLE vehicle(
4 # vehicleId: Unique ID for Primary Key.
5 # This is how we will reference a record
6 vehicleId INT NOT NULL,
7 make VARCHAR(64), # String 64 chars max
8 model VARCHAR(128),
9 derivative VARCHAR(255),
10 PRIMARY KEY(vehicleId)
11);
12
13# Add a record
14INSERT INTO vehicle VALUES(1000,'Volkswagen','Golf','1.5 TSI EVO Match Edition 5dr');
1CREATE TABLE fact (
2id SERIAL PRIMARY KEY NOT NULL,
3type VARCHAR(255),
4text TEXT
5);
6
7