GAE

Tables (7)

Daily_report (daily_report)

  • report_id — BIGINT — Primary key — NOT NULL
  • report_date — DATE
  • walk_time_min — INTEGER
  • danger_count — INTEGER
  • safety_score — INTEGER
  • summary_text — TEXT
  • main_image_url — VARCHAR(500)
  • created_at — TIMESTAMP
  • serial_no — VARCHAR(50) — Foreign key → Robot.serial_no — NOT NULL

Guardian (guardian)

  • guardian_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • phone_number — VARCHAR(20)
  • relationship — VARCHAR(20)
  • priority — INTEGER
  • member_id — BIGINT — Foreign key → Member.id — NOT NULL

Member (member)

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(50)
  • phone_number — VARCHAR(20)
  • role — VARCHAR(20)
  • created_at — TIMESTAMP

Robot (robot)

  • serial_no — VARCHAR(50) — Primary key — NOT NULL
  • model_name — VARCHAR(100)
  • status — VARCHAR(20)
  • battery — INTEGER
  • id (owner_id) — BIGINT — Foreign key → Member.id — NOT NULL

Robot_log (robot_log)

  • log_id — BIGINT — Primary key — NOT NULL
  • event_type — VARCHAR(50)
  • message — VARCHAR(255)
  • image_url — VARCHAR(500)
  • created_at — TIMESTAMP
  • serial_no — VARCHAR(50) — Foreign key → Robot.serial_no — NOT NULL

Saved_place (saved_place)

  • saved_place_id — BIGINT — Primary key — NOT NULL
  • place_name — VARCHAR(50)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • address — VARCHAR(255)
  • member_id — BIGINT — Foreign key → Member.id — NOT NULL

Schedule (schedule)

  • schedule_id — BIGINT — Primary key — NOT NULL
  • alarm_time — TIME
  • days_of_week — VARCHAR(20)
  • content — VARCHAR(100)
  • is_active — BOOLEAN
  • member_id — BIGINT — Foreign key → Member.id — NOT NULL