Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Loading…

Database Design #2

Open
MisterPhilip opened this Issue · 12 comments

6 participants

@MisterPhilip

Need to finalize the database design for all specifications. I do believe Ignace has started on some of this on the development forums for one of the specs. However, we'll need to do this for all of the specifications.

@ignace ignace was assigned
@MisterPhilip

@ignace - do you think it makes sense to continue on this while @trq works on the view stuff for proem?

@trq
Owner

@misterphilip, we need to catch up in irc. I'm really starting to think we might need to go down a different path.

I seriously have no time on my hands at the moment after going back to work.

@philip

Wrong @philip, I think you mean @MisterPhilip ... I received an email and wondered "What did I agree to do this time?" :)

@gizmola
Owner
@MisterPhilip

Ha, sorry @Philip - too many of us Philip's in the world ;)

@trq - yeah, if we need to switch back to sf2, that's fine. I know @gizmola would be happy.

@MisterPhilip

Okay, just talked with @trq. We'll use sf2 for the project now, since he might not have enough time to work on proem for our uses.

@gizmola
Owner
@trq
Owner
@premiso

Ok, so it seems we need to figure out a naming strategy.

http://docs.doctrine-project.org/en/latest/reference/namingstrategy.html

I put in a vote for the _'s where necessary and all lowercase names.

As far as the primary ID, I prefer it to just be id, but we just need to figure out having it as table_id or just id. Voice your opinion, and once we have the basic naming strategy laid out, we can more effectively work on creating the structures.

@MisterPhilip

I'm used to running it as table_id, but I'm fine with not here. As long as any FK's have the table name in front of them, I'm fine with it. (see example below)

user
-------------
id
name
article
-------------
id
name
user_id (references user.id)
@premiso

I would like to adhere to some standard but I am finding it hard to locate a decent SQL writing standard that people use.

So yea, let's go with id for the primary key and then any foreign keys need the table_id. Unless there is a valid argument and or an actual document we can go by and adhere to, that is what we will stick to.

@MisterPhilip

Bump to see if anyone has had time to make any progress on this...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.