Internal Data

MARKETING

CUSTOMERS

ORDERS/SALES

PRODUCTS

ACCOUNTING

HR/EMPLOYEES

campaigns

PK campaign_id

FK channel_id

name

landing_page

type

message_type

image_type

impressions

ad_spend

revenue

start_date

end_date

cust_segmentation_survey

PK survey_id

suvey_date

FK customer_id

gender

age

relationship_status

dependents

occupation

geographic_area

income

education

bag_use_type

bag_use_frequency

bag_use_purpose

bag_travel_type

work_travel_frequency

fun_travel_frequency

fun_trip_type

bag_count

planning

spending

local_buying

trend

hobby

shopping_location

product_pref

brand_pref

bag_pref_1

bag_pref_2

bag_pref_3

bag_pref_4

annual_bags

annual_spend

product_feature_survey

PK survey_id

FK customer_id

survey_date

persona

feature

feature_score

orders

PK order_id

FK customer_id

FK delivery_id

order_total_revenue

shipping_cost

order_discount_rate

order_date

warranty_claims

PK claim_id

FK order_Id

create_date

type

resolved_date

description

FK product_id

FK unit_id

refund_amount

accounts_payable

PK payable_id

FK supplier_id

name

type

payable_date

payable_amount

days_outstanding

FK expense_id

human_resources

PK employee_id

FK user_id

start_date

end_date

role

hourly_wage

salary_wage

bonus_cap

turnover_reason

suppliers

PK supplier_id

FK user_id

create_date

types

retailer_reports

PK retailer_report_id

FK retailer_id

report_month_year

monthly_revenue_target

monthly_buhi_sales

monthly_transaction_ct

avg_inventory

user

PK user_id

user_type

first_name

last_name

email

phone_number

street_address

city

state

postal_code

retailers

PK retailer_id

FK user_id

FK customer_id

create_date

type

employee_surveys

PK survey_id

FK employee_id

name

survey_date

job_satisfaction

mgr_relationship

coworker_relationship

workload

position_history

PK position_id

FK employee_id

create_date

open_date

filled_date

accounts_receivable

PK receivable_id

FK retailer_id

name

type

receivable_date

receivable_amount

FK order_id

days_outstanding

paid_in_full

expenses

PK expense_id

name

expense_type

expense_date

expense_amount

FK user_id

smart_product_app_data

PK record_id

FK user_id

FK product_id

unit_id

record_date

record_time

location

location_time

avg_daily_distance

max_distance

avg_daily_elevation

max_elevation

min_temp

max_temp

avg_daily_temp

max_bag_load

max_elevation

min_elevation

avg_daily_weight

max_weight

days_no_weight

days_with_weight

products

PK product_id

product_name

product_category

product_subcategory

list_price

smart_product_sensor_data

PK record_id

FK product_id

unit_id

record_date

record_time

location

air_pressure

strap_1_weight

strap_2_weight

temperature

units

PK unit_id

FK product_id

FK user_id

FK supplier_id

delivery

PK delivery_id

type

status

scheduled_date

delivered_date

order_line_item

PK line_item_id

FK order_id

FK product_id

unit_price

quantity

line_total_price

customers

PK customer_id

FK user_id

create_date

type

FK segment_id

customer_segments

PK segment_id

name

min_age

max_age

gender

interests

occupation

geographic_area

relationship_status

dependents

average_income

education_level

FK target_product_id

target_product_name

engagements

PK engagement_id

FK customer_id

FK order_id

FK campaign_id

FK subscription_id

customer_segment_id

send_date

reception_status

subscription_target

country

opens

clicks

conversions

likes

shares

comments

revenue

marketing_channels

PK channel_id

name

type

customer_subscriptions

PK subscription_id

FK customer_id

subscription_type

subscription_status

start_date

end_date

subscription_list

FK engagement_id

FK subscription_id

OTHER

