Mainly. 1. The user information, including name, telephone, the village, room number, area (2) from 2010 to 2019 annual payment situation 3. All the whole county area. 4 user points three categories, building users, business users, ordinary square users, should set up a few table? Bosses to give directions

CodePudding user response:

I built the table, then build 5 tables:
1. The user table: userID, name, telephone, gender, age, etc.;
Table 2. The village, village id, name of the district, the district position, etc.;
3. The house tables: housing id, cell id, head of the household (userID), building a movie theater, unit number, number, type (1: building; 2 business; Three common bungalow), building area, etc.
4. Payment: record payment id, id, payment time, payment time, last time last time JiaoFeiRen, whether to owe, owe the amount, etc.;
Table 5. Housing type: type id, category, etc

CodePudding user response:

reference 1/f, potatoes are not too familiar response:

table up, I was built 5 tables:
1. The user table: userID, name, telephone, gender, age, etc.;
Table 2. The village, village id, name of the district, the district position, etc.;
3. The house tables: housing id, cell id, head of the household (userID), building a movie theater, unit number, number, type (1: building; 2 business; Three common bungalow), building area, etc.
4. Payment: record payment id, id, payment time, payment time, last time last time JiaoFeiRen, whether to owe, owe the amount, etc.;
Table 5. Housing type: type id, category, etc.

thank you very much