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