Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 3062 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I am starting a new DB and pondering the schema. In a past project I had various company types that required their own section but I had a parent table called company which would hold basically the company name. so:

company: company_name, id 
- agency: [ separate table, agency details ]
- client:  [ separate table, client details ]
- vendor:  [ separate table, vendor details ]

I also did the same for contacts:

profile: first_name, last_name, id
- contact:  [ separate table, contact details ]
- talent:  [ separate table, talent details ]

The new project has similar requirements and  I am wondering if I should normalize it further and merge company into profile. A major benefit is searching a single table and having it return all contact and company but I am wondering if this is straying form best practice or if you can foresee   any downside.

 

This topic is 3062 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.