전남 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)