Rento

Tables (27)

alert_log

  • id — BIGSERIAL
  • mdn — VARCHAR(20) — Foreign key → device.mdn — NOT NULL — 단말
  • alert_type — VARCHAR(50) — NOT NULL — 알림
  • alert_time — TIMESTAMP — NOT NULL — 발생
  • description — TEXT — 설명
  • resolved — BOOLEAN — 해결
  • created_at — TIMESTAMP — 생성
  • updated_at — TIMESTAMP — 최종

company_info

  • company_id — BIGSERIAL
  • company_name — VARCHAR(100) — NOT NULL — 회사명
  • business_registration_number — VARCHAR(20) — 사업자
  • company_code — VARCHAR(20) — 회사
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

device

  • id — BIGSERIAL
  • vehicle_id — BIGINT — 연결된
  • mdn — VARCHAR(20) — NOT NULL — 단말
  • terminal_id — VARCHAR(10) — NOT NULL — 터미널
  • manufacturer_id — VARCHAR(10) — NOT NULL — 제조사
  • packet_version — VARCHAR(5) — NOT NULL — 패킷
  • device_type — VARCHAR(5) — NOT NULL — 장비
  • firmware_version — VARCHAR(20) — 펌웨어
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

device_auth_token

  • mdn — VARCHAR(20) — Foreign key → device.mdn
  • token_value — TEXT — NOT NULL — 인증
  • expiration_period_hours — INTEGER — NOT NULL — 만료
  • issued_at — TIMESTAMP — 발급
  • expires_at — TIMESTAMP — 만료
  • result_code — VARCHAR(10) — NOT NULL — 결과
  • result_message — VARCHAR(100) — 결과
  • response_data — JSONB — 서버가
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

device_config_request_log

  • request_id — BIGSERIAL
  • mdn — VARCHAR(20) — Foreign key → device.mdn — NOT NULL — 단말
  • http_header_timestamp — VARCHAR(20) — HTTP
  • transaction_unique_id — VARCHAR(36) — HTTP
  • key_version — VARCHAR(10) — HTTP
  • request_data — JSONB — 단말이
  • created_at — TIMESTAMP — 레코드

device_config_response_log

  • response_id — BIGSERIAL
  • mdn — VARCHAR(20) — Foreign key → device.mdn — NOT NULL — 단말
  • result_code — VARCHAR(10) — NOT NULL — 결과
  • result_message — VARCHAR(100) — 결과
  • ignition_on_event_time — TIMESTAMP — 발생일시
  • control_command_count — INTEGER — 제어명령
  • geofence_setting_count — INTEGER — 지오펜싱
  • response_data — JSONB — 서버가
  • created_at — TIMESTAMP — 레코드

device_control_command_log

  • command_id — BIGSERIAL
  • config_response_id — BIGINT — Foreign key → device_config_response_log.response_id — NOT NULL — device_config_response_log
  • control_item_id — VARCHAR(20) — 제어
  • control_code — VARCHAR(10) — 제어
  • control_value — VARCHAR(100) — 제어
  • created_at — TIMESTAMP — 레코드

device_geofence_config_log

  • setting_id — BIGSERIAL
  • config_response_id — BIGINT — Foreign key → device_config_response_log.response_id — NOT NULL — device_config_response_log
  • geofence_control_id — VARCHAR(20) — 지오펜스
  • update_value — VARCHAR(5) — 전체
  • geofence_group_id — VARCHAR(20) — 지오펜스
  • geofence_event_type — VARCHAR(5) — 이벤트
  • geofence_radius_meters — VARCHAR(10) — 지오펜스
  • latitude — NUMERIC(9,6) — 위도
  • longitude — NUMERIC(9,6) — 경도
  • start_time — TIMESTAMP — 시작
  • end_time — TIMESTAMP — 종료
  • store_type — geofence_store_type_enum — 저장
  • created_at — TIMESTAMP — 레코드

