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