2ND-2TEAM

Tables (3)

appointment (예약)

  • appointment_id (PK) — Primary key — NOT NULL
  • icd (fileld) — Foreign key → icd_codes.icd_code — NOT NULL
  • appointment_date (Field2) — Foreign key → weather.weather_date
  • appointment_datetime (Field)
  • name (Field11)
  • specialty (Field3)
  • gender (Field4)
  • age (Field5)
  • under_12_years_old (Field6)
  • over_60_years_old (Field7)
  • patient_needs_companion (Field8)
  • disability (Field9)
  • no_show (Field10)
  • entry_service_date (Field12)

icd_codes (질병코드)

  • icd_code (PK) — Primary key — NOT NULL
  • disease_name (Field)

weather (날씨)

  • weather_date (Field) — Primary key
  • weather_id (PK) — NOT NULL
  • average_temp_day (Field2)
  • max_temp_day (Field3)
  • average_rain_day (Field4)
  • max_rain_day (Field5)
  • rain_intensity (Field6)
  • storm_day_before (Field7)
  • heat_intensity (Field8)