UPM Project

Tables (68)

access_group_estate_info

  • id — BIGINT — Primary key — NOT NULL
  • access_group_id — BIGINT — Foreign key → access_group_info.id — NOT NULL
  • estate_id — INT — Foreign key → client_info.id — NOT NULL
  • source_role_template_id — BIGINT — Foreign key → role_template_info.id
  • source_role_name — VARCHAR(100)
  • role_copied_at — TIMESTAMP
  • permission_saved_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

access_group_estate_permission_info

  • access_group_estate_id — BIGINT — Foreign key → access_group_estate_info.id — NOT NULL
  • resource_id — BIGINT — Foreign key → permission_resource_info.id — NOT NULL
  • parent_id — BIGINT — Foreign key → permission_resource_info.parent_id
  • can_read — BOOLEAN — NOT NULL
  • can_create — BOOLEAN — NOT NULL
  • can_update — BOOLEAN — NOT NULL
  • can_delete — BOOLEAN — NOT NULL

access_group_info

  • id — BIGINT — Primary key — NOT NULL
  • access_group_code — VARCHAR(50) — NOT NULL
  • access_group_name — VARCHAR(200) — NOT NULL
  • type — ENUM('MANUAL','SYSTEM') — NOT NULL
  • system_reserved — BOOLEAN — NOT NULL
  • status — INT — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP
  • del_yn — VARCHAR(1) — NOT NULL

access_group_member_info

  • id — BIGINT — Primary key — NOT NULL
  • access_group_id — BIGINT — Foreign key → access_group_info.id — NOT NULL
  • user_id — INT — Foreign key → member_info.id — NOT NULL
  • assigned_by — INT — Foreign key → member_info.id
  • assigned_at — TIMESTAMP — NOT NULL
  • active — BOOLEAN — NOT NULL
  • removed_at — TIMESTAMP

admin_data_log

  • id — INT — Primary key — NOT NULL
  • insert_date — timestamp — NOT NULL
  • update_date — timestamp — NOT NULL
  • table_name — varchar(30) — NOT NULL
  • record_id — INT — NOT NULL
  • action — INT — NOT NULL
  • app_id — varchar(30)
  • client_id — INT
  • member_id — INT
  • data_log — JSON

app_favorite_location

  • type — varchar(20)
  • mark_id — varchar(100)
  • issue_id — varchar(100)
  • lat — DOUBLE
  • lng — DOUBLE
  • map_uuid — varchar(200)
  • insert_date — TIMESTAMP — NOT NULL
  • update_date — TIMESTAMP — NOT NULL
  • member_id — INT
  • app_id — varchar(50)
  • name — varchar(50)
  • created_timestamp — numeric(13)
  • favorite_id — varchar(100) — NOT NULL
  • del_yn — varchar(1) — NOT NULL
  • id — " — NOT NULL

app_service_info

  • app_id — varchar(50) — Primary key — NOT NULL
  • id — INT — NOT NULL
  • client_id — INT
  • status — INT
  • created_date — date — NOT NULL
  • updated_date — timestamp — NOT NULL
  • area_work — JSON
  • app_name — varchar(100)
  • apk_local_path — varchar(200)
  • apk_url — varchar(200)
  • apk_name — varchar(200)
  • del_yn — CHAR(1)
  • loading_data — BOOLEAN
  • group_client_code — varchar(50)
  • download_count — INT
  • force_update_version — varchar
  • version_apk — varchar(20)
  • is_update_zip_file_map — BOOLEAN
  • update_osm_file_date — TIMESTAMP
  • update_road_data_date — TIMESTAMP
  • working_time — JSON
  • waiting_for_update_template — BOOLEAN
  • url_download_usb_file — CHAR(500)
  • initial_data_download_time — TIMESTAMP
  • file_initial_size — BIGINT
  • auto_update_apk — BOOLEAN
  • initial_data_version — BIGINT

