Team project----Texas Hold ' em database design improved version

Because the database design experience is insufficient, and the knowledge system is imperfect, the database analysis ability is not enough, resulting in the previous version (http://www.cnblogs.com/qiangzai/p/8032833.html) design errors a lot; this time, after my deliberation, The database has been greatly adjusted, hoping to continue to improve and repair in the future learning.

The E-r chart is as follows:

this project uses MYSQL Create a database game_db, This includes four tables, each of which is a user login information table ( AccountInfo ), the User Details table ( Individual_info ), User score table ( Gamescoreinfo ) , Room Information Table ( House ) :

AccountInfo table:

Property name	Data type	Property Description
Userid	Int	User ID
GameID	Int	Game ID
Account	Varchar (45)	Player name
Password	Varchar (45)	Password
Memberorder	Int	Membership level

Individual_info table:

Property name	Data type	Property Description
Userid	Int	User ID
Really_name	Varchar (45)	real name
Sex	Varchar (10)	Gender
Qq	Varchar (45)	QQ number
Phone	Varcher (45)	Phone number
Email	Varchar (45)	e-mail address

Gamescoreinfo table:

Property name	Data type	Property Description
GameID	Int	Game ID
Houseid	Int	Room ID
Score	Int	Game Score
Wincount	Varchar (45)	Victory Bureau Number
Lostcount	Varchar (45)	Number of Lost offices
Drawcount	Varchar (45)	Number of bureaux
Runcount	Varchar (45)	Number of escape bureaus

House table:

Property name	Data type	Property Description
Houseid	Int	Room ID
Housename	Varchar (45)	Room number
Entertime	Varchar (45)	Enter time
Leavetime	Varchar (45)	Departure time

build libraries, tables, and insert data SQL statement:

CREATE SCHEMA ' game_db ';

CREATE TABLE ' game_db '. ' Accountsinfo ' (

' UserID ' INT not NULL auto_increment,

' GameID ' INT not NULL,

' Account ' VARCHAR BINARY is not NULL,

' Password ' VARCHAR BINARY NULL DEFAULT 0,

' Sex ' VARCHAR (Ten) not NULL DEFAULT ' nan ',

' Memberorder ' INT not NULL,

UNIQUE INDEX ' account_unique ' (' Account ' ASC);

SELECT * from Game_db.accountsinfo;

INSERT into ' game_db '. ' Accountsinfo ' (' UserID ', ' GameID ', ' account ', ' Password ', ' Memberorder ') VALUES (' 1 ', ' 1 ', ' liming ', ' 123 ', ' 1 ');

INSERT into ' game_db '. ' Accountsinfo ' (' UserID ', ' GameID ', ' account ', ' Password ', ' Memberorder ') VALUES (' 2 ', ' 2 ', ' Bob '), ' 111 ', ' 2 ');

INSERT into ' game_db '. ' Accountsinfo ' (' UserID ', ' GameID ', ' account ', ' Password ', ' Memberorder ') VALUES (' 3 ', ' 3 ', ' Qinagz Ai ', ' 222 ', ' 5 ');

INSERT into ' game_db '. ' Accountsinfo ' (' UserID ', ' GameID ', ' account ', ' Password ', ' Memberorder ') VALUES (' 4 ', ' 4 ', ' Jier ', ' 333 ', ' 4 ');

INSERT into ' game_db '. ' Accountsinfo ' (' UserID ', ' GameID ', ' account ', ' Password ', ' memberorder ', ' Accountsinfocol ') VALUES (' 5 ', ' 5 ', ' Lucy ', ' 1234 ', ' 7 ', ' 1 ');

CREATE TABLE ' game_db '. ' Individual_info ' (

' UserID ' INT not NULL,

' Really_name ' VARCHAR is not NULL,

' Sex ' VARCHAR (+) not NULL,

' QQ ' VARCHAR () not NULL,

' Phone ' VARCHAR is not NULL,

' Email ' VARCHAR (not NULL),

PRIMARY KEY (' UserID '));

SELECT * from Game_db.individual_info;

INSERT into ' game_db '. ' Individual_info ' (' UserID ', ' really_name ', ' QQ ', ' Sex ', ' Phone ', ' Email ') VALUES (' 1 ', ' AA ', ' 12345 677 ', ' nan ', ' 13177789865 ', ' [email protected] ');

INSERT into ' game_db '. ' Individual_info ' (' UserID ', ' really_name ', ' QQ ', ' Sex ', ' Phone ', ' Email ') VALUES (' 2 ', ' BB ', ' 12234 ", ' nan ', ' 17738724089 ', ' [email protected] ');

INSERT into ' game_db '. ' Individual_info ' (' UserID ', ' really_name ', ' QQ ', ' Sex ', ' Phone ', ' Email ') VALUES (' 3 ', ' CC ', ' 45665 654 ', ' nan ', ' 17890762354 ', ' [email protected] ');

INSERT into ' game_db '. ' Individual_info ' (' UserID ', ' really_name ', ' QQ ', ' Sex ', ' Phone ', ' Email ') VALUES (' 4 ', ' DD ', ' 34424 5345 ', ' nan ', ' 13798082376 ', ' [email protected] ');

INSERT into ' game_db '. ' Individual_info ' (' UserID ', ' really_name ', ' QQ ', ' Sex ', ' Phone ', ' Email ') VALUES (' 5 ', ' EE ', ' 56456 ", ' nan ', ' 197662762 ', ' [email protected] ');

CREATE TABLE ' game_db '. ' Gamescoreinfo ' (

' GameID ' INT not NULL auto_increment,

' Score ' INT not NULL DEFAULT 0,

' Wincount ' VARCHAR not NULL DEFAULT 0,

' Lostcount ' VARCHAR not NULL DEFAULT 0,

' Drawcount ' VARCHAR not NULL DEFAULT 0,

' Runcount ' VARCHAR not NULL DEFAULT 0,

PRIMARY KEY (' GameID '));

SELECT * from Game_db.gamescoreinfo;

INSERT into ' game_db '. ' Gamescoreinfo ' (' GameID ', ' score ', ' Wincount ', ' lostcount ', ' drawcount ', ' Runcount ') VALUES (' 1 ', ' 7 ', ' 3 ', ' 2 ', ' 4 ');

INSERT into ' game_db '. ' Gamescoreinfo ' (' GameID ', ' score ', ' Wincount ', ' lostcount ', ' drawcount ', ' Runcount ') VALUES (' 2 ', ' 7 ', ' 3 ', ' 2 ', ' 4 ');

INSERT into ' game_db '. ' Gamescoreinfo ' (' GameID ', ' score ', ' Wincount ', ' lostcount ', ' drawcount ', ' Runcount ') VALUES (' 3 ', ' 7 ', ' 3 ', ' 2 ', ' 4 ');

INSERT into ' game_db '. ' Gamescoreinfo ' (' GameID ', ' score ', ' Wincount ', ' lostcount ', ' drawcount ', ' Runcount ') VALUES (' 4 ', ' 7 ', ' 3 ', ' 2 ', ' 4 ');

INSERT into ' game_db '. ' Gamescoreinfo ' (' GameID ', ' score ', ' Wincount ', ' lostcount ', ' drawcount ', ' Runcount ') VALUES (' 5 ', ' 7 ', ' 3 ', ' 2 ', ' 4 ');

CREATE TABLE ' game_db '. ' House ' (

' Houseid ' INT not NULL auto_increment,

' Houseid ' VARCHAR is not NULL,

' Entertime ' VARCHAR not NULL DEFAULT 0,

' Leavetime ' VARCHAR is not NULL,

PRIMARY KEY (' Houseid '));

SELECT * from Game_db.house;

INSERT into ' game_db '. ' House ' (' UserID ', ' Houseid ', ' entertime ', ' Leavetime ') VALUES (' 1 ', ' 1 ', ' 12 ', ' 345 ');

You are welcome to criticize correct

Team project----Texas Hold ' em database design improved version