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