app_service_pipeline_job

  • id — VARCHAR(36) — Primary key — NOT NULL
  • app_id — varchar — NOT NULL
  • job_type — varchar(32) — NOT NULL
  • status — varchar(20) — NOT NULL
  • current_step — varchar(64)
  • failed_step — varchar(64)
  • error_message — text
  • completed_steps — JSON — NOT NULL
  • context — JSON — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • finished_at — TIMESTAMP
  • updated_at — TIMESTAMP — NOT NULL

app_service_registration_job

  • id — VARCHAR(36) — Primary key — NOT NULL
  • app_id — varchar — NOT NULL
  • job_type — varchar(32) — NOT NULL
  • status — varchar(20) — NOT NULL
  • current_step — varchar(64)
  • error_message — text
  • started_at — TIMESTAMP — NOT NULL
  • finished_at — TIMESTAMP
  • updated_at — TIMESTAMP — NOT NULL
  • context — JSON — NOT NULL

app_service_registration_step

  • id — BIGINT — Primary key — NOT NULL
  • job_id — VARCHAR(36) — Foreign key → app_service_registration_job.id — NOT NULL
  • step_code — varchar(64) — NOT NULL
  • step_order — SMALLINT — NOT NULL
  • status — varchar(20) — NOT NULL
  • error_message — text
  • meta — JSON
  • started_at — TIMESTAMP — NOT NULL
  • finished_at — TIMESTAMP
  • updated_at — TIMESTAMP — NOT NULL

backup_user_group_info

  • id — INT
  • user_id — INT
  • group_id — INT
  • created_date — date
  • group_code — varchar(50)

batch_job_execution

  • job_execution_id — BIGINT — Primary key — NOT NULL
  • version — BIGINT
  • job_instance_id — BIGINT — Foreign key → batch_job_instance.job_instance_id — NOT NULL
  • create_time — timestamp — NOT NULL
  • start_time — timestamp
  • end_time — timestamp
  • status — varchar(10)
  • exit_code — varchar(2500)
  • exit_message — varchar(2500)
  • last_updated — timestamp

batch_job_execution_context

  • job_execution_id — BIGINT — Foreign key → batch_job_execution.job_execution_id — NOT NULL
  • short_context — varchar(2500) — NOT NULL
  • serialized_context — text

batch_job_execution_params

  • job_execution_id — BIGINT — Foreign key → batch_job_execution.job_execution_id — NOT NULL
  • parameter_name — varchar(100) — NOT NULL
  • parameter_type — varchar(100) — NOT NULL
  • parameter_value — varchar(2500)
  • identifying — CHAR(1) — NOT NULL

batch_job_instance

  • job_instance_id — BIGINT — Primary key — NOT NULL
  • version — BIGINT
  • job_name — varchar(100) — NOT NULL
  • job_key — varchar(32) — NOT NULL

batch_step_execution

  • step_execution_id — BIGINT — Primary key — NOT NULL
  • version — BIGINT — NOT NULL
  • step_name — varchar(100) — NOT NULL
  • job_execution_id — BIGINT — Foreign key → batch_job_execution.job_execution_id — NOT NULL
  • create_time — timestamp — NOT NULL
  • start_time — timestamp
  • end_time — timestamp
  • status — varchar(10)
  • commit_count — BIGINT
  • read_count — BIGINT
  • filter_count — BIGINT
  • write_count — BIGINT
  • read_skip_count — BIGINT
  • write_skip_count — BIGINT
  • process_skip_count — BIGINT
  • rollback_count — BIGINT
  • exit_code — varchar(2500)
  • exit_message — varchar(2500)
  • last_updated — timestamp

batch_step_execution_context

  • step_execution_id — BIGINT — Foreign key → batch_step_execution.step_execution_id — NOT NULL
  • short_context — varchar(2500) — NOT NULL
  • serialized_context — text

business_client_info

  • id — INT — Primary key — NOT NULL
  • status — INT — NOT NULL
  • title — JSON
  • type — varchar(20)

