BBD_erd

Tables (6)

guardian_user

  • guardian_user_id — INT — Primary key — NOT NULL — Primary Key
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • user_id (guardian_id) — int — Foreign key → user.user_id — NOT NULL

hospital

  • hospital_id — int — Primary key — NOT NULL — Primary Key
  • hospital_name — varchar(50) — NOT NULL
  • hospital_phone — varchar(20) — NOT NULL
  • hospital_type — varchar(50) — NOT NULL
  • hospital_address — varchar(100) — NOT NULL
  • hospital_centerLat — float — NOT NULL
  • hospital_centerLon — float — NOT NULL
  • visits_count — int
  • user_id — int — Foreign key → user.user_id — NOT NULL — Primary Key

result_messages

  • id — int — Primary key — NOT NULL — Primary Key
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • result — varchar(10) — NOT NULL
  • message — varchar(10) — NOT NULL
  • audio_data — varchar(50) — NOT NULL

schedule

  • schedule_id — int — Primary key — NOT NULL — Primary Key
  • schedule_name — varchar(50) — NOT NULL
  • schedule_start_time — datetime — NOT NULL
  • schedule_description — text
  • user_id — int — Foreign key → user.user_id — NOT NULL — Primary Key

taxi

  • taxi_id — int — Primary key — NOT NULL — Primary Key
  • taxi_phone — varchar(20) — NOT NULL
  • taxi_location — varchar(50) — NOT NULL
  • taxi_type — tinyint(1) — NOT NULL

user

  • user_id — int — Primary key — NOT NULL — Primary Key
  • user_name — varchar(20) — NOT NULL
  • user_type — tinyint(1) — NOT NULL
  • user_tts — tinyint(1) — NOT NULL