1. channel_id:
2. campaign_id:
3. engagement_id:
4. subscription_id:
5. segment_id:
6. user_id:
7. target_product_id 3:
8. customer_id [css]:
9. customer_id [cs]:
10. retailer_id:
11. supplier_id:
12. supplier_id [2]:
13. delivery_id:
14. expense_id:
15. user_id [e]:
16. user_id [hr]:
17. employee_id [es]:
18. customer_id:
19. user_id [s]:
20. user_id [s] 1:
21. user_id [r]:
22. customer_id [r]:
23. customer_id [o]:
24. order_id [e]:
25. order_id [oli]:
26. order_id [wc]:
27. target_product_id 1:
28. user_id [spad]:
29. user_id [u] [1]:
30. employee_id [ph]:
31. retailer_id [ar]:
32. customer_id [pfs]:
33. user_id [u] [2]:
34. user_id [hr] 2:
35. user_id [r] 2:
36. user_id [s] 2:
37. user_id [spad] 2:
38. user_id [spad] 3:
39. customer_id [o] 2:
40. channel_id 3:
41. channel_id 2:
42. engagement_id 2:
43. engagement_id 3:
44. campaign_id 2:
45. order_id [e] 2:
46. order_id [e] 3:
47. customer_id 2:
48. customer_id 3:
49. customer_id [cs] 2:
50. customer_id [css]2:
51. customer_id [css] 3:
52. customer_id [css] 4:
53. segment_id 2:
54. segment_id 3:
55. user_id 2:
56. user_id 3:
57. supplier_id 2:
58. supplier_id 3:
59. supplier_id 4:
60. supplier_id 5:
61. retailer_id [ar] 2:
62. retailer_id [ar] 3:
63. retailer_id [ar] 4:
64. retailer_id [ar] 5:
65. order_id [ar]:
66. order_id [ar] 2:
67. order_id [ar] 3:
68. order_id [ar] 4:
69. order_id [ar] 5:
70. customer_id [r] 2:
71. customer_id [r] 3:
72. target_product_id 2:
73. user_id [spad] 4:
74. user_id [spad] 5:
75. order_id [oli] 2:
76. order_id [oli] 3:
77. expense_id 2:
78. expense_id 3:
79. user_id [e] 3:
80. user_id [e] 2:
81. employee_id [ph] 2:
82. employee_id [ph] 3:
83. order_id [wc] 2:
84. order_id [wc] 3:
85. customer_id [css] 5:
86. unit_id [units] 2:
87. product_id 3:
88. unit_id [units] 3:
89. unit_id [units] 4:
90. unit_id [units] 5:
91. unit_id [units - warranty_claims]:
92. product-id [ units - products]:
93. product_id #:
94. unit_id [smart] 1:
95. unit_id [smart] 2:
96. unit_id [smart] 3:
97. campaign_id [HIDE]:
98. channel_id [HIDE]:
99. channel_id [HIDE] 1:
100. engagement_id [HIDE]:
101. subscription_id [HIDE]:
102. subscription_id [HIDE] 1:
103. subscription_id [HIDE] 2:
104. customer_id [cfs] [HIDE]:
105. target_product_id [HIDE]:
106. customer_id [cfs] [HIDE] 2:
107. customer_id [cfs] [HIDE] 1:
108. engagement_id [HIDE] 1:
109. engagement_id [HIDE] 2:
110. campaign_id [SHOW]:
111. channel_id [SHOW]:
112. channel_id [SHOW] 1:
113. engagement_id [SHOW]:
114. subscription_id [SHOW]:
115. subscription_id [SHOW] 1:
116. subscription_id [SHOW] 2:
117. subscription_id [SHOW] 3:
118. target_product_id [SHOW]:
119. subscription_id [SHOW] 5:
120. subscription_id [SHOW] 4:
121. engagement_id [SHOW] 1:
122. engagement_id [SHOW] 2:
123. campaign_id [ANCHOR]:
124. channel_id [ANCHOR]:
125. channel_id [ANCHOR] 2:
126. engagement_id [ANCHOR:
127. subscription_id [ANCHOR] 1:
128. subscription_id [ANCHOR]:
129. customer_id [cs] [ANCHOR]:
130. target_product_id [ANCHOR]:
131. segment_id [cs] [ANCHOR]:
132. customer_id [ANCHOR] 1:
133. engagement_id [ANCHOR] 2:
134. customer_id [ANCHOR]:
135. campaign_id [ANCHOR] 1:
136. order_id [ANCHOR]:
137. campaign_id [HIDE] 2:
138. order_id [HIDE]:
139. campaign_id [SHOW] 2:
140. order_id [SHOW]:
141. customer_id [cfs] [HIDE] 3:
142. customer_id [cfs] [HIDE] 4:
143. customer_id [cfs] [HIDE] 5:
144. subscription_id [SHOW] 6:
145. subscription_id [SHOW] 7:
146. subscription_id [SHOW] 8:
147. segment_id [c] [ANCHOR] :
148. user_id [c] [ANCHOR]:
149. supplier_id [HIDE]:
150. supplier_id [show]:
151. customer_id [cfs] [HIDE] 7:
152. customer_id [cfs] [HIDE] 8:
153. customer_id [cfs] [HIDE] 12:
154. customer_id [cfs] [HIDE] 11:
155. customer_id [cfs] [HIDE] 13:
156. customer_id [cfs] [HIDE] 14:
157. customer_id [cfs] [HIDE] 10:
158. subscription_id [SHOW] 10:
159. subscription_id [SHOW] 11:
160. subscription_id [SHOW] 15:
161. subscription_id [SHOW] 14:
162. subscription_id [SHOW] 16:
163. subscription_id [SHOW] 17:
164. subscription_id [SHOW] 13:
165. segment_id [c] [ANCHOR] 2:
166. segment_id [c] [ANCHOR] 6:
167. segment_id [c] [ANCHOR] 28:
168. segment_id [c] [ANCHOR] 26:
169. segment_id [c] [ANCHOR] 29:
170. segment_id [c] [ANCHOR] 30:
171. customer_id [cfs] [HIDE] 9:
172. subscription_id [SHOW] 12:
173. segment_id [c] [ANCHOR] 4:
174. retailer_id [rr] [HIDE}:
175. retailer_id [rr] [HIDE} 4:
176. retailer_id [rr] [HIDE} 1:
177. retailer_id [rr] [HIDE} 3:
178. retailer_id [rr] [HIDE} 6:
179. retailer_id [rr] [HIDE} 7:
180. retailer_id [rr] [HIDE} 12:
181. retailer_id [rr] [HIDE} 14:
182. retailer_id [rr] [HIDE} 24:
183. retailer_id [rr] [HIDE} 25:
184. retailer_id [rr] [HIDE} 13:
185. retailer_id [rr] [HIDE} 8:
186. retailer_id [rr] [HIDE} 9:
187. retailer_id [rr] [HIDE} 10:
188. retailer_id [rr] [HIDE} 11:
189. retailer_id [rr] [HIDE} 5:
190. retailer_id [HIDE]:
191. retailer_id [rr] [SHOW]:
192. retailer_id [rr] [SHOW] 4:
193. retailer_id [rr] [SHOW] 1:
194. retailer_id [rr] [SHOW] 3:
195. retailer_id [rr] [SHOW] 6:
196. retailer_id [rr] [SHOW] 7:
197. retailer_id [rr] [SHOW] 12:
198. retailer_id [rr] [SHOW] 14:
199. retailer_id [rr] [SHOW] 24:
200. retailer_id [rr] [SHOW] 25:
201. retailer_id [rr] [SHOW] 13:
202. retailer_id [rr] [SHOW] 8:
203. retailer_id [rr] [SHOW] 9:
204. retailer_id [rr] [SHOW] 10:
205. retailer_id [rr] [SHOW] 11:
206. retailer_id [rr] [SHOW] 5:
207. retailer_id [SHOW]:
208. segment_id [c] [ANCHOR] 3:
209. segment_id [c] [ANCHOR] 5:
210. segment_id [c] [ANCHOR] 7:
211. segment_id [c] [ANCHOR] 9:
212. segment_id [c] [ANCHOR] 8:
213. segment_id [c] [ANCHOR] 14:
214. segment_id [c] [ANCHOR] 16:
215. segment_id [c] [ANCHOR] 25:
216. segment_id [c] [ANCHOR] 27:
217. segment_id [c] [ANCHOR] 10:
218. segment_id [c] [ANCHOR] 11:
219. segment_id [c] [ANCHOR] 12:
220. segment_id [c] [ANCHOR] 13:
221. retailer_id [rr] [HIDE} 15:
222. retailer_id [rr] [HIDE} 19:
223. retailer_id [rr] [HIDE} 16:
224. retailer_id [rr] [HIDE} 20:
225. retailer_id [rr] [HIDE} 22:
226. retailer_id [rr] [HIDE} 23:
227. retailer_id [rr] [HIDE} 21:
228. retailer_id [rr] [HIDE} 17:
229. retailer_id [rr] [HIDE} 18:
230. retailer_id [rr] [SHOW] 15:
231. retailer_id [rr] [SHOW] 19:
232. retailer_id [rr] [SHOW] 16:
233. retailer_id [rr] [SHOW] 20:
234. retailer_id [rr] [SHOW] 22:
235. retailer_id [rr] [SHOW] 23:
236. retailer_id [rr] [SHOW] 21:
237. retailer_id [rr] [SHOW] 17:
238. retailer_id [rr] [SHOW] 18:
239. segment_id [c] [ANCHOR] 17:
240. segment_id [c] [ANCHOR] 21:
241. segment_id [c] [ANCHOR] 18:
242. segment_id [c] [ANCHOR] 22:
243. segment_id [c] [ANCHOR] 23:
244. segment_id [c] [ANCHOR] 24:
245. segment_id [c] [ANCHOR] 19:
246. segment_id [c] [ANCHOR] 20: