Table ItemOrdered
ORDERID
|
ITEMNO
|
PRODUCTID
|
MODELID
|
AMOUNT
|
3010
|
1
|
P01
|
SMALL
|
2
|
3011
|
1
|
P01
|
SMALL
|
3
|
3012
|
1
|
P03
|
BIG
|
1
|
3013
|
1
|
P02
|
SMALL
|
4
|
3014
|
1
|
T01
|
DOUBLE
|
2
|
3015
|
1
|
P03
|
BIG
|
1
|
3016
|
1
|
P02
|
SMALL
|
4
|
3017
|
1
|
T02
|
NORMAL
|
2
|
3018
|
1
|
P01
|
SMALL
|
3
|
3019
|
1
|
P01
|
SMALL
|
4
|
3020
|
1
|
P02
|
BIG
|
1
|
3021
|
1
|
P02
|
BIG
|
2
|
3022
|
1
|
P02
|
BIG
|
1
|
3023
|
1
|
T01
|
DOUBLE
|
2
|
3024
|
1
|
P03
|
SMALL
|
2
|
3025
|
1
|
P01
|
SMALL
|
3
|
3026
|
1
|
P02
|
BIG
|
2
|
3027
|
1
|
T01
|
NORMAL
|
2
|
3028
|
1
|
P01
|
SMALL
|
1
|
3029
|
1
|
P03
|
SMALL
|
2
|
3010
|
2
|
P03
|
BIG
|
1
|
3013
|
2
|
D03
|
1L
|
2
|
3014
|
2
|
T02
|
NORMAL
|
1
|
3015
|
2
|
D01
|
0.5L
|
1
|
3020
|
2
|
T01
|
DOUBLE
|
2
|
3021
|
2
|
P01
|
SMALL
|
1
|
3022
|
2
|
D03
|
1L
|
1
|
3023
|
2
|
P02
|
SMALL
|
1
|
3024
|
2
|
D01
|
1L
|
1
|
3025
|
2
|
D01
|
1L
|
1
|
3027
|
2
|
D01
|
1L
|
1
|
3028
|
2
|
D02
|
1L
|
1
|
3010
|
3
|
D01
|
1L
|
2
|
3014
|
3
|
D03
|
1L
|
1
|
3020
|
3
|
D03
|
1L
|
1
|
3023
|
3
|
D01
|
0.5L
|
2
|