Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 124279

The development of the conceptual schema and/or the logical model and/or the physical settings of a database.

0
votes
1answer
Product id name price Tax id name rate Product_Tax Product.id Tax.id effective date expiry date Is this a good design? How to store Products that are tax-exempted? Also, how to handle the …
asked Jun 17 by j10
2
votes
1answer
We are building a system with concept of Admin and Employee. so basically Admin is an employee with all powers and can view all the data created by other Employee. CREATE TABLE `Vendor` ( `vendor_I …
asked Dec 19 '17 by j10
-1
votes
2answers
We need to design Tax table for Billing System. Lets say we have a SGST (State Tax) and CGST(Central Tax) and Final Intra-State Tax = SGST + CGST Tax table id name rate Tax table id | name …
asked Jun 17 by j10
0
votes
3answers
We have an entity called Task which has properties like id, vendor id, name. So I created the following table to represent it: CREATE TABLE `Task` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, …
asked May 21 by j10
2
votes
2answers
We are using MySQL 8.0 and need to implement Schemaless Feature where we allow Vendors to create a Module(ObjectName) and add columns(int, string, currency) to it. Vendor can add objects after definin …
asked May 3 by j10
0
votes
Sorry, had to post this as Answer due to the length of the comment. That link was very helpful. Thank you Rick. From the website "The solution uses one table for all the EAV stuff. The columns inclu …
answered May 6 by j10