officener

Tables (5)

building (건물)

  • id (Key) — Primary key — NOT NULL

room (세대)

  • id (Key) — Foreign key → tenant.id — NOT NULL
  • id (Key2) — Foreign key → building.id — NOT NULL
  • id (Key22) — Foreign key → tenant.id — NOT NULL
  • id (Key222) — Foreign key → tenant.id — NOT NULL
  • id (Key2222) — Foreign key → tenant.id — NOT NULL
  • id (Key3) — Foreign key → tenant.id — NOT NULL

roomPublic (공용시설)

  • id (Key) — Foreign key → building.id — NOT NULL

schedule (예약)

  • id (Key) — Foreign key → roomPublic.id — NOT NULL
  • id (Key2) — Foreign key → tenant.id — NOT NULL
  • id (Key22) — Foreign key → tenant.id — NOT NULL
  • id (Key3) — Foreign key → building.id — NOT NULL

tenant (입주사)

  • id (Key) — Foreign key → building.id — NOT NULL
  • id (Key2) — Foreign key → schedule.id — NOT NULL
  • id (Key22) — Foreign key → schedule.id — NOT NULL
  • id (Key222) — Foreign key → schedule.id — NOT NULL
  • id (Key3) — Foreign key → schedule.id — NOT NULL