드론 프로젝트
테이블 (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)