AnsweredAssumed Answered

Building your tables

Question asked by stereodb on Dec 9, 2017
Latest reply on Dec 13, 2017 by philmodjunk

Hello Board,

 

This might be a very stupid question, but it's been slowing my process for a while now.

 

Here I have two tables : (same name == same property)

TABLE A

_pk

Property_1

Property_2

Property_3

Property_A

Property_B

 

TABLE B

_fkA_item

Property_1

Property_2

Property_3

 

The main difference is that I can put B_Items in A_items. That gives A_items a few more attributes that should not be allowed to B_items.

Is two table really the way to go with such similar tables or is there a better way to structure my db? (Thinking about the employee manager example)

 

Thanks,

Outcomes