T1

Tables (3)

AptInfo

  • buildingNum (buildingNumber) — Long — Primary key — NOT NULL
  • aptName — String

Resident

  • unitNum — Long — Primary key — NOT NULL
  • statusMsg — String
  • buildingNum (buildingNumber) — Long — Foreign key → AptInfo.buildingNum — NOT NULL
  • stoneId — Long — Foreign key → myStone.stoneId — NOT NULL

myStone

  • stoneId — Long — Primary key — NOT NULL
  • stoneFace — Long
  • stoneColor — Long
  • stoneOutline — Long
  • stoneState (Field) — Long