Internal Data

Sheet1

Group	Table	Field	Data Type	Example
Customers	customers	customer_id		U123456
Customers	customers	user_id	character
Customers	customers	create_date		2022-10-24
Customers	customers	segment_id	character	SG123456 : What's this? Is there a list of types or categories? -Joseph Borjon
Employees	human_resources	employee_id	integer	450339
Employees	human_resources	user_id		273245
Employees	human_resources	start_date	date	2020-07-09
Employees	human_resources	end_date		2021-07-09
Employees	human_resources	role	character	Software engineer
Employees	human_resources	hourly_wage	numeric	36.5
Employees	human_resources	salary_wage	numeric	85000.25
Employees	human_resources	bonus_cap	numeric	150.6
Employees	human_resources	turnover_reason	character	Discharged
Products	products	product_id	character	PR123456
Products	products	product_name		Journey Messenger
Products	products	product_category	character	Duffel
Products	products	product_subcategory	character	Women's tote
Products	products	list_price		34.99
Accounting	expenses	expense_id	character	E123456
Accounting	expenses	name		Backpack order
Accounting	expenses	expense_type		inventory
Accounting	expenses	expense_date		2021-09-19
Accounting	expenses	expense_amount	numeric	56.48
Accounting	expenses	user_id	character	U123456
Sales	orders	order_id	character	OR123456
Sales	orders	customer_id	character	C123456
Sales	orders	delivery_id	character	DL123456
Sales	orders	order_total_revenue		500.06
Sales	orders	shipping_cost	numeric	32.23
Sales	orders	order_discount_rate	numeric	10.15
Sales	orders	order_date		2023-03-20
Marketing	engagements	engagement_id		EG123456
Marketing	engagements	customer_id	character	C123456
Marketing	engagements	order_id	character	OR123456
Marketing	engagements	campaign_id	character	CP123456
Marketing	engagements	subscription_id	character	SB123456
Marketing	engagements	customer_segment_id	character	SG123456
Marketing	engagements	send_date	date	2021-01-23
Marketing	engagements	country	character	Canada
Marketing	engagements	opens	integer	23406
Marketing	engagements	clicks		512
Marketing	engagements	conversions	integer	42
Marketing	engagements	likes	integer	1258
Marketing	engagements	shares	integer	647
Marketing	engagements	comments	integer	323
Marketing	engagements	revenue		1280.55