Automated-Auction-System/Databases at main · Awresh/Automated-Auction-System · 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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95

mysql> create aution_database;

mysql> create table Buyer
    -> (
    -> B_id int primary key,
    -> B_name varchar(255),
    -> B_email varchar(255),
    -> B_password varchar(255)
    -> );
	 ===========================================================
	mysql> desc Buyer;
	+------------+--------------+------+-----+---------+-------+
	| Field      | Type         | Null | Key | Default | Extra |
	+------------+--------------+------+-----+---------+-------+
	| B_id       | int          | NO   | PRI | NULL    |       |
	| B_name     | varchar(255) | YES  |     | NULL    |       |
	| B_email    | varchar(255) | YES  |     | NULL    |       |
	| B_password | varchar(255) | YES  |     | NULL    |       |
	+------------+--------------+------+-----+---------+-------+
	4 rows in set (0.02 sec)

	 ===========================================================

mysql> create table Seller
    -> (
    -> S_id int primary key,
    -> S_name varchar(255),
    -> S_email varchar(255),
    -> S_password varchar(255)
    -> );

	  ===========================================================
	mysql> desc Seller;
	+------------+--------------+------+-----+---------+-------+
	| Field      | Type         | Null | Key | Default | Extra |
	+------------+--------------+------+-----+---------+-------+
	| S_id       | int          | NO   | PRI | NULL    |       |
	| S_name     | varchar(255) | YES  |     | NULL    |       |
	| S_email    | varchar(255) | YES  |     | NULL    |       |
	| S_password | varchar(255) | YES  |     | NULL    |       |
	+------------+--------------+------+-----+---------+-------+
	4 rows in set (0.00 sec)
	 ===========================================================
mysql> create table Product
	-> (
	-> P_id int primary key,
	-> P_name varchar(255),
	-> P_price int,
	-> P_quantity int,
	-> P_categort varchar(255),
	-> Seller_Id int,
	-> Foreign Key(Seller_Id) references Seller(S_id)
	-> );
	 ===========================================================
	mysql> desc Product;
	+------------+--------------+------+-----+---------+-------+
	| Field      | Type         | Null | Key | Default | Extra |
	+------------+--------------+------+-----+---------+-------+
	| P_id       | int          | NO   | PRI | NULL    |       |
	| P_name     | varchar(255) | YES  |     | NULL    |       |
	| P_price    | int          | YES  |     | NULL    |       |
	| P_quantity | int          | YES  |     | NULL    |       |
	| P_categort | varchar(255) | YES  |     | NULL    |       |
	| Seller_Id  | int          | YES  | MUL | NULL    |       |
	+------------+--------------+------+-----+---------+-------+
	6 rows in set (0.00 sec)
	 ===========================================================
mysql> Create table Sold
	-> (
	-> Buyer_id int,
	-> Item_Id int,
	-> Foreign Key(Buyer_Id) references Buyer(B_id),
	-> Foreign Key(Item_Id) references Product(P_ID)
	-> );
	 ===========================================================
	mysql> desc Sold;
	+----------+------+------+-----+---------+-------+
	| Field    | Type | Null | Key | Default | Extra |
	+----------+------+------+-----+---------+-------+
	| Buyer_id | int  | YES  | MUL | NULL    |       |
	| Item_Id  | int  | YES  | MUL | NULL    |       |
	+----------+------+------+-----+---------+-------+
	2 rows in set (0.00 sec)
	 ===========================================================


	+---------------------------+
	| Option|		 Type		|
	+----------+----------------+
	| 	1   |    Administrator  |
	|	2   |    Seller  		|
	|	3   |    Buyer  		|
	|	4   |    Exit    		|
	+----------+----------------+