Need database model for a game

I need a database model for an online game:

The game should save the characters which have more or less this type of character file:

[url removed, login to view]

Every player has:

-a username, password and a bunch of ints/strings

-a container "inventory" which holds "items(id & amount)" in a certain slot

-a container "bank" which also holds items

-a container "equipment" which also holds items

-a friendslist which holds longs (64 bit integers which can be converted to usernames)

-skills which are specified with an "id"(int) and "experience"(int)

My current idea was to use the following tables:







all containers would look something like

id | amount | slot | owner_id

every player should have its own "id" which would be auto-incremented

but I'm not exactly sure how the primary keys & foreign keys system works in MySQL and I'd prefer to have some professional help instead of trying to figure out things on my own

Habilidades: MySQL, SQL

Veja mais: sql inventory system, online figure model, bank id type, game model, game auto, d slot, d model, d model of something, d model and a, d container, character figure, Game slot, certain strings, game password, model figure, mysql online game, bank database, auto pastebin, inventory system database, game online mysql, mysql bank database, model characters, inventory sql, sql database skills, model container

Acerca do Empregador:
( 3 comentários ) Gent, Belgium

ID do Projeto: #6828962

16 freelancers are bidding on average $19/hour for this job


Hi there, i'm expert on database modelling including writing ERD, implementation... I saw you were stucked with some PK and FK, actually i need to know more about the business rules to figure out the relation, PK and F Mais

$18 USD / hora
(82 Comentários)

Hello, sir. I have enough experience in db design. And I have managed Online Game DB. I can help you. Thanks. Regards.

$21 USD / hora
(6 Comentários)

Thank you for considering me. You seem to have a nice, structured arrangement in mind already. One of the things that would be helpful for me to know is how you plan on using the data. For example: Is it to capt Mais

$15 USD / hora
(2 Comentários)

Hello, im a developer from venezuela, i have very good experience with databases and games :). You can take a look at my feedbacks and let me know if you are interested. Jose Luis Mendoza. Software Eng.

$17 USD / hora
(3 Comentários)

Dear Sir, I reviewed your job requirement carefully and then understand what you want. I can make Database schema for game as you want. In terms of Database management skills, please check this job history. Mais

$28 USD / hora
(2 Comentários)

Good Evening Sir, Here is Michele Cimmino from Italy I'm the owner of an individual software firm. I started to develop for the web when I was only 15 years old. 10 years later, the way to code is significantly cha Mais

$25 USD / hora
(1 Comentário)

I'm a professional SQL developer. If you hire me, I can start right away. Let me know and I'll start working on this as soon as posible. Looking forward on hearing from you. Thanks.

$15 USD / hora
(0 Comentários)

Hello, you need to build up database which is not so big, that it will be in the end so slow ... I know how to do it. Contact me and we can do it together. Setting up relations between tables will be needed. Mais

$15 USD / hora
(0 Comentários)

I have many years of database design experience and would be more than happy to complete this task for you.

$27 USD / hora
(0 Comentários)

Aucune proposition n'a encore été fournie.

$15 USD / hora
(0 Comentários)

I can make your database in four days, I have a semi-ready code ... tell me how I can help ... talk to me for me to better understand your project my games [url removed, login to view] Mais

$33 USD / hora
(0 Comentários)

I have about 16 years experince in dB designing and I always try my best to make efficient programs. I read your RFP and your idea about design but it seems we can make it [url removed, login to view]'t worry about money your satisfact Mais

$16 USD / hora
(0 Comentários)

Hi sir, How do you do? I am a web expert. I have read your job post. I understand what you want. I think that this is not difficult for me. No problem for me! I have rich experiences in DB management for 6 year Mais

$36 USD / hora
(0 Comentários)

Hi, I am new to freelancer bidding, but very familar with online game development. I have created several CCG games in flash on the platform kongregate.com. I can advise you here. The key thing to make everything Mais

$20 USD / hora
(0 Comentários)

Dear Hiring Manager, I have 2 years experience on Database. I am expert on SQL. So no problem any SQL. Select,insert, update,Join, inner join etc. I can make it easily. Thank you for this wonderful opportunity. Mais

$22 USD / hora
(0 Comentários)

Let me help you with the model, i can do it for you!!! I already made many databases to diverse information systems to commerce and industry

$17 USD / hora
(0 Comentários)

I finish this work for 6 hours. Because of the db schema is basic for me and my expertise areas. I want this project.

$16 USD / hora
(0 Comentários)

If you have doubt only for MySQL statements and you have the ER model, this can be done in less time that i asked for. But if i have need to make the tables model or fix some in your model, then i will need the 20 hour Mais

$16 USD / hora
(0 Comentários)