未命名 Snippet.txt

select * from orders a join users b on a.p_user = b.PK;
select * from paymenttransactions a join orders b on a.p_order = b.pk;
select * from paymentmodes a join orders b on a.PK = b.p_paymentmode;
select * from orderentries a join orders b on a.p_order = b.pk;
select * from products a join orderentries b on a.PK = b.p_product;
select * from subentries a join guestinfos b on a.p_guestinfo = b.PK;
select * from subentries a join orderentries b on a.p_entry = b.PK;
select * from rules a join promotion p on a.p_code = p.p_code;



CDP_ECO_002	orders	p_code	p_externalordercode	p_ordertype	p_saleschannel	createdTS	p_totalprice	p_paymentstatus	p_status	p_subtotal	p_appliedcouponcodes	p_totaldiscounts
CDP_ECO_004	users	p_uid	p_mobilephone
CDP_ECO_001	guestinfos	p_lastname	p_mobilephone	p_govid	p_govidtype
CDP_ECO_017	addresses	p_country	p_region	p_city
CDP_ECO_014	coupon	p_redemptionstartdate	createdTS	p_redemptionenddate	p_active	p_totalquantity
CDP_ECO_007	orderentries	p_entrynumber	p_quantity
CDP_ECO_006	paymentmodes	p_code
CDP_ECO_005	paymenttransactions	p_code	createdTS
CDP_ECO_011	pricerows	p_price
CDP_ECO_008	products	p_code	p_producttype	p_maxqty	p_minqty	p_onlinedate	p_offlinedate	p_bundletype
CDP_ECO_009	promotion	p_code	p_startdate	p_enddate	p_description
CDP_ECO_012	rules	p_conditions
CDP_ECO_010	subentries	p_status	p_servicefee
CDP_ECO_015	ubrcouponcodeactivities	p_time	p_status
CDP_ECO_013	ubrcouponcodes	p_couponcode
CDP_ECO_003	usergroups	p_uid	p_name


orders p_user
users pk
paymenttransactions p_order
orders pk
paymentmodes pk
orders p_paymentmode
orderentries p_order
orders pk
products pk
orderentries p_product
subentries p_guestinfo
guestinfos pk
subentries p_entry
orderentries pk
rules p_code