ER diagram of residential property management

I wonder if lz has ever heard of the concepts of master data and transaction data? The former, such as property personnel, residential tenants, companies, etc. , are generally some entities in reality. The latter is a record of the changes of these real entities, such as buying things, paying fees, moving goods, etc. , that is, the "business" that keeps happening. With this concept, ER diagram is a piece of cake.

First list the master data:

Cell information (for example, key is cell number, and attributes include cell name, address, zip code, number of households, etc. )

property management

Property personnel (the key is the number of property personnel, and the attributes include name, gender, age and responsibility area. )

Family information (the key is the house number, attributes include phone number, number of families, whether there are five good families (haha, just kidding), etc. )

Owner information (key: ID number or name, if the name is duplicate, the house number can be added after the name, etc. Attributes include address, age, ID card, telephone number, etc. )

Then the transaction data table:

Data record table, this is more flexible, I will simply write an example.

Key points: meter reading date, house number and type (such as water, electricity, gas and property fees).

Other fields: last month's meter reading, this month's meter reading, this month's consumption, unit price, to be paid, whether paid, planned final payment date, actual payment date, meter reading personnel, and whether invoiced.

In fact, if there is no meter reading for property fees, a separate table can be set up.

With the above table, it is easy to issue the following statement:

1. Owner information

2. Statistics on arrears and arrears by month, week, day, building and house number.

3. Property personnel labor appraisal form. For example, let's see when each property copied how many property tables, and whether any property was lazy for a month without reading meters.

4. You can also see if there are any households who have missed meter reading.

5. See which one likes IOUs best.

. . . . . . . Too many, think for yourself, and say whatever you want.

General property management should be enough.