What’s the meaning of CWD? Usually, It used in SQL Schema. like cwd_user or cwd_directory. I have seen it here Jira database schema.
Tag: database-design
How to create a calculated column in access that is based in a conditional sum of another table
It is possible in MS ACCESS 2016 to create a column in a table that is a conditional SUM of another table? Example Table 1 – Columns Table 2 – Columns Data: Table 1 Table 2 The result should be: table 1 Answer You can use a subquery:
Check the number of digits or their range
I tried to create a table for save Tradeshows and I need to save Year and Month into different columns. I have a problem with my back-end and front-end developers for check data. I need to check years is 4 number and month between 1-12. Speed is important to me. Answer Just use check constraints: Or, you coul…
What’s best practice for normalisation of DB where a domain table has an “Other” option for free text?
I’m currently in the process of normalising a database for my company and one pattern I’m seeing a lot in this database is using a domain lookup table for a value but also allowing “Other” and storing the results in a separate column. My question is just whether there is perhaps a clea…
SQL table with a column which may have “multiple types of NULL” values
The title may be confusing so I need to clarify. I have the following survey dataset that I need to transfer to a PostgreSQL database. Where -10000, -20000, and -30000 all represent a null value, but due to different reasons. (e.g., -10000 means that the participant was not shown the question about the column…
How I can update one to many relation in Postgres?
Here is my first table question. Questions have many options, so I referring every option row with question_id Now, How can I update both tables in one query? I building an API. The below-given output is for request. The request will response with question details and options for the question. I am able to up…
Why store whole records in audit tables?
I worked in several companies and in each of them audit tables have been storing full snapshots of records for every change. To my understanding it’s enough to store only changed columns to recreate record in any given point of time. It will obviously reduce storage space. Moreover I suppose it would im…
MySQL return total COUNT of each value in a column
I have a table of jobseekers with three columns Each jobseeker could have different hiring status for each employer depending on the interview. Now I want to return the COUNT of each total HIRING STATUS But it should only count the jobseeker’s highest hiring status. Say that John was ranked as QUALIFIED…
The best way to store rows of the table of a document(SQL)?
I have a report that has a table. The report also has fields. For example(JSON): { company: Company, period: “3M2019”, typeReport: “type”, multiplicity: 1000 …
Query for students passed or not passed in specific Subjects [closed]
I have a Table with Column Headings: ID Student_Name Roll_Number Subject1MarksObtained Subject1TotalMarks Subject2MarksObtained Subject2TotalMarks Subject3MarksObtained Subject3TotalMarks …