Questions tagged [schema]
The schema tag has no summary.
87 questions
2 votes
2 answers
196 views
Proving two XML schema's are functionally equivalent
I work for a standards organization that publishes an exchange standard using XSD files. These XSD files are being generated from a model with a tool, and now we want to change to a new tool. Because ...
- 154
1 vote
1 answer
100 views
Efficient Schema For Pairing Styling Metadata with Text Fields in JSON Messages
I am trying to design a schema for pairing styling data with text. However, I need it to pair styling metadata to only one part of a larger string. For example: "This is a test string" I ...
- 143
-2 votes
2 answers
232 views
Avoid redundant field using JSON type in MySQL [closed]
I have experienc with designing relational dbs but first time attempting to store JSON in a mysql table. I am using mysql 5.7.8 which has the ability to store json data type as a column. When I create ...
- 139
0 votes
2 answers
81 views
In a database schema, should frequently changed information be isolated from static information?
A contrived example: I have many Thimbles, identified in real-life by their color, that I lend out to friends. I want to know only the most recent friend that is wearing my Thimble. My friends covet ...
- 41
0 votes
1 answer
72 views
What is the schema to specify relationships in a flat-document structure?
I have a question about the best database schema to do this. So, we want our database schema to carry out some generic operation <> involving two units of data, x1 and x2 (e.g. a1). // CURRENT ...
- 587
-2 votes
1 answer
763 views
Converting a table to an ORM schema
I'm trying to convert this table into an ORM schema: The solution given by the book is this one: It connects all the paramether to the Member one. This is my solution, which I think it's less ...
1 vote
2 answers
173 views
Which REST API url structure should I take?
I am wondering which API url scheme should I use. I am designing multi-site project so that the URL can looks like: [GET] /website/1 [GET] /website/1/category [GET] /website/1/product Which is life ...
1 vote
8 answers
1k views
Is there a way to prevent developers leaking data while they are developing?
I am working with a startup company for a while now. They have been affected by some reckless developers in the past. One area they want a real and immediate improvement is when they assign a task to ...
- 127