Sw

Tables (14)

LandMark (랜드마크)

  • landmark_id (Key) — Primary key — NOT NULL
  • dong_id (Key2) — Foreign key → dong.dong_id — NOT NULL
  • landmark_name (이름)
  • latitude (위도)
  • longitude (경도)
  • area (면적)

dates (날짜)

  • date_id (날짜) — Primary key — NOT NULL — 0000-00-00
  • day_of_week (요일) — 0=월 ~ 6=일
  • season (계절) — 봄0, 여름1, 가을2, 겨울3

dong (지역(동단위))

  • dong_id (Key) — Primary key — NOT NULL
  • gu_id (Key2) — Foreign key → gu.gu_id — NOT NULL
  • dong_name (동이름)

events_history (행사)

  • event_id (이벤트아이디) — Primary key — NOT NULL
  • event_name (행사이름)
  • category (행사타입)
  • start_date (시작기간)
  • end_date (종료기간)
  • start_hour (시작시간)
  • end_hour (종료시간)
  • dong_id (Key) — Foreign key → dong.dong_id — NOT NULL

gu (지역(구단위))

  • gu_id (Key) — Primary key — NOT NULL
  • gu_name (구이름)
  • nx (기상청격자: x)
  • ny (기상청격자: y)

place (혼잡도지역)

  • place_id (장소코드) — Primary key
  • place_name (장소이름)
  • latitude (위도)
  • longitude (경도)
  • gu_id (Key) — Foreign key → gu.gu_id — NOT NULL

place_population_history (시간별 혼잡도)

  • pop_history_id (Key2) — Primary key — NOT NULL
  • date_id (날짜) — Foreign key → dates.date_id — NOT NULL — 0000-00-00
  • slot_hour (시간) — NOT NULL — 0~23
  • congestion_lvl (붐비는 정도) — 1=한산 2=보통 3=붐빔 4=매우붐빔
  • population_est (총 사람 수)
  • age_10s_est (10대수)
  • age_20s_est (20대 수)
  • age_30s_est (30대 수)
  • age_40s_est (40대 수)
  • age_50s_est (50대 수)
  • man_est (남자 수)
  • woman_est (여자 수)
  • dong_id (Key) — Foreign key → dong.dong_id — NOT NULL

place_tag (장소카테고리매칭)

  • Key — Primary key — NOT NULL
  • tag_type_id (아이디) — Foreign key → tag_type.tag_type_id — NOT NULL
  • place_id (장소코드) — Foreign key → place.place_id

prediction_accuracy (예측 평가)

  • id (Key) — Primary key — NOT NULL
  • target_date (예측 날짜)
  • hour (예측 시간)
  • pred_pop (ai예측인구)
  • actual_pop (실제존재인구)
  • error_rate (틀린 비율)
  • actual_weather (그날 실제 날씨)
  • had_event (행사유무)
  • dong_id (Key2) — Foreign key → dong.dong_id — NOT NULL

tag_type (태그 타입)

  • tag_type_id (아이디) — Primary key — NOT NULL
  • tag_type (태그 타입)
  • tag_value (카테고리)

user (회원정보)

  • id (회원ID) — Primary key — NOT NULL
  • email (이메일)
  • name (이름)
  • birth (생년월일)
  • old (나이)
  • profile_image (프로필사진)
  • login_type (로그인타입)
  • create_at (생성일)

user_auth_KAKAO (카카오회원)

  • id (카카오아이디) — Primary key — NOT NULL
  • id (회원ID) — Foreign key → user.id — NOT NULL
  • kakao_id (Field)

user_auth_email (이메일회원)

  • id (이메일아이디) — Primary key — NOT NULL
  • id (회원ID) — Foreign key → user.id — NOT NULL
  • password (비밀번호)
  • Field2

weather_history (날씨데이터)

  • weather_history_id (Key) — Primary key — NOT NULL
  • date_id (날짜) — Foreign key → dates.date_id — NOT NULL — 0000-00-00
  • slot_hour (시간) — NOT NULL
  • temp (기온) — 1=한산 2=보통 3=붐빔 4=매우붐빔
  • precipitation (강수량)
  • wind_speed (풍속)
  • humidity (습도)
  • weather_code (날씨코드) — 1= 맑음, 2=흐림, 3=비, 4=눈
  • rain_bucket (비 상태코드)
  • temp_bucket (날씨상태코드)