Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
XML to DB
<company>
<building address="123 Main Street">Main</building>
<legal name="Main Street productions"/>
<org>
<manager empID=456>Bob Smith</manager>
<employee empID=987>Margie Jones</employee>
<employee empID=721 role="SysAdmin">John Johnson</employee>
</manager>
</org>
</company>
/**
DB tables:
Company
company_pk
Building
building_pk
company_fk
address
text
Legal
legal_pk
company_fk
name
Org
org_pk
company_fk
Manager
manager_pk
org_fk
emp_id
text
Employee
employee_pk
manager_fk
emp_id
role
text
**/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.