q

Tables (8)

BUILDING (building)

  • building_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • building_name (Field) — VARCHAR2(50)
  • description (Field2) — VARCHAR2(200)

LOCATION (location)

  • location_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • room_name (Field) — VARCHAR2(50)
  • floor_name (Field2) — NUMBER(2)
  • location_type (Field3) — VARCHAR2(30)
  • building_id (Key2) — NUMBER(10) — Foreign key → BUILDING.building_id — NOT NULL

ROBOT (robot)

  • robot_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • robot_name (Field) — VARCHAR2(50)
  • status (Field2) — VARCHAR2(20)
  • current_location (Field3)
  • route_id (Key2) — NUMBER(10) — Foreign key → ROUTE.route_id — NOT NULL

ROUTE (Untitled)

  • route_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • start_location (Field) — VARCHAR2(50)
  • destination (Field2) — VARCHAR2(50)
  • distance (Field3) — NUMBER(5,2)
  • estimated_time (Field4)

ROUTE_REQUEST (Untitled3)

  • request_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • request_time (Field3) — DATE
  • user_id (Key2) — NUMBER(10) — Foreign key → USERs.user_id — NOT NULL
  • route_id (Key3) — NUMBER(10) — Foreign key → ROUTE.route_id — NOT NULL

SERCH_HISTORY (Untitled2)

  • serch_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • serch_time (Field3) — DATE
  • user_id (Key2) — NUMBER(10) — Foreign key → USERs.user_id — NOT NULL
  • location_id (Key3) — NUMBER(10) — Foreign key → LOCATION.location_id — NOT NULL

USERs (Users)

  • user_id (Key) — NUMBER(10) — Primary key — NOT NULL
  • student_id (Field) — VARCHAR2(20)
  • name (Field2) — VARCHAR2(50)
  • email (Field3) — VARCHAR2(100)
  • role_num (Key2) — number(2) — Foreign key → role.role_num — NOT NULL

role

  • role_num (Key) — number(2) — Primary key — NOT NULL
  • role_name (Field) — varchar2(50)