#1
Tables (5)
Agent (Untitled3)
- ID (Key) — Primary key — NOT NULL
- Name (Field)
- OfficeID (Field2)
- PhoneNumber (Field3)
Buyer (CopyOfUntitled)
- BuyerID (Field9)
- BuyerName (Field)
- BuyerSSN (Field2)
- Address (Field3)
- PhoneNumber (Field4)
- SpouseName (Field7)
- SpouseSSN (Field8)
- Bathrooms (Field5)
- Bedrooms (Field6)
Home (Untitled)
- ID (Key2) — Foreign key → Agent.ID — NOT NULL
- Address (Field)
- City (Field2)
- State (Field3)
- ZipCode (Field4)
- Bathrooms (Field5)
- Bedrooms (Field6)
- SquareFeet (Field7)
- Type (Field8)
Office (Untitled4)
- ID (Key) — Foreign key → Agent.ID — NOT NULL
- PhoneNumber (Field)
- ManagerName (Field2)
- Address (Field3)
Owner (Untitled2)
- Social Security Number (Key) — Primary key — NOT NULL
- Name (Field)
- SpouseName (Field2)
- Profession (Field3)
- Spouse Profession (Field4)