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