jnuMapERD

Tables (5)

Facility (Untitled3)

  • facility_id (Key) — Primary key — NOT NULL
  • floor_id (Key2) — Primary key — NOT NULL
  • facility_type_id (Key3) — Primary key — NOT NULL
  • floor_id (Key4) — Foreign key → Floor.floor_id — NOT NULL
  • name (Field)
  • lat (Field2)
  • lng (Field3)

FacilityType (Untitled5)

  • facility_type_id (Key) — Primary key — NOT NULL
  • facility_id (Key2) — Foreign key → Facility.facility_id — NOT NULL
  • type_name (Field)

Floor (Untitled2)

  • floor_id (Key) — Primary key — NOT NULL
  • building_id (Key2) — Primary key — NOT NULL
  • floor_number (Field)
  • map_image (Field2)

Room (Untitled4)

  • room_id (Key) — Primary key — NOT NULL
  • floor_id (Key2) — Primary key — NOT NULL
  • floor_id (Key3) — Foreign key → Floor.floor_id — NOT NULL
  • name (Field)
  • lat (Field2)

building (Untitled)

  • building_id (Key22) — Foreign key → Floor.building_id — NOT NULL
  • name (Field)
  • adress (Field2)