medicast
Tables (3)
prediction
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- age — INT — NOT NULL
- sex — INT — NOT NULL
- region — INT
- income — BIGINT
- bmi — DECIMAL(5,2)
- chronic_disease — INT
- self_rated_health — INT
- smoking_status — INT
- drinking_frequency — INT
- exercise — INT
- predicted_medical_cost — BIGINT
- created_at — DATETIME — NOT NULL
prediction_factor
- id — BIGINT — Primary key — NOT NULL
- prediction_id — BIGINT — Foreign key → prediction.id — NOT NULL
- feature_name — VARCHAR(100) — NOT NULL
- feature_value — VARCHAR(255)
- impact_value — DOUBLE — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL