Design question
26/12/2017 11:47
Hi All I am restructuring a company's DB and web-based ordering system. TheDB contains separate tables for1. Users (who may or may not be customers and/or users)2. Customers (who may or may not be customers and/or users)3. Contacts (who may or may not be customers and/or users).

Part of the restructure involves enabling current customers to view/edit their orders and details online where previously only Users (whotypically staff) were able to do this.

Question: Should the redesign: a. Keep tables separate, orb. Combine the tables into a single table Note that all types may eventually become users and that separatetables are planned for roles and permissions.

Any advice welcome ThanksAdrian

Source is Usenet: comp.databases.mysql
Sign in to add a comment

Answer score: 5
26/12/2017 11:47 - So, you took on a job for which you were not qualified and expect the user community - a number of whom are IT/DB professionals - to do your job for free? My fee is $75hr for this sort of work...


Source is Usenet: comp.databases.mysql
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below