Stack Overflow
Stack Overflow

Questions tagged [db-structure]

7 questions
1
vote
4 answers

Store deleted rows in a table

Is it a good practice to have an is_deleted column in a SQL Server table or there's another way of dealing with this question? Another solution I can think of is to delete that row and inserting it to another table for deleted rows. What's the best…
hgulyan
  • 8,099
  • 8
  • 50
  • 75
1
vote
1 answer

How can I view structure and foreign keys of a classic HyperFileSQL database?

I have a classic HyperfileSQL database which I need to convert (.FIC files) I'm trying to get some overview of the structures and keys in the database. So I downloaded WinDev Express, and I got the 'HyperFileSQL Control Center' now. With this tool,…
Erik Dekker
  • 2,395
  • 5
  • 33
  • 55
0
votes
0 answers

Appropriate implementation of Graph Tables structure for efficient querying trees under given node in SQL Server

I need to insert tree structured data into my database. Lets say for now as an example that the tree has n levels and I have a Node table called T_Node with a column called 'name' (the amount of columns might grow later) and an Edge table called…
Laureano Bonilla
  • 335
  • 3
  • 18
0
votes
1 answer

database convertor

I have table with many data and also I have new structure in other database and system. Is there any program to convert database to new structure? This program must read structure of both of them and then ask me which field fill which field in new…
Mohammad Efazati
  • 4,812
  • 2
  • 35
  • 50
0
votes
1 answer

Correct MySQL DB Structure

I'm developing a web administration panel for a local restaurant directory. Their old system is very clunky and not able to expand without modifying a bunch of code. The current DB structure is like this: table: Restaurants cols: id, restname,…
Logan
  • 3
  • 1
0
votes
3 answers

DB Structure for a shopping cart

I like to develop a shopping cart website with multiple products. (ex.: mobile phone, furniture etc.,) here mobile phone specification will cover size of display memory operating system camera etc., but for furniture - its specification is…
Sensa
  • 383
  • 3
  • 6
  • 20
0
votes
1 answer

Design DB Structure for Mail Scheduling

I need to design Database structure to mail report scheduling. As far till now,I came forward with this design as follows: **ReportSchedule** - ScheduleId - ReportName - Subject - To - UserId - Body -…
xTMNTxRaphaelx
  • 1,387
  • 3
  • 11
  • 14