Skip to content
Gallery
KameGomi data flow
Share
Explore

icon picker
Pricing scheme

Input

Table master data KH

Customer
user_id
user_name
note
1
A1
A
2
A2
B
3
A3
C
4
There are no rows in this table

Table giá theo thời đoạn

Pricing
id
customer_id
start_date
end_date
pricing
1
A1_20220101
A1
1/1/2022
1/4/2022
{”paper”:3000,”plastic”:5000}
2
A1_20220105
A1
1/5/2022
{”paper”:3500,”plastic”:5200}
3
There are no rows in this table

Danh sách đơn hàng theo thời gian

Completed orders
id
customer_id
complete_date
item_list
total_price
1
ABCDEG
A1
1/2/2022
{”paper”:1,”plastic”:2}
13000
2
APQPOE
A1
1/14/2022
{”paper”:1,”plastic”:2}
13900
3
4
5
There are no rows in this table

Output

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.