All Questions
Tagged with database-design php
25
questions
0
votes
4
answers
174
views
Could you please recommend an approach on converting non-unique field to a unique field?
On our prod db we have two tables:
companies
invoices
Relationship:
A company has many invoices
An invoice belong to a company
The invoices table contains duplicate invoice_number for each company. ...
- 11
2
votes
1
answer
394
views
PHP - Dynamically apply parsing rules to text, and save to dynamic fields
OK, so I have been at this problem for the last few days, and I must admit - I am stuck.
I am trying to make a web application, where users can upload documents or send inbound e-mails.
Each ...
- 85
1
vote
1
answer
626
views
PHP - Designing a rule based parsing engine
Dynamically apply methods/"rules" to documents
I hope someone here can help me/guide me in the right direction. I am currently creating a web application, where users can import a text file, ...
- 85
8
votes
4
answers
1k
views
How are account balances persisted
I am currently building a finance application that contains "accounts"
Each account has a balance that is dynamically generated based on platform charges vs payments. e.g simplified example.
$...
- 269
0
votes
2
answers
153
views
am i asking for trouble? DB & dealing with variable item records
I feel this is so basic, but it just seems too easy and obvious and why didn't someone suggest this 10 years ago. And I know there a lot of much brighter people than me in the software dev business......
- 317
0
votes
1
answer
95
views
Server load/capacity based on data structure
Using PHP, I created a chatbox, and I used an unorthodox way of storing chat messages in MySQL.
The tbl_chat_messages has the following columns:
id | sender_id | receiver_id | message | date
The ...
1
vote
2
answers
481
views
Deliveryman's position (latitude + longitude) handling on PHP server side from Android app
The context
As a school project, I'm building a PHP and Android app for a fake company. Let's call the company "Express Food", which can talk pretty much by itself.
The "daily meals" are kept by ...
- 21
-2
votes
1
answer
228
views
Database and class design for posting user data to a website
I'm creating a small social media website, and I'm faced with a dilemma. There are 2 ways I can design my classes and database that I currently know of.
Users can make posts on the website by ...
user220498
0
votes
3
answers
1k
views
How to generate URLs for a custom URL shortener?
Due to some issues with other shorteners like goo.gl (disabling my links for example) I want to create my own URL shortener.
I am looking to have a single table that will contain the following columns ...
- 167
1
vote
2
answers
132
views
How can I maintain a database record of an entity that belongs to several categories of another entity, per year, per season, etc
I am building a kind of School Management System.
I want to be managing the database records of things like assessment, term/season, academic years. every info must belong to a particular academic ...
- 21
0
votes
1
answer
118
views
Use redundant data in database design when have multiple relation
In my web application users can submit their advertises and buy package for advertise (packages are used for priority of showing advertises)
Database schema is like this:
**Package: id, title, ...
- 1,315
4
votes
1
answer
1k
views
How should I store usernames and passwords for user login using php/cassandra?
I am new to NOSQL and Cassandra. I am not sure if I should store usernames and password in Cassandra. If I should, what is the best way to do that? I am getting lots of conflicting ideas from research....
- 49
3
votes
0
answers
535
views
PHP Vertical Columns from 3 SQL Tables
I work at a high needs school in which there are several classes that plan their work through Excel spread sheets grading and tracking student progress. We have come to the conclusion that this ...
2
votes
1
answer
794
views
Handling insertion to database with Repository pattern
I have a design question for working with databases in object-oriented PHP.
I have a table in my database called products. Then I have 2 classes for this table in my PHP project. ProductsRepository....
- 173
2
votes
1
answer
138
views
What should be the structure of a person to person store database?
I am going to create a person to person store with Laravel, a website where its users can share and sell their product or their mobile, TV, Computer, Shoes, Shirts, Books, Cars, Bags, Animal, etc.
I ...
- 121