business_info

  • id — int — Primary key — NOT NULL
  • name — varchar(50)
  • description — varchar(500)
  • status — int

cache_batch_run

  • id — INT — Primary key — NOT NULL
  • batch_type — varchar(50) — NOT NULL
  • last_run_date — date — NOT NULL
  • last_run_timestamp — timestamp — NOT NULL
  • earliest_insert_date — date
  • latest_insert_date — date
  • status — varchar(20) — NOT NULL
  • blocks_processed — INT
  • rows_inserted — INT
  • execution_time_ms — BIGINT
  • created_at — timestamp — NOT NULL

cache_begin_data_count

  • id — INT — Primary key — NOT NULL
  • snapshot_date — date — NOT NULL
  • group_code — varchar(100)
  • estate_code — varchar(100) — NOT NULL
  • division_uuid — varchar(50) — NOT NULL
  • block_uuid — varchar(50) — NOT NULL
  • tree_status — varchar(50) — NOT NULL
  • begin_count — INT — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

cache_count_detection

  • id — INT — Primary key — NOT NULL
  • snapshot_date — date — NOT NULL
  • group_code — varchar(100)
  • estate_code — varchar(100) — NOT NULL
  • division_uuid — varchar(50) — NOT NULL
  • block_uuid — varchar(50) — NOT NULL
  • tree_status — varchar(50) — NOT NULL
  • status_count — INT — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

change_log

  • id — INT — Primary key — NOT NULL
  • table_name — varchar(100)
  • operation — varchar(10)
  • record_id — INT
  • group_code — varchar(50)
  • data — JSON
  • created_at — timestamp
  • processed — BOOLEAN
  • source_server — varchar(50)

client_info

  • id — INT — Primary key — NOT NULL
  • business_id — int — Foreign key → business_info.id — NOT NULL
  • group_code — VARCHAR(50) — Foreign key → group_info.group_code
  • id (id2) — INT — Foreign key → group_info.id — NOT NULL
  • create_date — TIMESTAMP
  • name — VARCHAR(50) — NOT NULL
  • client_code — VARCHAR(50) — NOT NULL
  • status — INT — NOT NULL
  • del_yn — CHAR(1) — NOT NULL
  • center_position — JSON
  • updated_date — TIMESTAMP
  • aoi_depth — INT — NOT NULL
  • block_file_url — TEXT
  • block_file_date — TIMESTAMP
  • area_ha — DECIMAL(14,2)
  • bbox_nw_lat — DECIMAL(10,7)
  • bbox_nw_lng — DECIMAL(10,7)
  • bbox_se_lat — DECIMAL(10,7)
  • bbox_se_lng — DECIMAL(10,7)

collection_data_info

  • checksum — varchar(200) — Primary key — NOT NULL
  • id — INT — NOT NULL
  • coordinates — JSON — NOT NULL
  • original_file — varchar(200) — NOT NULL
  • save_file — varchar(200) — NOT NULL
  • uploaded_datetime — timestamp — NOT NULL
  • analysis_result — varchar(200)
  • status — INT
  • app_id — varchar(200) — NOT NULL
  • member_id — INT
  • analysis_completed_at — TIMESTAMP
  • shooting_date — timestamp
  • collection_result_update_date — TIMESTAMP
  • image_url — varchar(200)
  • block_uuid — varchar(50)
  • source_server — varchar(10)
  • summary — JSON
  • fruits_info — JSON

data_log_app_usage

  • id — INT — NOT NULL
  • farm_code — varchar(50) — NOT NULL
  • group_client_code — varchar(50) — NOT NULL
  • data_log_time — timestamp — NOT NULL
  • insert_date — TIMESTAMP — NOT NULL
  • farm_id — INT — NOT NULL
  • app_id — varchar(50) — NOT NULL
  • member_uuid — varchar(40)

