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)