Now the company has a business need to make a web site, a company in website

The database is about
After user registration is divided into:
1, normal user
2, in the user
And then in the user to distinguish between
1, the company in
2, the individual in
3, the team in

Every table field in different, how to design the database,

CodePudding user response:

The create table USERS
(
Userid int primary key,
The userName varchar (1000),
.
UserType int, - 1: normal users; 2: firms; 3: personal occupancy; 4: team in
.

)

CodePudding user response:

Hello, thank you, I know how to do it, there is a problem, the userType foreign key needs to be done?

CodePudding user response:

refer to the second floor response: I am your subject

hello, thank you, I know how to do it, there is a problem, the userType foreign key needs to be done?

don't need to write such program in the enumeration of death is,