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 — 정책