Fictional Stark Industries datasets for database and programming projects.
- Stark Ind Silver Data Model to see the current data model draft on dbdiagram.io
.png){kind=link}
| Content | Database Scripts | Dataset & Data Dictionary | General Description |
|---|---|---|---|
Organization |
org_master | Org | Org data table using UUIDs as well as status & type tables to differentiate between Stark Industries subsidiary companies and external orgs. Includes SQL trigger to track org_master table changes. |
Account |
account_master | Account | Account data table with UUIDs as well as 'account_status' & 'account_type' tables. Includes SQL trigger to track 'account_master' row updates via the 'account_hist' table. |
Product |
product_master | Product | Product data table with UUIDs as well as 'product_status' & 'product_type' tables. Includes SQL trigger to track product_master data changes. |
Person |
person_master | Person | Person data table uses UUIDs and links to the 'contact_master' data table where org, account, and location relationship information can be accessed. |
Employee |
employee_master | Employee | Employee data table uses UUIDs and links to the 'person_master' data table where org, account, and person relationship information can be accessed. |
User |
user_master | User (In progress) | User data table links to the 'contact_master' data table where user is keyed to org, account, and person relationship information. |
Contact |
contact_master | Contact (In progress) | Contact data table with UUIDs as well as 'status' 'type' tables. Includes SQL trigger to track account table changes. |
Order |
order | Order | Order data table with UUIDs as well as 'order_status' & 'order_type' tables. Includes SQL trigger to track 'order' row-level table updates. |
Order Details |
order_details | Order Details | Order Details table keyed to order table. Includes SQL trigger to track 'order_details' table changes. |
Location |
location_master | Location | Location data table uses UUIDs and links to the 'address_master' data table where location and address relationship information can be accessed. |
Price |
price | Price (In progress) | Pricing data table including SQL trigger to track product pricing updates and changes. |
Price History |
price_hist | Price history (In progress) | Price History data table with SQL trigger to track historical updates to product prices. |
Logistics |
logistics | Logistics & shipping information (In progress) | Shipping & order fulfillment data table. |
Settlement |
settlement | Settlement & transaction information (In progress) | Transaction settlement data table. |