FMS 2.0

Tables (8)

Car Checkup Category (car_checkup_category)

  • ID (id) — bigint(20) — Primary key — NOT NULL
  • Created At (created_at) — timestamp
  • Updated At (updated_at) — timestamp
  • Name (name) — varchar(32)

Car Checkup Item (car_checkup_item)

  • ID (id) — bigint(20) — Primary key — NOT NULL
  • Category Id (category_id) — bigint(20) — Foreign key → Car Checkup Category.ID — NOT NULL
  • Created At (created_at) — timestamp
  • Updated At (updated_at) — timestamp
  • Name (name) — varchar(32)
  • Distance Of Default Replacement (distance_of_default_replacement) — int(11)

Car Checkup Item Status (car_checkup_item_status)

  • ID (id) — bigint(20) — Primary key — NOT NULL
  • Chekcup Id (checkup_id) — bigint(20) — Foreign key → Car Checkup Item.ID — NOT NULL
  • Car Id (car_id) — bigint(20) — Foreign key → FMS Car.Id — NOT NULL
  • Distance Of Last Replacement (distance_of_last_replacement) — int(11)
  • Distance Of Need Replacement (distance_of_need_replacement) — int(11)
  • Date Of Last Replacement (date_of_last_replacement) — int(11)
  • Distance Of After Last Replacement (distance_of_after_last_replacement) — int(11)
  • Memo (memo) — varchar(110)

Car Checkup Replacement Distance Change History (car_checkup_replacement_distance_change_history)

  • ID (id) — bigint(20) — Primary key — NOT NULL
  • Checkup Id (checkup_id) — bigint(20)
  • Car Id (car_id) — bigint(20)
  • UserId Of Change Interval (userid_of_change_interval) — bigint(20)
  • Distance Of Before Change Replacement Distance (distance_of_before_change_replacement_distance) — int(11)
  • Distance Of After Change Replacement Distance (distance_of_after_change_replacement_distance) — int(11)
  • Memo (memo) — varchar(110)
  • Status (status) — boolean

Car Checkup Replacement History (car_checkup_replacement_history)

  • ID (id) — bigint(20) — Primary key — NOT NULL
  • Checkup Id (checkup_id) — bigint(20)
  • UserId Of Replacement (userid_of_replacement) — bigint(20)
  • Car Id (car_id) — bigint(20)
  • Created At (created_at) — timestamp
  • Updated At (updated_at) — timestamp
  • Distance Of Replacement (distance_of_replacement) — int(11)
  • Cost Of Replacement (cost_of_replacement) — int(11)
  • Status (status) — boolean
  • Memo (memo) — varchar(110)

Car Checkup Status (car_checkup_status)

  • ID (id) — bigint(11) — Primary key — NOT NULL
  • Car Id (car_id) — bigint(20) — Foreign key → FMS Car.Id — NOT NULL
  • Distance (distance) — int(11)
  • Number Of Dangerous (number_of_dangerous) — int(11)
  • Number Of Warning (number_of_warning) — int(11)
  • Is Initialized (is_initialized) — boolean
  • Memo (memo) — VARCHAR(110)

FMS Car (car)

  • Id (id) — bigint(20) — Primary key — NOT NULL

FMS User (fms_user)

  • Id (id) — bigint(20) — Primary key — NOT NULL