This will result in a "patient_addresses" table that looks like this:
patient_id | street | use | city | zip |
---|---|---|---|---|
1 | 123 Main St\nApt 1 | home | San Diego | 92101 |
1 | 456 Maplewood Dve\nApt 2 | work | New York | 10001 |
2 | 789 Brookside Ave\nApt 3 | home | Los Angeles | 90001 |
3 | 987 Pinehurst Rd\nApt 4 | home | Chicago | 60601 |
3 | 654 Evergreen Tce\nApt 5 | work | Houston | 77001 |
{:.table-data} |