따릉이 mini

테이블 (5)

foot_print (Untitled5)

  • date (Key2) — datetime — 외래 키 → weather.date — NOT NULL
  • used_hour (Field2) — datetime — 외래 키 → weather.used_hour
  • rent_id (Field) — str
  • rent_name (Field3) — str
  • sep (Field4) — str
  • sex (Field5) — str
  • age (Field6) — str
  • used_count (Field7) — int
  • exer_count (Field8) — float
  • carbon_count (Field9) — float
  • dist (Field10) — float
  • used_min (Field11) — int

rent_detail (Untitled)

  • std_date (Key) — datetime — 기본 키 — NOT NULL
  • std_time (Key2) — datetime — 기본 키 — NOT NULL
  • start_rent_id (Key4) — str — 외래 키 → rent_id_master.rent_id — NOT NULL
  • start_rent_name (Field2) — str
  • end_rent_id (Field3) — str
  • end_rent_name (Field4) — str
  • tot_count (Field5) — int
  • tot_used_min (Field6) — int
  • tot_used_dist (Field7) — int

rent_id_lat (Untitled3)

  • rent_id (Key2) — str — 외래 키 → rent_id_master.rent_id — NOT NULL
  • address1 (Field) — str
  • address2 (Field2) — str
  • lat (Field3) — float
  • lon (Field4) — float

rent_id_master (Untitled2)

  • rent_id (Key) — str — 기본 키 — NOT NULL
  • rent_name (Field)

weather (Untitled4)

  • date (Key) — datetime — 기본 키 — NOT NULL
  • used_hour (Field2) — datetime — 기본 키
  • rented_count (Field) — int
  • temperature (Field3) — float
  • humidity (Field4) — float
  • wind_speed (Field5) — float
  • visibility (Field6) — int
  • dew_point (Field7) — float
  • solar_radiation (Field8) — float
  • rainfall (Field9) — int
  • snowfall (Field10) — int
  • season (Field11) — str
  • holiday (Field12) — str
  • functioning_day (Field13)