qYNDNr4w

1CREATE TABLE IF NOT EXISTS UserInfo
2(
3    UserID    SERIAL PRIMARY KEY,
4    Email     TEXT,
5    Login     TEXT,
6    Password  varchar(256),
7    FirstName TEXT,
8    LastName  TEXT,
9    Phone     TEXT
10);
11
12
13CREATE TABLE IF NOT EXISTS Products
14(
15    ProductID   SERIAL PRIMARY KEY,
16    Name        TEXT,
17    ReleaseDate TIMESTAMP,
18    BasePrice   DECIMAL
19);
20
21CREATE TABLE IF NOT EXISTS Purchases
22(
23    PurchaseID SERIAL PRIMARY KEY,
24    Timestamp  TIMESTAMP,
25    Price      DECIMAL,
26    UserID     INT NOT NULL REFERENCES Users (UserID),
27    ProductID  INT NOT NULL REFERENCES Products (ProductID)
28)