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