data_log_directions

  • id — BIGINT — NOT NULL
  • log_id — varchar(50) — NOT NULL
  • app_id — varchar(50) — NOT NULL
  • farm_code — varchar(50) — NOT NULL
  • farm_id — INT — NOT NULL
  • group_client_code — varchar(50) — NOT NULL
  • user_id_upload — INT — NOT NULL
  • type — varchar(20) — NOT NULL
  • payload — JSON
  • insert_date — TIMESTAMP
  • date_log — timestamp
  • member_uuid_upload — varchar(40)

data_log_map_usage

  • id — INT — NOT NULL
  • map_uuid — varchar(50) — NOT NULL
  • farm_code — varchar(50) — NOT NULL
  • group_client_code — varchar(50) — NOT NULL
  • data_log_time — TIMESTAMP — NOT NULL
  • insert_date — TIMESTAMP — NOT NULL
  • farm_id — INT — NOT NULL
  • app_id — varchar(50) — NOT NULL
  • member_uuid — varchar(40)

data_log_travel_time

  • id — INT — NOT NULL
  • map_uuid — varchar(50)
  • farm_code — varchar(50) — NOT NULL
  • group_client_code — varchar(50) — NOT NULL
  • data_log_time — TIMESTAMP — NOT NULL
  • insert_date — TIMESTAMP — NOT NULL
  • farm_id — INT — NOT NULL
  • app_id — varchar(50) — NOT NULL
  • user_id — INT — NOT NULL
  • travel_time — INT — NOT NULL
  • member_uuid — varchar(40)

data_log_work_time

  • id — INT — NOT NULL
  • map_uuid — varchar(50)
  • farm_code — varchar(50) — NOT NULL
  • group_client_code — varchar(50) — NOT NULL
  • data_log_time — TIMESTAMP — NOT NULL
  • insert_date — TIMESTAMP — NOT NULL
  • farm_id — INT — NOT NULL
  • app_id — varchar(50) — NOT NULL
  • user_id — INT — NOT NULL
  • working_time — INT — NOT NULL
  • member_uuid — varchar(40)

ee_block_data

  • id — INT — NOT NULL
  • type — varchar(50) — NOT NULL
  • block_uuid — varchar(50) — NOT NULL
  • ha — numeric(12) — NOT NULL
  • geometry — JSON — NOT NULL
  • create_date — date — NOT NULL
  • division_uuid — varchar(50) — NOT NULL
  • update_date — timestamp
  • block_name — varchar(20)
  • estate_code — varchar(20)
  • depth_level — numeric(1)
  • parent_aoi_uuid — varchar(50)

ee_division_data

  • id — INT — NOT NULL
  • type — varchar(50) — NOT NULL
  • geometry — JSON — NOT NULL
  • division_uuid — varchar(50) — NOT NULL
  • ha — varchar(50) — NOT NULL
  • create_date — date — NOT NULL
  • update_date — timestamp
  • estate_code — varchar(20)
  • division_name — varchar(50)

ee_tree_data

  • id — INT — Primary key — NOT NULL
  • tree_id — varchar(20) — NOT NULL
  • feature_id — varchar(20) — NOT NULL
  • division_uuid — varchar(50) — NOT NULL
  • block_uuid — varchar(50) — NOT NULL
  • status — varchar(50)
  • date — date — NOT NULL
  • create_date — date — NOT NULL
  • geometry — JSON — NOT NULL
  • feature_type — varchar(50) — NOT NULL
  • data_update_date — TIMESTAMP
  • update_date — timestamp
  • estate_code — varchar(50)
  • map_uuid — varchar(50)

enterprise_info

  • id — BIGINT — Primary key — NOT NULL
  • enterprise_code — VARCHAR(50) — NOT NULL
  • enterprise_name — VARCHAR(200) — NOT NULL
  • status — INT — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP
  • del_yn — VARCHAR(1) — NOT NULL

