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