## Law_Firms

id | name | address | website
--- | --- | --- | ---
1 | Ackerman Abramovitz | 6789 Central Ave., Suite 300, Dallas, TX 75206 | http://www.ackermannlawyers.com
2 | Baker & McKenzie | 1 North LaSalle Street, Chicago, IL 60601-1684 | https://www.bakermckenzie.com/
3 | Mayer Brown | 122 West Washington St., Chicago, IL 60602 | https://www.mayerbrown.com
4 | Skadden, Arps, Slate, Meagher & Flom LLP | One Manhattanville Rd., Purchase, NY 10577 | https://www.skadden.com
5 | DLA Piper | Three Embarcadero Center, San Francisco, CA 94111 | https://www.dlapiper.com

## Legal_Positions

id | position_name | required_experience
--- | --- | ---
1 | Paralegal | 1 year
2 | Associate Attorney | 3 years
3 | Partner | 5 years
4 | Of Counsel | 7 years
5 | Contract Attorney | 2 years

## Law_Firm_Job_Postings

id | job_title | posted_date | application_deadline | description | salary
--- | --- | --- | --- | --- | ---
1 | Corporate Paralegal | 2022-01-01 | 2022-01-15 | Assist attorneys in preparing documents for corporate transactions. | 55000
2 | Real Estate Associate Attorney | 2022-02-01 | 2022-02-15 | Represent clients in real estate transactions. | 75000
3 | Commercial Litigation Partner | 2022-03-01 | 2022-03-15 | Lead a team in handling commercial litigation cases. | 150000
4 | Tax Of Counsel | 2022-04-01 | 2022-04-15 | Advise on tax matters and represent clients before tax authorities. | 100000
5 | Patent Contract Attorney | 2022-05-01 | 2022-05-15 | Prepare and review patent applications for clients. | 85000

## Law_Firms_Legal_Positions

firm_id | position_id
--- | ---
(→ Law_Firms.id) | (→ Legal_Positions.id)
1 | 1
1 | 2
2 | 1
2 | 2
3 | 1
3 | 2
4 | 1
4 | 2
5 | 1