ang3lus
asked on
Data Base model
Hi
I want to store and retrieve data. The data represent invoice that has may simple item or complex item. The invoice may have an undetermined number of items.
E.g.
Invoice 1
Item 1
Item 1.1
Item 1.1.1
Item 1.2
Item 2
Item 3
What is the best way to design such data base. I think about recursive table but iam not sure if that's right.
Thanks.
I want to store and retrieve data. The data represent invoice that has may simple item or complex item. The invoice may have an undetermined number of items.
E.g.
Invoice 1
Item 1
Item 1.1
Item 1.1.1
Item 1.2
Item 2
Item 3
What is the best way to design such data base. I think about recursive table but iam not sure if that's right.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.