estate_service_info

  • id — BIGINT — Primary key — NOT NULL
  • estate_id — INT — Foreign key → client_info.id — NOT NULL
  • service_id — BIGINT — Foreign key → service_info.id — NOT NULL
  • enabled — BOOLEAN — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

free_travel_points

  • id — BIGINT — NOT NULL
  • direction_id — BIGINT — NOT NULL
  • time — timestamp — NOT NULL
  • utc_time — TIMESTAMP — NOT NULL
  • speed — numeric(10, 2)
  • latitude — varchar(20) — NOT NULL
  • longitude — varchar(20) — NOT NULL
  • block_uuid — varchar(50)
  • travel_time_in_seconds — numeric(10, 3) — NOT NULL
  • create_date — timestamp
  • direction_uuid — varchar(50) — NOT NULL
  • segment_distance_m — numeric(10, 2)
  • app_id — varchar(50)
  • farm_code — varchar(50)
  • farm_id — INT
  • group_client_code — varchar(50)
  • user_id_upload — INT
  • date_log — timestamp
  • member_uuid_upload — varchar(50)
  • geom — public.TEXT(point, 4326)
  • grid_20m — public.TEXT(point, 3857)

free_travel_points_old

  • id — BIGINT — NOT NULL
  • direction_id — BIGINT — NOT NULL
  • time — timestamp — NOT NULL
  • utc_time — TIMESTAMP — NOT NULL
  • speed — numeric(10, 2)
  • latitude — varchar(20) — NOT NULL
  • longitude — varchar(20) — NOT NULL
  • block_uuid — varchar(50)
  • travel_time_in_seconds — INT — NOT NULL
  • create_date — timestamp
  • direction_uuid — varchar(50) — NOT NULL
  • segment_distance_km — numeric(10, 2)
  • app_id — varchar(50)
  • farm_code — varchar(50)
  • farm_id — INT
  • group_client_code — varchar(50)
  • user_id_upload — INT
  • date_log — timestamp
  • member_uuid_upload — varchar(50)
  • geom — public.TEXT(point, 4326)
  • grid_20m — public.TEXT(point, 3857)
  • segment_distance_m — numeric(10, 2)

group_info

  • group_code — VARCHAR(50) — Primary key — NOT NULL
  • id — INT — Primary key — NOT NULL
  • group_name — VARCHAR(200) — NOT NULL
  • created_date — DATE — NOT NULL
  • del_yn — VARCHAR(1) — NOT NULL
  • domain_server — VARCHAR(50)
  • status_server — VARCHAR(5)
  • updated_date — TIMESTAMP
  • group_status — INT — NOT NULL
  • description — VARCHAR(500)
  • logo — VARCHAR(200)
  • enterprise_id — BIGINT — Foreign key → enterprise_info.id

group_member_info

  • id — INT — Primary key — NOT NULL
  • customer_name — VARCHAR(50) — NOT NULL
  • status — INT — NOT NULL

icons_app

  • id — INT — Primary key — NOT NULL
  • icon_name — varchar(200)
  • icon_path — varchar(500)
  • created_at — TIMESTAMP
  • update_at — TIMESTAMP
  • app_id — varchar(100)

map_tree_updated_log

  • id — INT — Primary key — NOT NULL
  • map_uuid — varchar(50) — NOT NULL
  • updated_date — timestamp — NOT NULL
  • division_uuid — varchar(50)

member_estate_permission_override_info

  • access_group_member_id — BIGINT — Primary key — NOT NULL
  • access_group_estate_id — BIGINT — Primary key — NOT NULL
  • resource_id — BIGINT — Primary key — NOT NULL
  • can_read — BOOLEAN
  • can_create — BOOLEAN
  • can_update — BOOLEAN
  • can_delete — BOOLEAN
  • updated_by — INT
  • updated_at — TIMESTAMP — NOT NULL

