|
customer |
|||
|
customerid |
int(5) |
PK |
Not Null |
|
custnumber |
int(5) |
Not Null |
|
|
custfname |
vc() |
Null |
|
|
custmname |
vc() |
Null |
|
|
custlname |
vc() |
Null |
Let’s see what this looks like in some sample data
|
|
|||
|
emailid |
int(5) |
PK |
Not Null |
|
customerid |
int(5) |
FK |
Not Null |
|
username |
vc() |
Null |
|
|
attodot |
vc() |
Null |
|
|
domain |
vc() |
Null |
|
customer (data) |
||||
|
customerid |
custnumber |
custfname |
custmname |
custlname |
|
1 |
0001 |
Samantha |
Jean |
Carter |
|
2 |
0010 |
Vala |
Qtesh |
Maldoran |
|
3 |
0011 |
Janet |
Fraiser |
|
|
4 |
0045 |
Catherine |
Langford |
|
email (data) |
||||
|
eamilid |
customerid |
username |
attodot |
domain |
|
1 |
1 |
sam |
@ |
gmail.com |
|
2 |
1 |
scarter |
@cheyenne. |
sg1.mil |
|
3 |
1 |
samanthac |
@narim. |
tollana.ow |
|
4 |
2 |
vala |
@ |
yahoo.com |
|
5 |
2 |
qetest |
@p8x-412. |
goauld.ow |
|
6 |
3 |
jfraiser |
@cheyenne. |
sg1.mil |
Notice Colonel Carter has 3 emails and they all link in great