EB-sDB

Tables (6)

Favorite_place (favorite_place)

  • favorite_place_uid (Key) — Primary key — NOT NULL
  • member_uid (Key4) — Foreign key → Member.member_uid — NOT NULL
  • category (Field)
  • info (Key2) — NOT NULL
  • lng (Field2)
  • lat (Field3)

Member (member)

  • member_uid (Key) — Primary key — NOT NULL
  • id (Field)
  • password (Field2)
  • name (Field3)
  • refreshToken (Field5)
  • salt (Field4)
  • device_token (Field6)

Path (path)

  • path_uid (Key) — Primary key — NOT NULL
  • schedule_uid (Key2) — Foreign key → Schedule.schedule_uid — NOT NULL
  • member_uid (Key22) — Foreign key → Schedule.member_uid — NOT NULL
  • total_time (Field)
  • totla_pay (Field2)
  • total_transit_count (Field3)
  • total_walk_time (Field4)
  • path_type (Field5)

Schedule (schedule)

  • schedule_uid (Key) — Primary key — NOT NULL
  • member_uid (Key2) — Foreign key → Member.member_uid — NOT NULL
  • name (Field)
  • memo (Field2)
  • start_date (Field3)
  • start_address_name (Field4)
  • start_lng (Field5)
  • start_lat (Field6)
  • end_address_name (Field7)
  • end_lng (Field8)
  • end_lat (Field9)
  • notice_range (Field10)
  • notice_min_before_transport_arrive (Field11)
  • must_be_notify (Field12)

Untitled

    Untitled2