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