전남 TP
테이블 (23)
drone_alarm (Untitled2)
- id (Key) — number — 기본 키 — NOT NULL
- alarm_time (Field) — date
- release_time (Field2) — date
- drone_seq (Field3) — number
- drone_plan_seq (Field4) — number
- drone_plan_exec_seq (Field5) — numebr
- alarm_kind (Field6) — varchar
- alarm_level (Field7) — varchar
- Field8
drone_flight_permit (Untitled5)
- mission_seq (Field) — number
- drone_seq (Field2) — number
- process_status (Field3) — char(3)
- applicant_seq (Field4) — number
- processor_seq (Field5) — number
- apply_time (Field6) — date
- process_time (Field7) — date
- process_comment (Field8) — varchar
- Field9
drone_flight_primary (Untitled6)
- seq (Key) — number — 기본 키 — NOT NULL
- create_time (Field) — date
- update_time (Field2) — date
- mission_seq (Field3) — number
- drone_seq (Field4) — number
- drone_takeoff_time (Field5) — date
- drone_landing_time (Field6) — date
- drone_home_position (Field7) — varchar
- drone_boot_time (Field8) — date
- drone_ip_address (Field9) — varchar(50)
- drone_network_access_time (Field10) — date
- flight_status (Field11) — varchar
- mav_protocol_version (Field12) — number
- mav_minor_protocol_version (Field13) — number
- mav_system_id (Field14) — number
- mav_component_id (Field15) — number
- mav_autopilot (Field16) — varchar
- Field17
drone_flight_status (Untitled7)
- drone_seq (Field) — number
- status_time (Field2) — date
- mission_seq (Field3) — numebr
- drone_flight_seq (Field4) — number
- absolute_altitude (Field5) — double
- relative_altitude (Field6) — double
- location (Field7) — varchar
- battery_voltage (Field8) — number
- battery_current (Field9) — number
- battery_remaining (Field10) — number
- heading (Field11) — double
- pitch (Field12) — double
- roll (Field13) — double
- air_speed (Field14) — double
- ground_speed (Field15) — double
- mav_state (Field16) — varchar(10)
- mav_mode (Field17) — varchar(15)
- gps_fix_type (Field18) — varchar(20)
- satellites_visible (Field19) — number
- velocity_x (Field20) — number
- velocity_y (Field21) — number
- velocity_z (Field22) — number
- mav_armed (Field23) — varchar
- Field24
drone_flight_video (Untitled9)
- seq (Key) — number — 기본 키 — NOT NULL
- version (Field) — number
- create_time (Field2) — date
- update_time (Field3) — date
- mission_seq (Field4) — number
- drone_flight_seq (Field5) — number
- streaming_remote_host (Field6) — varchar
- streaming_remote_port (Field7) — number
- streaming_channel_id (Field8) — varchar
- streaming_url (Field9) — varchar
- fpv_flag (Field10) — boolean
- vod_url (Field11) — varchar(100)
- vod_file_path (Field12) — varchar(100)
- streaming_start_time (Field13) — date
- streaming_end_time (Field14) — date
- streaming_open_result (Field15) — varchar(15)
- streaming_open_fail_reason (Field16) — varchar(100)
- streaming_close_result (Field17) — varchar(15)
- streaming_close_fail_reason (Field18) — varchar(100)
- open_status (Field19) — varchar
- channel_open_seq (Field20) — number
- Field21
drone_operation_log (Untitled10)
- seq (Key) — number — 기본 키 — NOT NULL
- mission_seq (Field) — number
- drone_seq (Field2) — number
- command_issuer (Field3) — number
- command_source (Field4) — varchar
- command_source (Field5) — varchar(50)
- command_args (Field6) — varchar(100)
- command_result (Field7) — varchar
- command_fail_reason (Field8) — varchar
drone_port_allocation (Untitled11)
- control_message_port (Field) — number
- video_transfer_port (Field2) — number
- sub_video_transfer_port (Field3) — number
- gcs_connect_port (Field4) — number
- use_flag (Field5) — boolean
- portAllocation (Field6)
file_store_info (Untitled12)
- original_filename (Field) — varchar(100)
- mime_type (Field2) — varchar(80)
- store_url (Field3) — varchar(255)
- image_flag (Field4) — boolean
- description (Field5) — varchar(100)
- thumb_image_url (Field6) — varchar(250)
- Field7
flight_zone_management (Untitled13)
- zone_name (Field) — varchar(50)
- flight_limit_kind (Field2) — varchar
- release_flag (Field3) — boolean
- zone_shape_kind (Field4) — varchar
- points (Field5)
- radius (Field6) — number
- zone_address (Field7) — varvhar(100)
- Field8
mission_equipment (Untitled8)
- seq (Key) — number — 기본 키 — NOT NULL
- mission_plan_seq (Field) — number
- equipment_kind (Field2) — varchar
- model_name (Field3) — varchar(50)
- maker_name (Field4) — varchar(50)
- Field5
mission_equipment (Untitled14)
- seq (Key) — number — 기본 키 — NOT NULL
- mission_plan_seq (Field) — number
- equipment_kind (Field2) — varchar
- model_name (Field3) — varchar(50)
- maker_name (Field4) — varchar(50)
- Field5
mission_pilot (Untitled15)
- mission_plan_seq (Key) — number — 기본 키 — NOT NULL
- user_seq (Field) — number
- Field2
mission_plan (Untitled16)
- company_seq (Field) — number
- drone_seq (Field2) — number
- plan_start_date (Field3) — date
- plan_start_time (Field4) — date
- plan_end_date (Field5) — date
- plan_end_time (Field6) — date
- mission_title (Field7) — varchar
- mission_purpose (Field8) — varchar(50)
- flight_method (Field9) — varchar(50)
- mission_details (Field10) — varchar(500)
- plan_status (Field11) — varchar
- applicant_seq (Field12) — number
- processor_seq (Field13) — number
- apply_time (Field14) — date
- process_time (Field15) — date
- drone_channel_port (Field16) — number
- gcs_channel_port (Field17) — number
- video_incoming_port (Field18) — number
- sub_video_incoming_port (Field19) — number
- video_outgoing_port (Field20) — number
- sub_video_outgoing_port (Field21) — number
- process_comment (Field22) — varchar
- flight_zone_address (Field23)
- flight_zone (Field24)
- flight_radius (Field25)
- missionPlan (Field26)
- mission_seq (Field27)
- mission_exec_status (Field28) — varchar
- altitude_limit (Field29) — number
- applicant (Field30)
- processor (Field31)
mission_plan_read_history (Untitled17)
- mission_seq (Field) — number
- user_seq (Field2) — number
- read_time (Field3) — date
notam (Untitled18)
- notam_seq (Key) — number — 기본 키 — NOT NULL
- notam_no (Field) — varchar(20)
- location (Field2) — varchar(20)
- issue_time (Field3) — date
- effective_start_time (Field4) — date
- effective_end_time (Field5) — date
- qcode (Field6) — varchar(20)
- qcode_mean (Field7) — varchar(100)
- series (Field8) — varchar(10)
- ecode (Field9) — varchar(250)
- ais_type (Field10) — varchar(10)
- full_text (Field11) — varchar(1000)
- fir (Field12) — varchar(10)
- notam_no_ko (Field13) — varchar(20)
- fir_ko (Field14) — varchar(50)
- qcode_mean_ko (Field15) — varchar(200)
- location_ko (Field16) — varchar(50)
- radius_ko (Field17) — varchar(10)
- altitude_ko (Field18) — varchar(20)
- flight_way_ko (Field19) — varchar(20)
- purpose_ko (Field20) — varchar(50)
- application_scope_ko (Field21) — varchar(50)
- json_message (Field22) — varchar(2000)
- json_message_ko (Field23) — varchar(2000)
operation_history (Untitled19)
- seq (Key) — number — 기본 키 — NOT NULL
- operator_seq (Field) — numebr
- operation_time (Field2) — date
- operation_kind (Field3)
- operation_content (Field4) — varchar
- Field5
otp_verification (Untitled20)
- seq (Key) — number — 기본 키 — NOT NULL
- info_kind (Field) — varvhar
- verifying_value (Field2) — varchar
- otp_issue_time (Field3) — date
- otp_expire_time (Field4) — date
- otp (Field5) — varchar
- otp_use_flag (Field6) — boolean
- Field7
user_event_box (Untitled22)
- seq (Key) — number — 기본 키 — NOT NULL
- user_seq (Field) — number
- event_kind (Field2) — varchar
- event_ref_seq (Field3) — number
- event_group_seq (Field4) — number
- event_time (Field5) — date
- admin_event (Field6) — boolean
- read_flag (Field7) — boolean
- read_time (Field8) — date
- eventMessage (Field9) — varchar
- companyName (Field10) — varchar
- eventTitle (Field11) — varchar
- Field12
user_info (Untitled21)
- user_id (Field) — varchar
- password (Field2) — varchar
- user_role (Field3) — varchar
- name (Field4) — varchar
- company_seq (Field5)
- company_position (Field6) — varchar
- email_address (Field7) — varchar
- drone_pilot_flag (Field8) — boolean
- drone_pilot_no (Field9) — varchar
- login_fail_count (Field10) — number
- last_login_try_time (Field11) — date
- last_login_success_time (Field12) — date
- account_locking_reason (Field13) — varchar
- account_effective_date (Field14) — date
- account_expired_date (Field15) — date
- credentials_expired_date (Field16) — date
- account_locked (Field17) — boolean
- password_update_required (Field18) — boolean
- deleted (Field19) — boolean
- user_status (Field20) — varchar
- user_status_date (Field21) — date
- profile_image_seq (Field22)
- withdrawal_reason (Field23) — varchar
- Field24
weather_sector (Untitled23)
- seq (Key) — number — 기본 키 — NOT NULL
- version (Field) — number
- create_time (Field2) — date
- update_time (Field3)
- emd_code (Field4) — varchar
- sido_name (Field5) — varchar
- sigungu_name (Field6) — varchar
- emd_name (Field7) — varchar
- grid_x (Field8) — number
- grid_y (Field9) — number
- location (Field10)
- org_data_modified_date (Field11) — date
- use_flag (Field12) — boolean
- rain (Field13) — varchar
- rain_quantity (Field14) — varchar
- temperature (Field15) — varchar
- wind_direction (Field16) — varchar
- wind_speed (Field17) — varchar
- humidity (Field18) — varchar
- base_date (Field19) — varchar
- base_time (Field20) — varchar
- Field21
드론비행 산출 (drone_flight_output)
- mission_seq (Key) — number — 기본 키 — NOT NULL
- mime_type (Field) — varchar(50)
- output_filename (Field2) — varchar(50)
- output_store_url (Field3) — varchar(100)
- output_file_path (Field4) — varchar
- output_size (Field5) — long
- output_desc (Field6) — varchar(500)
- delete_ban_flag (Field7) — boolean
- Field8
드론정보 (drone_info)
- 회사seq (company_seq) — 외래 키 → 회사정보.회사seq — NOT NULL
- drone_name (Field) — varchar(20)
- registration_no (Field2) — varchar(20)
- drone_kind (Field3) — varchar(10)
- model_name (Field4) — varchar(50)
- maker_name (Field5) — varchar(50)
- serial_no (Field6) — varchar(50)
- making_date (Field7) — date
- drone_height (Field8) — float
- drone_length (Field9) — float
- drone_width (Field10) — float
- drone_weight_kind (Field11) — varchar(10)
- operation_purpose (Field12) — varchar(10)
- safety_certificate_no (Field13) — varchar(20)
- safety_certificate_begin_date (Field14) — varchar(10)
- safety_certificate_end_date (Field15) — varchar(10)
- insurance_subscription_flag (Field16) — boolean
- vtol_flag (Field17) — boolean
- max_takeoff_weight (Field18) — float
- drone_weight (Field19) — float
- power_kind (Field20) — varchar
- drone_image_seq (Field21)
- deleted (Field22) — boolean
회사정보 (company_info)
- 회사seq (company_seq) — 기본 키 — NOT NULL
- name (Field) — varchar(50)
- business_license_no (Field2) — varchar(10)
- address (Field3) — varchar(100)
- address_details (Field4) — varchar(50)
- zip_code (Field5) — varchar(6)
- representative_name (Field6) — varchar(50)
- company_tel_no (Field7) — varchar(15)
- company_email_addr (Field8) — varchar(50)
- company_mobile_no (Field9) — varchar(20)
- homepage_url (Field10) — varchar
- profit_corporate_flag (Field11) — boolean
- allowed_member_size (Field14) — number
- drone_business_license_file_seq (Field12)
- business_license_file_seq (Field13)