Database schema: describes the structure of the information within a database system. The schema is formalized using integrity constraints, which may be expressed as a series of sentences to describe the data, structure of the database and properties of the database.
0
votes
0answers
6 views
General table name for Person Inf [migrated]
I was in a meeting with my boss and technical support leader and they asked me for a database model to a very simple application. That application requires: employees information, some location data, ...
1
vote
1answer
95 views
Database schema suggestions for a Minecraft logging plugin
This is my attempt at creating a database schema for a Minecraft logging plugin. I'm by no means a SQL expert, so suggestions would be greatly appreciated.
--
-- Table structure for table `actions`
...
5
votes
1answer
311 views
MySQL one-to-many relationship - is this the right way?
I'm currently working on a logfile parser for a pretty old videogame called 'Team Fortress Classic' which can be compared to Counter-Strike 1.6 and is available on Valve's Steam platform.
I started ...
2
votes
3answers
62 views
Is this a good schema to allow adding tags to entities in unrelated tables
I'm implementing a "tags" features to an already working solution.
Final users need to be able to add tags to three separate sections of the solution:
Posts, Accounts, and Groups
Each section has ...
1
vote
1answer
590 views
A database schema for an online rental store [closed]
I am creating an online rental store using the following:
JSF 2.1
Hibernate 4.2
Spring 3.2
MySQL 5.5
Below is my database schema design:
Link in case image not displayed.
The rental user has ...
2
votes
1answer
178 views
Keeping track of people's relationships in MySQL using a people relation table?
I am trying to track relationships among people. I came up with my own solution, but wondering if there might be another way or better way of doing this. To keep it simplified, I'll post just the bare ...
1
vote
0answers
63 views
Python MongoDB Schema feedback
I would dearly love some feedback on the model below. Its a basic commenting structure where Users can comment on a variety of objects in the model. I have denormalised to make querying simpler, but ...
2
votes
2answers
299 views
My database schema [closed]
I'm not sure if this would be okay to put here since it doesn't have code to look at, but this is my database I'm trying to create for an online firearm store. I'm new to database design and ...
10
votes
3answers
149 views
Object database schema, should i split my tables?
I have a database schema for a game to hold save files where some tables have a one-to-one relationship to Classes. And i was wondering if i should split up some tables.
Example troop_class table. It ...
3
votes
1answer
574 views
Schema for Google Docs-like Sharing
I want to allow users to share documents (and other stuff) in a database-driven application.
I have designed the following schema to allow for this (postgresql). Some of the tables like Party are ...
3
votes
2answers
255 views
A database schema for articles and their revisions [closed]
I'm designing a super simple web application for creating articles. All articles on this site can be edited by different people and each edit is a revision. Using an RDBMS, this is my schema:
...
2
votes
1answer
231 views
Database Design Review [closed]
I'm trying to design a database structure that could be used to store information on any topic. I know that a wiki does this but I'm looking for a more structured way to store the information so I ...
3
votes
3answers
388 views
How could I improve my database schema?
I'm a student and I've created this MySQL database schema for my Service Order Management academic project and I want to know if I need to improve it and, if so, how I could do that.
Thanks for your ...
1
vote
2answers
871 views
review ERD for website [closed]
I am a noob and would like some help with the erd for a website I am building.
There are roles for the users that participate in the board. I'm not sure I have that down correctly.
I realize that I ...
3
votes
2answers
330 views
Creating contact tables [closed]
I have a module in my college project for managing Contacts.
I'm confused on how to design the contact table.
One contact can have multiple email, mobile, website addresses.
So I have created two ...
4
votes
5answers
2k views
Database schema for a school
Here is the database query needed to create the database:
create table Area
(
AreaId int primary key identity(1,1),
Name nvarchar(64) not null
)
create table Level
(
LevelId int primary key ...
