Order table eke foreign key column 2k thiyaganin ban Main_supplier table ekata ekai sub_supplier ekata ekai
let's say,
Order(
order_id int PRIMARY KEY,
Main_suppier string //foreign key from Main_supplier
Sub_suppier string //foreign key from Sub_supplier
)
if order is from a main supplier...