uv_recap

Tables (8)

Copy Of sun_screen_coat (CopyOfsun_screen_coat)

  • id — varchar(200) — Primary key — NOT NULL — Auto Inceament
  • Field

shade_category

  • id — varchar(200) — Primary key — NOT NULL — Auto Increment
  • 카테고리명 (category_name) — varchar(20) — NOT NULL

shade_place

  • id — varchar(200) — Primary key — NOT NULL — Auto Increament
  • 장소 이름 (name) — varchar(30) — NOT NULL
  • 위도 (latitude) — demical — NOT NULL
  • 경도 (longitude) — demical — NOT NULL
  • Field

shade_place_category

  • id — varchar(200) — Primary key — NOT NULL — Auto Increament
  • 장소 id (shadow_place_id) — varchar(200) — Foreign key → shade_place.id — NOT NULL — Auto Increament
  • 카테고리 id (shadow_place_category_id) — varchar(200) — Foreign key → shade_category.id — NOT NULL — Auto Increment

sun_screen

  • id — varchar(200) — Primary key — NOT NULL — Auto Inceament
  • id (id2) — varchar(200) — Foreign key → user.id — NOT NULL — Auto Inceament
  • Field

sun_screen_coat

  • id — varchar(200) — Primary key — NOT NULL
  • sun_screen_id — varchar(200) — Foreign key → sun_screen.id — NOT NULL
  • id (id2) — varchar(200) — Foreign key → sun_screen.id — NOT NULL — Auto Inceament

user

  • id — varchar(200) — Primary key — NOT NULL — Auto Inceament
  • device identifier (device_identifier) — varchar(50) — NOT NULL

uv

  • id — varchar(200) — Primary key — NOT NULL — Auto Inceament
  • UV Index (uv_index) — int — NOT NULL