드론 프로젝트

테이블 (16)

drone

  • id — Long — 기본 키 — NOT NULL
  • droneDetailsId (drone_details_id) — Long — 외래 키 → droneDetails.id — NOT NULL
  • droneBaseId (drone_base_id) — Long — 외래 키 → droneBase.id — NOT NULL
  • droneDeviceName (drone_device_name) — varchar(255)
  • userId (user_id) — varchar(255)
  • socketIndex (sokcet_index) — Long
  • updateDt (update_dt) — Timestamp
  • armStatus (arm_status) — int
  • status — varchar(255)

droneBase (drone_base)

  • id — Long — 기본 키 — NOT NULL
  • baseName (base_name) — varchar(255)

droneDetails (drone_details)

  • id — Long — 기본 키 — NOT NULL
  • flightTime (flight_time) — int
  • insertDt (insert_dt) — timestamp
  • insertUserId (insert_user_id) — Long
  • manufacturer — varchar(255)
  • masterManager (master_manager) — varchar(255)
  • maximumManagementAltitude (maximum_management_altitude) — int
  • maximumOperatingDistance (maximum_operating_distance) — int
  • maximumOperatingSpeed (maximum_operating_speed) — float
  • maximumOperatingWeight (maximum_operating_weight) — int
  • maximumSpeed (maximum_speed) — int
  • operatingTemperatureRangeMax (operating_temperature_range_max) — float
  • operatingTemperatureRangeMin (operating_temperature_range_min) — float
  • simNumber (sim_number) — varchar(255)
  • size — varchar(255)
  • size1 — int
  • size2 — int
  • size3 — int
  • subManager (sub_manager) — varchar(255)
  • thumbnailImg (thumbnail_img) — varchar(255)
  • thumbnailRealImg (thumbnail_real_img) — varchar(255)
  • type — varchar(255)
  • update_dt (timestamp) — varchar(255)
  • weight — float
  • Field

droneInMission (drone_in_mission)

  • id — Long — 기본 키 — NOT NULL
  • droneSeq (drone_seq) — Long — 외래 키 → drone.id — NOT NULL
  • missionSeq (mission_seq) — Long — 외래 키 → mission.id — NOT NULL

droneLog (drone_log)

  • id — Long — 기본 키 — NOT NULL
  • droneDeviceName (drone_device_name) — varchar(255)
  • insertDt (insert_dt) — timestamp
  • missionName (mission_name) — varchar(255)

droneLogDetails (drone_log_details)

  • id — Long — 기본 키 — NOT NULL
  • droneLogId (drone_log_id) — Long — 외래 키 → droneLog.id — NOT NULL
  • fromTarget (from_target) — varchar(255)
  • insertTime (insert_time) — timestamp
  • param1 — varchar(255)
  • param2 — varchar(255)
  • param3 — varchar(255)
  • param4 — varchar(255)
  • param5 — varchar(255)
  • param6 — varchar(255)
  • param7 (Field) — varchar(255)
  • toTarget (to_target) — varchar(255)
  • type (typev) — varchar(255)

droneSocket (drone_socket)

  • index — Long — 기본 키 — NOT NULL
  • ip — varchar(255)
  • localport — varchar(255)
  • port — varchar(255)
  • systemId (system_id) — int

mission

  • id — Long — 기본 키 — NOT NULL
  • droneId (drone_id) — int
  • estimatedTime (estimated_time) — int
  • name — varchar(255)
  • totalDistance (total_distance) — varchar(255)
  • updateDt (update_dt) — timestamp
  • userId (user_id) — varchar(255)

missionDetails (mission_details)

  • id — Long — 기본 키 — NOT NULL
  • missionId (mission_id) — Long — 외래 키 → mission.id — NOT NULL
  • alt — int
  • gpsX (gps_x) — double
  • gpsY (gps_y) — double
  • index — int
  • koName (ko_name) — varchar(255)
  • radius — int
  • speed — int
  • time — int
  • yaw — double

permit

  • id — Long — 기본 키 — NOT NULL
  • codeId (code_id) — varchar(255)
  • codeName (code_name) — varchar(255)
  • codeValue (code_value) — varchar(255)

permitMenu (permit_menu)

  • id — Long — 기본 키 — NOT NULL
  • codeId (code_id) — varchar(255)
  • codeName (code_name) — varchar(255)
  • codeValue (code_value) — varchar(255)

user

  • userSeq (user_seq) — Long — 기본 키 — NOT NULL
  • status — varchar(255) — 외래 키 → userStatus.codeId — NOT NULL
  • address — varchar(255)
  • detailAddress (detail_address) — varchar(255)
  • email — varchar(255)
  • insertDt (insert_dt) — timestamp
  • insertUserSeq (insert_user_seq) — Long
  • lastLoginDt (last_login_dt) — timestamp
  • password — varchar(255)
  • tel — varchar(255)
  • updateDt (update_dt) — timestamp
  • id — varchar(255)
  • userName (user_name) — varchar(255)

userGroup (user_group)

  • id — Long — 기본 키 — NOT NULL
  • groupDesc (group_desc) — varchar(255)
  • groupName (group_name) — varchar(255)
  • insertDt (insert_dt) — timestamp
  • insertUserSeq (insert_user_seq) — Long
  • updateDt (update_dt) — timestamp
  • updateUserSeq (update_user_seq) — Long
  • userGroupStatus (user_group_status) — varchar(255)

userGroupPermit (group_permit)

  • id — Long — 기본 키 — NOT NULL
  • userGroupSeq (user_group_seq) — Long — 외래 키 → userGroup.id — NOT NULL
  • permitSeq (permit_seq) — Long — 외래 키 → permit.id — NOT NULL
  • permitMenuSeq (permit_menu_seq) — Long — 외래 키 → permitMenu.id — NOT NULL
  • insertDt (insert_dt) — timestamp
  • insertUserSeq (insert_user_seq) — Long

userInGroup (user_in_group)

  • id — Long — 기본 키 — NOT NULL
  • userSeq (user_seq) — Long — 외래 키 → user.userSeq — NOT NULL
  • userGroupSeq (user_group_seq) — Long — 외래 키 → userGroup.id — NOT NULL
  • codeId (code_id) — varchar(255) — 외래 키 → user.status — NOT NULL
  • insertDt (insert_dt) — timestamp
  • insertUserSeq (insert_user_seq) — Long

userStatus (user_status)

  • codeId (code_id) — varchar(255) — 기본 키 — NOT NULL
  • codeName (code_name) — varchar(255)
  • codeValue (code_value) — varchar(255)