CARBOM
Tables (10)
branch (지점 테이블)
- id (Key) — bigint(20) — Primary key — NOT NULL
car (차량 테이블)
- id (Key) — bigint(20) — Primary key — NOT NULL
car_device_usage_history (단말기 설치/해제 이력)
- id (Key) — bigint(20) — Primary key — NOT NULL
- onsite_service_id (Key2) — bigint(20) — Foreign key → onsite_service.id — NOT NULL
- car_id (Field2) — bigint(20)
- device_identity (Field) — varchar(64)
- user_id (Field3) — bigint(20)
- request_date_time (Field4) — timestamp
- request_type (Field5) — tinyint(2)
- company_id (Field6) — bigint(20)
- branch_id (Field7) — bigint(20)
- total_mileage_of_odometer (Field8) — float(9, 1)
- is_ignition_control_installed (Field9) — tinyint(1)
- ignition_control_installation_type (Field10) — tinyint(2)
- fuse_type (Field11) — tinyint(2)
- is_field_installation (Field12) — tinyint(1)
- memo (Field13) — varchar(255)
- created_at (Field14) — timestamp
company (업체 테이블)
- id (Key) — bigint(20) — Primary key — NOT NULL
device (단말기 테이블)
- id (Key) — bigint(20) — Primary key — NOT NULL
- identity (Field) — varchar(64)
fms_user (유저 테이블)
- id (Key) — bigint(20) — Primary key — NOT NULL
notice (공지사항)
- id (Key) — bigint(20) — Primary key — NOT NULL
- category (Field) — tinyint(4)
- title (Field2) — varchar(255)
- content (Field3) — text
- writer_id (Key2) — bigint(20) — Foreign key → fms_user.id — NOT NULL
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
- is_deleted (Field4) — tinyint(1)
- last_deleted_date_time (Field7) — datetime
onsite_service (현장 서비스 이력)
- id (-) — bigint(20) — Primary key — NOT NULL
- category (Field) — bigint(20)
- step (Field9) — tinyint(2)
- requested_user_id (Key2) — bigint(20) — Foreign key → fms_user.id — NOT NULL
- requested_company_id (Key6) — bigint(20) — Foreign key → company.id — NOT NULL
- requested_branch_id (Key7) — bigint(20) — Foreign key → branch.id — NOT NULL
- requested_car_id (Key) — bigint(20) — Foreign key → car.id — NOT NULL
- requested_date_time (Field10) — datetime
- allocator_id (Key3) — bigint(20) — Foreign key → fms_user.id — NOT NULL
- allocator_memo (Field6) — varchar(255)
- allocated_date_time (Field4) — timestamp
- operator_id (Key4) — bigint(20) — Foreign key → fms_user.id — NOT NULL
- operator_memo (Field8) — varchar(255)
- operated_device (Key5) — varchar(64) — Foreign key → device.id — NOT NULL
- operate_date_time (Field19) — timestamp
- operated_date_time (Field20) — timestamp
- created_at (Field17) — timestamp
- updated_at (Field18) — timestamp
onsite_service_job (현장 서비스 이력 상세)
- id (Key) — bigint(20) — Primary key — NOT NULL
- onsite_service_id (Key2) — bigint(20) — Foreign key → onsite_service.id — NOT NULL
- job (Field) — tinyint(4)
- memo (Field2) — varchar(255)
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
user_report (신고 이력 테이블)
- id (Key) — bigint(20) — Primary key — NOT NULL
- type (Field) — tinyint(4)
- category (Field2) — tinyint(4)
- step (Field3) — tinyint(4)
- title (Field4) — varchar(255)
- content (Field5) — text
- image_path (Field6) — varchar(255)
- reported_user_id (Key2) — bigint(20) — Foreign key → fms_user.id — NOT NULL
- reported_date_time (Field8) — datetime
- processed_user_id (Key3) — bigint(20) — Foreign key → fms_user.id — NOT NULL
- processed_date_time (Field9) — datetime
- is_deleted (Field7) — tinyint(1)
- last_deleted_date_time (Field10) — datetime