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
mysql> describe Business;
+-----------------+--------------+------+-----+---------+----------------+
| Field           | Type         | Null | Key | Default | Extra          |
+-----------------+--------------+------+-----+---------+----------------+
| BusinessID      | mediumint(9) | NO   | PRI | NULL    | auto_increment | 
| BusinessName    | char(30)     | YES  |     | NULL    |                | 
| BusinessAddress | char(20)     | YES  |     | NULL    |                | 
| BusinessCity    | char(15)     | YES  |     | NULL    |                | 
| BusinessState   | char(2)      | YES  |     | NULL    |                | 
| BusinessZip     | char(5)      | YES  |     | NULL    |                | 
| Password        | char(24)     | NO   |     | NULL    |                | 
+-----------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

mysql> describe User;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| UserID    | mediumint(9) | NO   | PRI | NULL    | auto_increment | 
| FirstName | char(15)     | YES  |     | NULL    |                | 
| LastName  | char(15)     | YES  |     | NULL    |                | 
| Address   | char(20)     | YES  |     | NULL    |                | 
| City      | char(15)     | YES  |     | NULL    |                | 
| State     | char(2)      | YES  |     | NULL    |                | 
| Zip       | char(5)      | YES  |     | NULL    |                | 
| Phone     | char(15)     | YES  |     | NULL    |                | 
| Password  | char(24)     | NO   |     | NULL    |                | 
+-----------+--------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

mysql> describe EmploymentOpportunity;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| OpportunityID | mediumint(9) | NO   | PRI | NULL    | auto_increment | 
| Business      | char(30)     | YES  |     | NULL    |                | 
| Description   | char(150)    | YES  |     | NULL    |                | 
+---------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> describe UserBusinessOpportunity;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| BusinessID    | mediumint(9) | YES  |     | NULL    |       | 
| OpportunityID | mediumint(9) | YES  |     | NULL    |       | 
| UserID        | mediumint(9) | YES  |     | NULL    |       | 
+---------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)