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)