member_info

  • id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → group_member_info.id — NOT NULL
  • role_id — INT — Foreign key → role_member_info.id — NOT NULL
  • client_id — INT — Foreign key → client_info.id
  • email — VARCHAR(100)
  • pass — VARCHAR(100) — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_date — TIMESTAMP
  • del_yn — CHAR(1) — NOT NULL
  • last_access_date — TIMESTAMP
  • name — VARCHAR(50)
  • status — INT — NOT NULL
  • app_id — VARCHAR(20)
  • is_marketing_user — BOOLEAN
  • is_first_login — BOOLEAN
  • force_update_app_data_time — TIMESTAMP
  • employee_id — VARCHAR(20)
  • uuid — VARCHAR(40)
  • tracking_disabled — BOOLEAN
  • login_id — VARCHAR(100)

member_info_backup

  • id — INT
  • group_id — INT
  • role_id — INT
  • client_id — INT
  • email — varchar(100)
  • pass — varchar(100)
  • create_date — timestamp
  • update_date — timestamp
  • del_yn — CHAR(1)
  • last_access_date — timestamp
  • name — varchar(50)
  • status — INT
  • app_id — varchar(20)
  • is_marketing_user — BOOLEAN
  • is_first_login — BOOLEAN
  • force_update_app_data_time — TIMESTAMP
  • employee_id — varchar(20)
  • uuid — varchar(40)
  • tracking_disabled — BOOLEAN

migration_id_mapping

  • id — BIGINT — Primary key — NOT NULL
  • source_system — VARCHAR(50) — NOT NULL
  • source_table — VARCHAR(100) — NOT NULL
  • source_id — VARCHAR(100) — NOT NULL
  • target_table — VARCHAR(100) — NOT NULL
  • target_id — VARCHAR(100) — NOT NULL
  • migrated_at — TIMESTAMP — NOT NULL

permission_resource_info

  • id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Primary key
  • resource_code — VARCHAR(100) — NOT NULL
  • resource_name — VARCHAR(255) — NOT NULL
  • depth — SMALLINT — NOT NULL
  • sort_order — INT — NOT NULL
  • active — BOOLEAN — NOT NULL

poi_type_icon_map

  • id — INT — Primary key — NOT NULL
  • poi_template_id — INT
  • type_id — varchar(100)
  • icon_id — INT — Foreign key → icons_app.id
  • created_at — timestamp
  • update_date — TIMESTAMP

progress_info

  • progress_percent — numeric — NOT NULL
  • progress_id — varchar(20) — NOT NULL
  • url_download_file — varchar(100)
  • device_id — varchar(50)
  • user_id — INT
  • request_time — TIMESTAMP
  • app_id — varchar(50)
  • zip_file_path — varchar(200)

project_map_info

  • id — INT — Primary key — NOT NULL
  • map_url — varchar(200) — NOT NULL
  • date — TIMESTAMP
  • source_type — varchar(50)
  • image_type — varchar
  • insert_date — TIMESTAMP — NOT NULL
  • app_id — varchar(20) — Foreign key → app_service_info.app_id — NOT NULL
  • use_status — BOOLEAN — NOT NULL
  • del_yn — BOOLEAN — NOT NULL
  • data_update_date — TIMESTAMP
  • use_upload — varchar(1)
  • file_name — varchar(100)
  • map_name — varchar(50)
  • tree_status — JSON
  • update_date — TIMESTAMP
  • bounding_box — JSON
  • is_creating_raster — BOOLEAN — NOT NULL
  • idx — varchar(50) — NOT NULL
  • estate_code — varchar(50)
  • ee_updated_date — timestamp
  • capture_date — timestamp
  • is_used_map — BOOLEAN — NOT NULL
  • last_update_tree_date — TIMESTAMP
  • checksum — varchar(200)
  • url_map_zip_file — varchar(500)
  • checksum_extended — varchar(500)
  • url_map_zip_file_extended — varchar(500)
  • file_size — BIGINT
  • file_extend_size — BIGINT
  • image_uuid — VARCHAR(36)

