Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id | claimantID | agentID | claimantContactIndex | agentContactIndex | claimantContactID | agentContactID
- --------------------------------
- 1 | 1001 | 2001 | 2 | 0 | 0 | 0
- 2 | 1002 | NULL | 0 | NULL | 0 | 0
- id | name | address | phone | email
- --------------------------------
- 1001 | Widgets Inc. | 123 W. Main | 5550000 | [email protected]
- 1002 | Thingies LLC. | 456 W. Main | 5551111 | [email protected]
- id | name | address | phone | email
- --------------------------------
- 2001 | Simon Bros. | 789 W. Main | 5552222 | [email protected]
- id | claimantID | agentID | fn | ln | phone | email
- --------------------------------
- 3001 | 1001 | NULL | John | Doe | 5553333 | [email protected]
- 3002 | 1001 | NULL | Fred | Flynn | 5554444 | [email protected]
- 3003 | 1001 | NULL | Mike | Brown | 55555555 | [email protected]
- 3004 | 1001 | NULL | Susan | Pierce | 5556666 | [email protected]
- 3005 | NULL | 2001 | Jeff | Bridges | 5557777 | [email protected]
- 3006 | NULL | 2001 | Karry | Sinclair | 5558888 | [email protected]
- 3007 | NULL | 2001 | Steve | Green | 5559999 | [email protected]
- 3008 | NULL | 2001 | Peter | White | 5550001 | [email protected]
Advertisement
Add Comment
Please, Sign In to add comment