| | 34 | |
| | 35 | ===== After Normalization from Phase 5 - Tables |
| | 36 | |
| | 37 | - ADMIN ('''__admin_id__''', '''name''', '''email''', '''password''') |
| | 38 | |
| | 39 | - ARCHITECT ('''__architect_id__''', '''full_name''') |
| | 40 | |
| | 41 | - BUILDING ('''__building_id__''', '''name''', '''address''', description, '''admin_id*''') |
| | 42 | |
| | 43 | - DESIGNS ('''__architect_id*__''', '''__building_id*__''') |
| | 44 | |
| | 45 | - FLOOR ('''__floor_id__''', '''floor_number''', '''layout_image''', '''building_id*''') |
| | 46 | |
| | 47 | - UNIT ('''__unit_id__''', '''unit_number''', '''room_number''', '''floor_area''', '''status''', '''price''', image, floorplan, '''vector_image''', '''floor_id*''') |
| | 48 | |
| | 49 | - AGENT ('''__agent_id__''', '''name''', '''email''', '''password''') |
| | 50 | |
| | 51 | - CLIENT ('''__client_id__''', '''name''', '''email''', '''phone''') |
| | 52 | |
| | 53 | - TIMESLOT ('''__timeslot_id__''', '''date''', '''time_start''', '''time_end''', '''status''', '''agent_id*''') |
| | 54 | |
| | 55 | - INQUIRY ('''__inquiry_id__''', '''message''', '''status''', '''created_at''', '''unit_id*''', '''client_id*''' , '''agent_id*''') |
| | 56 | |
| | 57 | - APPOINTMENT ('''__appointment_id__''', '''status''', '''client_id*''', '''unit_id*''', '''timeslot_id*''') |
| | 58 | |
