따릉이 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)