eBay-Database-Development-Simulation/show_all.sql at main · SenF1/eBay-Database-Development-Simulation · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
\c abcdebay;


\echo "Table: users";
SELECT * FROM users;

\echo "Table: users identified as sellers";
SELECT * FROM sellers;

\echo "Table: users identified as buyers";
SELECT * FROM buyers;

\echo "Table: users identified as bidders";
SELECT * FROM bidders;

\echo "Table: all the bids on platform";
SELECT * FROM bids;

\echo "Table: all the auctions on platform";
SELECT * FROM auctions;

\echo "Table: all the carts hold by buyers";
SELECT * FROM carts;

\echo "Table: all the items containning in carts";
SELECT * FROM contains;

\echo "Table: all the reviews on users";
SELECT * FROM reviews;

\echo "Table: all the items to be bid or sell";
SELECT * FROM items;

\echo "Table: all the sell transations made";
SELECT * FROM sales;