13 questions
How do I use RDB and key-value DB differently?Personally, I understand the difference between whether or not you can create an index later, but is this correct?
Until now, when creating table definitions, after modifying, adding, and deleting tables in the database, Windows automatically generated them using the A5 SQL feature (↓)DB client:A5 SQL automatic ta...
I've been designing DB tables so far, and I always get lost.It's about whether the name should be on the transaction table.Generally, it is good to code names and manage them centrally in a master tab...
I'd like to know the best design practice when you want RDB to filter a table under multiple conditions (including AND/OR).For example, table name:sample_tableSchema: - id integer - name varchar - co...
I'd like to create a membership-based learning support site with cakephp 2.7, but I don't know exactly what kind of table I should design.First of all, since it is a membership system, the username an...
We create applications that mimic EC sites.I would like to normalize the product table.Currently, the table configuration is as follows.1 id2. Product name3. List Price4. Number of stocks5 Date of arr...
I'm worried about how to design the RDB column.How should I design it if there is a possibility of multiple elements in a single column?For example, you want to design a table containing watari, wani,...
The same system currently runs as multiple separate sites.How it works is the apache+tomcat+postgres web service.if you decide to consolidate these multiple sites into one siteIf you want to lump mult...
DB designs that do not impose NOT NULL constraints on flag items such as enable and delete flags are common.According to the specification, Please treat 0 and NULL in the same sense, but is there any ...
I'm worried about drawing a line between what DB should have as a master and what source code should define as a Const list.Personally, if the user does not edit from the master management screen, I t...
| - 1 - | » |
© 2024 OneMinuteCode. All rights reserved.