project_poi_template

  • id — INT — Primary key — NOT NULL
  • poi_type — JSON
  • poi_status — JSON
  • more_field — JSON
  • type — varchar(10) — NOT NULL
  • app_id — varchar(20) — Foreign key → app_service_info.app_id — NOT NULL
  • st_note — BOOLEAN — NOT NULL
  • st_image — BOOLEAN — NOT NULL
  • st_collection — BOOLEAN — NOT NULL
  • update_date — TIMESTAMP — NOT NULL
  • collection_template — JSON
  • st_issue_road — BOOLEAN
  • fruit_ripeness_template — JSON
  • tph_restan_template — JSON

project_tree_status

  • id — INT — Primary key — NOT NULL
  • app_id — BIGINT — NOT NULL
  • status_id — BIGINT — NOT NULL
  • map_id — BIGINT — NOT NULL

role_member_info

  • id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → group_member_info.id — NOT NULL
  • role_level — INT — NOT NULL
  • status — INT — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • order_list — INT

role_template_info

  • id — BIGINT — Primary key — NOT NULL
  • role_template_code — VARCHAR(50) — NOT NULL
  • role_template_name — VARCHAR(100) — NOT NULL
  • scope_type — VARCHAR(50)
  • version — INT — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

role_template_permission_info

  • role_template_id — BIGINT — Foreign key → role_template_info.id — NOT NULL
  • resource_id — BIGINT — Foreign key → permission_resource_info.id — NOT NULL
  • parent_id — BIGINT — Foreign key → permission_resource_info.parent_id
  • can_read — BOOLEAN — NOT NULL
  • can_create — BOOLEAN — NOT NULL
  • can_update — BOOLEAN — NOT NULL
  • can_delete — BOOLEAN — NOT NULL

service_info

  • id — BIGINT — Primary key — NOT NULL
  • service_code — VARCHAR(100) — NOT NULL
  • service_name — VARCHAR(200) — NOT NULL
  • description — VARCHAR(500)
  • status — INT — NOT NULL
  • del_yn — VARCHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

session

  • sid — varchar — Primary key — NOT NULL
  • sess — json — NOT NULL
  • expire — timestamp(6) — NOT NULL

tph_restant_estate_snapshot

  • estate_code — varchar(20) — Primary key — NOT NULL
  • restan_summary — JSON
  • average_remained_days — DOUBLE
  • total_collection_point_count — INT
  • updated_date — TIMESTAMP — NOT NULL
  • generated_at — TIMESTAMP
  • batch_synced_at — TIMESTAMP

tph_restant_history_bunch

  • id — BIGINT — Primary key — NOT NULL
  • point_id — BIGINT — Foreign key → tph_restant_history_point.id — NOT NULL
  • harvest_date — date
  • grain_counts — INT
  • bunch_counts — INT
  • bunch_avg_weight — DOUBLE
  • bunch_total_avg_weight — DOUBLE
  • remained_days — INT
  • remained_days_code — varchar(64)
  • picture_name — text
  • regist_date — TIMESTAMP
  • team_leader — varchar(128)
  • worker_id — varchar(128)
  • notes — text
  • sack_of_loose_fruits — INT

tph_restant_history_point

  • id — BIGINT — Primary key — NOT NULL
  • collection_point_id — BIGINT — NOT NULL
  • collection_points_code — varchar(64)
  • block_code — varchar(512)
  • status — varchar(64)
  • uncollected_id — INT
  • report_date — date
  • latitude — DOUBLE
  • longitude — DOUBLE
  • coordinates — text
  • estate_code — varchar(20) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP — NOT NULL
  • collection_point_remained_days — INT
  • collection_point_total_bunch_counts — INT
  • display_collection_point_name — varchar(256)