device_token_request_log

  • request_id — BIGSERIAL
  • mdn — VARCHAR(20) — Foreign key → device.mdn — NOT NULL — 단말
  • http_header_timestamp — VARCHAR(20) — HTTP
  • transaction_unique_id — VARCHAR(36) — HTTP
  • key_version — VARCHAR(10) — HTTP
  • request_data — JSONB — 단말이
  • created_at — TIMESTAMP — 레코드

driving_log

  • record_time — TIMESTAMP — Primary key — NOT NULL
  • mdn — VARCHAR(20) — Foreign key → device.mdn — NOT NULL — 단말
  • gps_condition — gps_condition_enum — NOT NULL — GPS
  • latitude — NUMERIC(9,6) — 위도
  • longitude — NUMERIC(9,6) — 경도
  • angle — INTEGER — 방향
  • speed — INTEGER — 속도
  • total_distance — BIGINT — 누적
  • battery_volt — INTEGER — 배터리

employee_info

  • employee_id — BIGSERIAL
  • company_id — BIGINT — Foreign key → company_info.company_id — NOT NULL — 소속
  • org_unit_id — BIGINT — Foreign key → organization_unit_info.org_unit_id — 소속
  • user_name — VARCHAR(100) — NOT NULL — 직원
  • login_id — VARCHAR(50) — NOT NULL — 로그인
  • password_hash — VARCHAR(255) — NOT NULL — 비밀번호
  • email — VARCHAR(100) — 이메일
  • phone_number — VARCHAR(20) — 전화번호
  • status — user_status_enum — NOT NULL — 계정
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

employee_role_map

  • employee_id — BIGINT — Foreign key → employee_info.employee_id — NOT NULL
  • role_id — BIGINT — Foreign key → role_info.role_id — NOT NULL — 역할
  • assigned_at — TIMESTAMP — 역할

geofence_item

  • geofence_item_id — BIGSERIAL
  • geofence_name — VARCHAR(100) — NOT NULL — 지오펜스
  • latitude — NUMERIC(9,6) — NOT NULL — 지오펜스
  • longitude — NUMERIC(9,6) — NOT NULL — 지오펜스
  • radius_meters — INTEGER — NOT NULL — 지오펜스
  • event_trigger_type — geofence_trigger_type_enum — NOT NULL — 이벤트
  • description — TEXT — 상세
  • is_active — BOOLEAN — 지오펜스
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

geofence_policy

  • policy_id — BIGSERIAL
  • company_id — BIGINT — Foreign key → company_info.company_id — NOT NULL — 소속
  • policy_name — VARCHAR(100) — NOT NULL — 정책
  • description — TEXT — 정책
  • is_active — BOOLEAN — 정책
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

geofence_policy_item_map

  • policy_id — BIGINT — Foreign key → geofence_policy.policy_id — NOT NULL
  • geofence_item_id — BIGINT — Foreign key → geofence_item.geofence_item_id — NOT NULL — 지오펜스
  • created_at — TIMESTAMP — 레코드

maintenance_log

  • id — BIGSERIAL
  • mdn — VARCHAR(20) — Foreign key → device.mdn — NOT NULL — 단말
  • log_date — DATE — NOT NULL — 정비
  • description — TEXT — NOT NULL — 정비
  • cost — INTEGER — 비용
  • mileage_at_maintenance — BIGINT — 정비
  • created_by — BIGINT — 작성자
  • created_at — TIMESTAMP — 작성
  • updated_at — TIMESTAMP — 최종

organization_unit_info

  • org_unit_id — BIGSERIAL
  • company_id — BIGINT — Foreign key → company_info.company_id — NOT NULL — 소속
  • org_unit_name — VARCHAR(100) — NOT NULL — 조직
  • org_unit_type — org_unit_type_enum — NOT NULL — 조직
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

permission_info

  • permission_id — BIGSERIAL
  • permission_code — VARCHAR(50) — NOT NULL — 권한
  • description — TEXT — 권한
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

policy

  • id — BIGSERIAL
  • company_id — BIGINT — Foreign key → company_info.company_id — NOT NULL — 소속
  • name — VARCHAR(100) — NOT NULL — 정책
  • policy_type — VARCHAR(50) — NOT NULL — 정책
  • value — JSONB — NOT NULL — 정책
  • description — TEXT — 설명
  • is_active — BOOLEAN — 정책
  • created_at — TIMESTAMP — 생성
  • updated_at — TIMESTAMP — 최종

