Household members (member) ((door number (Hno), identification number (ID), Name (Name), the people? (Nation), sex?? Don't (Sex), and the relationship with the head of the household (base))
Area (area) (((areaHno) area, area of areaName), area (areacensus) census register seat, door number (Hno), telephone (phone))
Emigration, immigration (Mone) ((number (MoneID, door number (Hno), Time (Time), moved into the beginning area (Moneregion))
Cancellation record (Logout) ((no. (LogoutID), number (Hno), time (LogoutTime), relationship with the head of the household (base), the cancellation reason (cause))
The beginning is the name of the table, want to create a table, insert table, view, stored procedure, trigger code
CodePudding user response:
Where do not ask, I know you cannot not