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)