Latest ads

Pure VPN - Up to 27 Months
- vgp
- Updated: Today at 8:10 AM
එක පැකේජ් එකයි මාසෙටම Unlimited Internet. තාමත් DATA CARD දාන්න සල්ලි වියදම් කරනවද? අඩුම මිලට අපෙන්.
- sayuru bandara
- Updated: Tuesday at 12:30 PM
Ad icon
ඉන්ටර්නෙට් එකෙන් හරියටම සල්ලි හොයන්න සහ Success වෙන්න කැමතිද? 🚀 (E-Money & Success Stories)
- siri sumana
- Updated: Saturday at 11:44 PM
Gemini AI PRO 18 months Offer
- Hawaka
- Updated: May 27, 2026
Ad icon
koko account
- DasunEranga
- Updated: May 27, 2026

Reply to thread

Message: <blockquote data-quote="Lihrox" data-source="post: 17277069" data-attributes="member: 223510"><p><span style="font-size: 15px"><strong>Order</strong> table eke foreign key column 2k thiyaganin ban <strong>Main_supplier</strong> table ekata ekai  <strong>sub_supplier</strong> ekata ekai</span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px">let's say,</span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px"><strong>Order(</strong></span></p><p><span style="font-size: 15px"><strong>order_id int PRIMARY KEY,</strong></span></p><p><span style="font-size: 15px"><strong>Main_suppier string //foreign key from Main_supplier</strong></span></p><p><span style="font-size: 15px"><strong>Sub_suppier string //foreign key from Sub_supplier</strong></span></p><p><span style="font-size: 15px"><strong>)</strong></span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px">if order is from a main supplier, <strong>Sub_suppier</strong> value will be null</span></p><p><span style="font-size: 15px">if order is from a sub supplier, <strong>Main_suppier</strong> value will be null</span></p><p><span style="font-size: 15px"></span></p><p><span style="font-size: 15px">Hope this will help</span> <img src="/styles/default/xenforo/smilies/default/yes.gif"  class="smilie" loading="lazy" alt=":yes:" title="Yes    :yes:" data-shortname=":yes:" /><img src="/styles/default/xenforo/smilies/default/yes.gif"  class="smilie" loading="lazy" alt=":yes:" title="Yes    :yes:" data-shortname=":yes:" /></p></blockquote><p></p>

Verification: Asuwa dahayen wadi kalama keeyada?

Top Bottom