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