tph_restant_latest_bunch

  • id — BIGINT — Primary key — NOT NULL
  • point_id — BIGINT — Foreign key → tph_restant_latest_point.id — NOT NULL
  • harvest_date — date
  • grain_counts — INT
  • bunch_counts — INT
  • bunch_avg_weight — DOUBLE
  • bunch_total_avg_weight — DOUBLE
  • remained_days — INT
  • remained_days_code — varchar(64)
  • picture_name — text
  • regist_date — TIMESTAMP
  • team_leader — varchar(128)
  • worker_id — varchar(128)
  • notes — text
  • sack_of_loose_fruits — INT

tph_restant_latest_point

  • id — BIGINT — Primary key — NOT NULL
  • collection_point_id — BIGINT — NOT NULL
  • collection_points_code — varchar(64)
  • block_code — varchar(512)
  • status — varchar(64)
  • uncollected_id — INT
  • report_date — date
  • latitude — DOUBLE
  • longitude — DOUBLE
  • coordinates — text
  • estate_code — varchar(20) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP — NOT NULL
  • collection_point_remained_days — INT
  • collection_point_total_bunch_counts — INT
  • display_collection_point_name — varchar(256)

tree_status

  • key — varchar(50) — Primary key — NOT NULL
  • id — INT — NOT NULL
  • value — varchar(50) — NOT NULL
  • type — varchar(20) — NOT NULL
  • update_date — timestamp — NOT NULL

user_group_info

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → member_info.id — NOT NULL
  • group_code — VARCHAR(50) — Foreign key → group_info.group_code
  • group_id — INT
  • created_date — DATE — NOT NULL
  • id (id22) — INT — Foreign key — NOT NULL

user_image_upload

  • image_id — varchar(200) — Primary key — NOT NULL
  • idx — INT — NOT NULL
  • mark_id — varchar(50) — NOT NULL
  • image_url — varchar(200) — NOT NULL
  • app_id — varchar(20) — NOT NULL
  • member_id — INT — NOT NULL

user_status_info

  • status_id — INT — Primary key — NOT NULL
  • id — INT — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • status — INT — NOT NULL

worker_area_info

  • id — INT — Primary key — NOT NULL
  • member_id — INT — NOT NULL
  • insert_date — timestamp
  • update_date — timestamp
  • area — JSON — NOT NULL
  • app_id — varchar(20) — NOT NULL
  • grid_id — INT
  • del_yn — CHAR(1) — NOT NULL
  • block_uuid — varchar(50) — NOT NULL
  • division_uuid — varchar(50)

worker_data_log

  • id — INT — Primary key — NOT NULL
  • insert_date — timestamp — NOT NULL
  • member_id — INT — NOT NULL
  • data_log — JSON — NOT NULL
  • update_date — timestamp — NOT NULL
  • action — INT — NOT NULL
  • work_area_id — INT — NOT NULL
  • grid_id — INT
  • block_id — varchar(50)
  • division_uuid — varchar(50)

worker_history

  • worker_history_uuid — varchar(50) — Primary key — NOT NULL
  • id — INT — NOT NULL
  • insert_date — timestamp
  • mark_id — varchar(50) — NOT NULL
  • app_id — varchar(20)
  • work_area_id — INT
  • name — varchar(50)
  • type — varchar(10) — NOT NULL
  • status — varchar — NOT NULL
  • member_id — INT
  • data_log — JSON
  • update_date — TIMESTAMP
  • tree_status — varchar
  • geometry — JSON
  • properties — JSON
  • note — varchar(500)
  • report — varchar(500)
  • mark_type — varchar(50)
  • action — varchar(20)
  • image_ids — TEXT
  • block_uuid — varchar(50)
  • map_id — varchar(50)
  • action_by — INT
  • sub_type — varchar(20)
  • user_upload — BOOLEAN
  • resolve_time — INT
  • source_server — varchar(20)
  • old_tree_status — varchar
  • is_data_user_created — BOOLEAN — NOT NULL
  • upload_date — timestamp
  • feature_type — varchar(20) — NOT NULL
  • block_uuids — TEXT
  • feature_properties — JSON
  • center_position — JSON