MyParking API

Tables (6)

Untitled (parking_lots_score)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (parking_lots_id) — bigint — Foreign key → parking_lots.Key — NOT NULL
  • Field (score) — bigint — NOT NULL
  • Field (comment) — varchar(255)
  • Field (user_id) — varchar(255) — NOT NULL

Untitled (User)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (picture) — varchar(255)
  • Field (role) — varchar(255) — NOT NULL
  • Field2 (email) — varchar(255) — NOT NULL

Untitled (oauth_id)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field
  • Field (access_token) — varchar(255) — NOT NULL

Untitled (favorites)

  • Key (id) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL

Untitled (favorites_parking_lots)

  • Key (favorites_parking_lots_id) — bigint — Primary key — NOT NULL
  • Key (parking_lots_id) — bigint — Foreign key → parking_lots.Key — NOT NULL
  • Key (favorites_id) — bigint — Foreign key → Untitled.Key — NOT NULL

parking_lots

  • Key (id) — bigint — Primary key — NOT NULL
  • parking_lot_no — varchar(255) — NOT NULL
  • parking_lot_nm — text — NOT NULL
  • Field (parking_lot_section) — varchar(255) — NOT NULL
  • Field2 (parking_lot_type) — varchar(255) — NOT NULL
  • Field3 (road_name_address) — text
  • Field (number_name_address) — text — NOT NULL
  • Field4 (parking_compartment) — bigint — NOT NULL
  • Field5 (feed_division) — varchar(255) — NOT NULL
  • Field6 (alternate_day_no_driving_division) — varchar(255) — NOT NULL
  • Field7 (operating_day) — varchar(255) — NOT NULL
  • Field8 (weekday_opening_hour) — time — NOT NULL
  • weekday_closing_hour — time — NOT NULL
  • saturday_opening_hour — time — NOT NULL
  • saturday_closing_hour — time — NOT NULL
  • holiday_opening_hour — time — NOT NULL
  • holiday_closing_hour — time — NOT NULL
  • Field2 (parking_fee_infomation) — varchar(255) — NOT NULL
  • Field3 (basic_parking_time) — bigint — NOT NULL
  • Field4 (basic_parking_fee) — bigint — NOT NULL
  • additional_unit_time — varchar(255) — NOT NULL
  • additional_parking_fee — varchar(255) — NOT NULL
  • day_parking_fee_application_time — varchar(255) — NOT NULL
  • day_parking_fee — varchar(255) — NOT NULL
  • monthly_fee — varchar(255) — NOT NULL
  • Field2 (payment_method) — varchar(255)
  • Field3 (remarks) — varchar(255)
  • Field4 (management_agency_name) — text — NOT NULL
  • Field5 (management_agency_phone_number) — varchar(255) — NOT NULL
  • Field (latitude) — varchar(255) — NOT NULL
  • Field2 (longitude) — varchar(255) — NOT NULL
  • Field3 (reference_date) — datetime — NOT NULL
  • Field4 (institude_code) — varchar(255) — NOT NULL
  • Field (institude_name) — text — NOT NULL