Sophears is a new up and coming earring making business. We produce hand made stylish earrings at affordable price. Which come in handmade japences boxes.
Planning my database
|
Field Name |
Data Type |
Field Length |
Validation |
Description |
|
ID |
Text |
20 |
“E???” |
Name |
|
Order no |
Intereger |
integer |
“E???” |
Number which you use for ordering |
|
Style |
Text |
20 |
|
Shape of bead |
|
Price |
Decimal |
curreny |
>=3 |
Price of earring |
|
Stock |
Integer |
integer |
>0 |
Number left |
|
Colour |
Text |
15 |
colour of earring |
|
|
cost to make |
curreny |
Curreny |
>0 <3 | How much they cost to make |
|
Date made |
Date |
Date |
<=now( ) | When i made them |