raw_request_log

  • id — BIGSERIAL
  • mdn — VARCHAR(20) — 단말
  • service_method — VARCHAR(50) — 요청된
  • received_at — TIMESTAMP — 수신
  • raw_body — JSONB — NOT NULL — 원본
  • processed — BOOLEAN — 처리
  • process_result — TEXT — 처리
  • headers — JSONB — HTTP
  • source_ip — INET — 요청
  • created_at — TIMESTAMP — 레코드

role_info

  • role_id — BIGSERIAL
  • role_name — VARCHAR(50) — NOT NULL — 역할
  • description — TEXT — 역할
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

role_permission_map

  • role_id — BIGINT — Foreign key → role_info.role_id — NOT NULL
  • permission_id — BIGINT — Foreign key → permission_info.permission_id — NOT NULL — 권한
  • created_at — TIMESTAMP — 레코드

vehicle_driver_map

  • map_id — BIGSERIAL
  • mdn — VARCHAR(20) — Foreign key → vehicle_info.mdn — NOT NULL — 차량
  • employee_id — BIGINT — Foreign key → employee_info.employee_id — NOT NULL — 운전자
  • is_primary_driver — BOOLEAN — 해당
  • assigned_start_at — TIMESTAMP — 할당
  • assigned_end_at — TIMESTAMP — 할당
  • created_at — TIMESTAMP — 레코드

vehicle_event_log

  • event_timestamp_utc — TIMESTAMP — Primary key — NOT NULL
  • mdn — VARCHAR(20) — Foreign key → device.mdn — NOT NULL — 단말
  • event_type — vehicle_event_type_enum — NOT NULL — 이벤트
  • event_second — INTEGER — 이벤트
  • gps_status — gps_condition_enum — GPS
  • latitude — NUMERIC(9,6) — GPS
  • longitude — NUMERIC(9,6) — GPS
  • angle — INTEGER — 차량
  • speed — INTEGER — 차량
  • current_accumulated_distance — BIGINT — 현재
  • battery_volt — INTEGER — 배터리
  • on_time — TIMESTAMP — 시동
  • ignition_off_time — TIMESTAMP — 시동
  • geofence_group_id — VARCHAR(20) — 지오펜스
  • geofence_point_id — VARCHAR(20) — 지오펜스
  • event_value — VARCHAR(10) — 이벤트
  • raw_json_data — JSONB — 원본

vehicle_general_policy_assignment

  • assignment_id — BIGSERIAL
  • mdn — VARCHAR(20) — Foreign key → device.mdn — NOT NULL — 단말
  • policy_id — BIGINT — Foreign key → policy.id — NOT NULL — 할당된
  • assigned_at — TIMESTAMP — 적용
  • is_active — BOOLEAN — 현재
  • created_at — TIMESTAMP — 생성
  • updated_at — TIMESTAMP — 최종

vehicle_info

  • mdn — VARCHAR(20)
  • company_id — BIGINT — Foreign key → company_info.company_id — NOT NULL — 소속
  • name — VARCHAR(100) — 차량명
  • plate_no — VARCHAR(20) — NOT NULL — 차량
  • vin — VARCHAR(50) — 차량
  • model — VARCHAR(50) — 차량
  • year — INT — 연식
  • fuel_type — fuel_type_enum — 연료
  • is_active — BOOLEAN — 운행
  • last_latitude — NUMERIC(9,6) — 시동
  • last_longitude — NUMERIC(9,6) — 시동
  • total_accumulated_distance — BIGINT — 최종
  • created_at — TIMESTAMP — 레코드
  • updated_at — TIMESTAMP — 레코드

vehicle_policy_assignment

  • mdn — VARCHAR(20) — Foreign key → vehicle_info.mdn
  • policy_id — BIGINT — Foreign key → geofence_policy.policy_id — NOT NULL — 할당된
  • assigned_at — TIMESTAMP — 정책