| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969 |
- # Generated by Django 2.1.4 on 2023-06-27 09:25
- from django.db import migrations, models
- class Migration(migrations.Migration):
- initial = True
- dependencies = [
- ]
- operations = [
- migrations.CreateModel(
- name='DeviceUser',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('user_tag', models.IntegerField(choices=[(1, '专业用户'), (2, '销售用户'), (3, '普通用户')], default=3, verbose_name='用户分类')),
- ('uid', models.PositiveIntegerField(default=0, unique=True)),
- ('role_id', models.PositiveIntegerField(default=0)),
- ('mobile', models.CharField(default='', max_length=15)),
- ('username_change_times', models.PositiveIntegerField(default=0)),
- ('email', models.EmailField(default='', max_length=80)),
- ('real_name', models.CharField(default='', max_length=100)),
- ('image', models.CharField(default='', max_length=100)),
- ('state', models.PositiveIntegerField(default=1)),
- ('province', models.CharField(default='', max_length=50, verbose_name='设备归属 省')),
- ('city', models.CharField(default='', max_length=50, verbose_name='设备归属 市')),
- ('district', models.CharField(default='', max_length=50, verbose_name='设备归属 县')),
- ('remark', models.TextField(default='', verbose_name='用户备注')),
- ('regiest_source', models.PositiveIntegerField(default=0)),
- ('login_time', models.PositiveIntegerField(default=0)),
- ('user_type', models.PositiveIntegerField(default=4)),
- ('user_area', models.CharField(default='', max_length=50, verbose_name='用户区域')),
- ('package_time', models.PositiveIntegerField(default=31536000)),
- ('addtime', models.PositiveIntegerField(default=0)),
- ('uptime', models.PositiveIntegerField(default=0)),
- ('user_group_id', models.PositiveIntegerField(default=0)),
- ('tets_user', models.PositiveIntegerField(default=0)),
- ('children_num', models.PositiveIntegerField(default=0)),
- ('identify_model', models.CharField(default='A', max_length=5)),
- ('user_purviews', models.TextField(verbose_name='角色拥有的用户权限')),
- ('user_purviews_init', models.BooleanField(default=False, verbose_name='是否初始化用户权限')),
- ('sms_count', models.PositiveIntegerField(default=100)),
- ('pay_sms_count', models.PositiveIntegerField(default=0)),
- ('other_uuid', models.CharField(default='', max_length=512, verbose_name='第三方登陆对接用户唯一标识')),
- ('other_type', models.CharField(default='', max_length=16, verbose_name='第三方登陆用户类型标识')),
- ('user_attribute', models.IntegerField(default=0, verbose_name='用户属性,0 表示标准用户,1 表示中性用户')),
- ('api_token', models.CharField(default='', max_length=32, verbose_name='用户调用接口令牌')),
- ],
- options={
- 'verbose_name': 'user',
- 'verbose_name_plural': 'users',
- 'db_table': 'sa_device_user',
- 'abstract': False,
- },
- ),
- migrations.CreateModel(
- name='MongoAlarm_Record',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('equip_id', models.CharField(max_length=50)),
- ('alarm_time', models.IntegerField(default=0)),
- ('equip_type', models.CharField(max_length=50)),
- ('alarm_desc', models.TextField(blank=True, null=True, verbose_name='预警描述')),
- ],
- options={
- 'verbose_name': '设备预警',
- 'verbose_name_plural': '设备预警',
- 'db_table': 'sa_alarm_record',
- },
- ),
- migrations.CreateModel(
- name='MongoAreaIrrigate',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属基地')),
- ('land', models.CharField(default='', max_length=50, verbose_name='操作地块')),
- ('batch', models.CharField(blank=True, max_length=20, null=True, verbose_name='批次名称')),
- ('area', models.CharField(blank=True, max_length=20, null=True, verbose_name='灌溉面积')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_irrigate_info',
- },
- ),
- migrations.CreateModel(
- name='MongoAreaJob',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属基地')),
- ('land', models.CharField(default='', max_length=50, verbose_name='操作地块')),
- ('batch', models.CharField(blank=True, max_length=20, null=True, verbose_name='批次名称')),
- ('jobname', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作事项')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_job_info',
- },
- ),
- migrations.CreateModel(
- name='MongoAreaManure',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属基地')),
- ('land', models.CharField(default='', max_length=50, verbose_name='操作地块')),
- ('manureuse', models.CharField(default='', max_length=50, verbose_name='肥料用量')),
- ('batch', models.CharField(blank=True, max_length=20, null=True, verbose_name='批次名称')),
- ('itemname', models.CharField(blank=True, max_length=20, null=True, verbose_name='肥料名称')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_manura_info',
- },
- ),
- migrations.CreateModel(
- name='MongoAreaMedi',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属基地')),
- ('land', models.CharField(default='', max_length=50, verbose_name='操作地块')),
- ('batch', models.CharField(blank=True, max_length=20, null=True, verbose_name='批次名称')),
- ('mediname', models.CharField(blank=True, max_length=20, null=True, verbose_name='药品名称')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_medi_info',
- },
- ),
- migrations.CreateModel(
- name='MongoAreaPick',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('pickname', models.CharField(default='', max_length=50, verbose_name='采收名称')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属基地')),
- ('land', models.CharField(default='', max_length=50, verbose_name='操作地块')),
- ('batch', models.CharField(blank=True, max_length=20, null=True, verbose_name='批次名称')),
- ('picktotal', models.CharField(blank=True, max_length=20, null=True, verbose_name='采收总量')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_pick_info',
- },
- ),
- migrations.CreateModel(
- name='MongoAscendCode',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farmid', models.CharField(default='', max_length=50, verbose_name='基地id')),
- ('landid', models.CharField(default='', max_length=50, verbose_name='地块id')),
- ('farmname', models.CharField(blank=True, max_length=20, null=True, verbose_name='基地名称')),
- ('landname', models.CharField(blank=True, max_length=20, null=True, verbose_name='地块名称')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('is_pick', models.IntegerField(default=0, verbose_name='是否采收')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_ascendcode',
- },
- ),
- migrations.CreateModel(
- name='MongoAttractphoto',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('addr', models.CharField(default=0, max_length=200, verbose_name='照片路径')),
- ('at', models.CharField(default=0, max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(default=0, max_length=50, verbose_name='环境湿度')),
- ('describe', models.CharField(default=0, max_length=50, verbose_name='描述')),
- ('indentify_photo', models.CharField(default=0, max_length=200, verbose_name='识别照片路径')),
- ('indentify_result', models.CharField(default=0, max_length=100)),
- ('photo_status', models.PositiveIntegerField(default=1)),
- ('is_mark', models.PositiveIntegerField(default=0)),
- ('mark', models.TextField(default='[]')),
- ],
- options={
- 'db_table': 'sa_device_attract_photo',
- },
- ),
- migrations.CreateModel(
- name='MongoBase',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('base_user', models.CharField(blank=True, max_length=20, null=True, verbose_name='基地所属用户')),
- ('base_name', models.CharField(blank=True, max_length=20, null=True, verbose_name='基地名称')),
- ('base_charge', models.CharField(blank=True, max_length=20, null=True, verbose_name='负责人')),
- ('base_phone', models.CharField(blank=True, max_length=20, null=True, verbose_name='联系电话')),
- ('base_img', models.CharField(blank=True, max_length=500, null=True, verbose_name='基地图片')),
- ('base_area', models.CharField(blank=True, max_length=10, null=True, verbose_name='基地面积')),
- ('base_equip', models.TextField(blank=True, null=True, verbose_name='绑定设备')),
- ('base_describe', models.TextField(blank=True, null=True, verbose_name='基地描述')),
- ('lng', models.CharField(blank=True, max_length=50, null=True, verbose_name='经度')),
- ('lat', models.CharField(blank=True, max_length=50, null=True, verbose_name='纬度')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_base_table',
- },
- ),
- migrations.CreateModel(
- name='MongoBZYData',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.PositiveIntegerField(default=0, verbose_name='设备自增id')),
- ('device_data', models.TextField(default='', verbose_name='具体历史状态数据')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_bzy_data',
- },
- ),
- migrations.CreateModel(
- name='MongoBZYphoto',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('addr', models.CharField(default='', max_length=200, verbose_name='照片路径')),
- ('at', models.CharField(default='', max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(default='', max_length=50, verbose_name='环境湿度')),
- ('describe', models.CharField(default='', max_length=50, verbose_name='描述')),
- ('indentify_photo', models.CharField(default='', max_length=200, verbose_name='识别照片路径')),
- ('indentify_result', models.CharField(default='', max_length=100)),
- ('photo_status', models.PositiveIntegerField(default=1)),
- ('mark', models.TextField(default='')),
- ],
- options={
- 'db_table': 'sa_device_bzyphoto',
- },
- ),
- migrations.CreateModel(
- name='MongoCameraAccount',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('account', models.CharField(default=0, max_length=30, verbose_name='账号')),
- ('token', models.CharField(default=0, max_length=80, verbose_name='token')),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('app_key', models.CharField(default=0, max_length=50, verbose_name='用户账号appkey')),
- ('app_secret', models.CharField(default=0, max_length=50, verbose_name='用户账号appsecret')),
- ('salesman', models.CharField(default=0, max_length=50, verbose_name='业务员')),
- ('account_type', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_camera_account',
- },
- ),
- migrations.CreateModel(
- name='MongoCameraData',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('status', models.PositiveIntegerField(default=1, verbose_name='设备状态 1在线 0离线')),
- ('device_info', models.TextField(default='', verbose_name='播放地址')),
- ('camera_playback', models.CharField(default=0, max_length=10, verbose_name='是否支持回放')),
- ('account_id', models.CharField(default=1, max_length=50)),
- ],
- options={
- 'db_table': 'sa_device_camera',
- },
- ),
- migrations.CreateModel(
- name='MongoCameraPhoto',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('addr', models.CharField(blank=True, max_length=200, null=True, verbose_name='照片路径')),
- ('photo_status', models.PositiveIntegerField(default=1)),
- ],
- options={
- 'db_table': 'sa_device_camera_photo',
- },
- ),
- migrations.CreateModel(
- name='MongoCBDData',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.PositiveIntegerField(default=0, verbose_name='设备自增id')),
- ('device_data', models.TextField(default='', verbose_name='具体历史状态数据')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_cbd_data',
- },
- ),
- migrations.CreateModel(
- name='MongoCBDPestWarning',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.TextField(default='', verbose_name='设备号')),
- ('user_id', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='用户id')),
- ('warning_name', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='预警设置名称')),
- ('warning_content', models.TextField(default='', verbose_name='预警内容')),
- ('warning_types', models.CharField(default=0, max_length=10, verbose_name='预警类型')),
- ('upltime', models.IntegerField(default=0, verbose_name='预警时间')),
- ('send_user', models.TextField(default='', verbose_name='发送用户')),
- ('status', models.IntegerField(default=0, verbose_name='是否已读')),
- ],
- options={
- 'db_table': 'sa_device_cbd_pest_warning',
- },
- ),
- migrations.CreateModel(
- name='MongoCBDphoto',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('addr', models.CharField(default='', max_length=200, verbose_name='照片路径')),
- ('at', models.CharField(default='', max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(default='', max_length=50, verbose_name='环境湿度')),
- ('describe', models.CharField(default='', max_length=50, verbose_name='描述')),
- ('indentify_photo', models.CharField(default='', max_length=200, verbose_name='识别照片路径')),
- ('indentify_result', models.CharField(default='', max_length=100)),
- ('photo_status', models.PositiveIntegerField(default=1)),
- ('is_mark', models.PositiveIntegerField(default=0)),
- ('mark', models.TextField(default='[]')),
- ('label', models.TextField(blank=True)),
- ],
- options={
- 'db_table': 'sa_device_cbdphoto',
- },
- ),
- migrations.CreateModel(
- name='MongoCBDphoto_B',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('addr', models.CharField(default='', max_length=200, verbose_name='照片路径')),
- ('at', models.CharField(default='', max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(default='', max_length=50, verbose_name='环境湿度')),
- ('describe', models.CharField(default='', max_length=50, verbose_name='描述')),
- ('indentify_photo', models.CharField(default='', max_length=200, verbose_name='识别照片路径')),
- ('indentify_result', models.CharField(default='', max_length=100)),
- ('photo_status', models.PositiveIntegerField(default=1)),
- ('is_mark', models.PositiveIntegerField(default=0)),
- ('mark', models.TextField(default='[]')),
- ('label', models.TextField(blank=True)),
- ],
- options={
- 'db_table': 'sa_device_cbdphoto_b',
- },
- ),
- migrations.CreateModel(
- name='MongoCBDphoto_C',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('addr', models.CharField(default='', max_length=200, verbose_name='照片路径')),
- ('at', models.CharField(default='', max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(default='', max_length=50, verbose_name='环境湿度')),
- ('describe', models.CharField(default='', max_length=50, verbose_name='描述')),
- ('indentify_photo', models.CharField(default='', max_length=200, verbose_name='识别照片路径')),
- ('indentify_result', models.CharField(default='', max_length=100)),
- ('photo_status', models.PositiveIntegerField(default=1)),
- ('is_mark', models.PositiveIntegerField(default=0)),
- ('mark', models.TextField(default='[]')),
- ('label', models.TextField(blank=True)),
- ],
- options={
- 'db_table': 'sa_device_cbdphoto_c',
- },
- ),
- migrations.CreateModel(
- name='MongoCooperationUnit',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('briefing', models.TextField(blank=True, null=True, verbose_name='简介')),
- ('name', models.CharField(blank=True, max_length=20, null=True, verbose_name='名称')),
- ('img_urls', models.CharField(blank=True, max_length=300, null=True, verbose_name='图片路径')),
- ('code', models.CharField(blank=True, max_length=10, null=True, verbose_name='单位与院校与专家')),
- ],
- options={
- 'verbose_name': '专家单位与院校表',
- 'verbose_name_plural': '专家单位与院校表',
- 'db_table': 'sa_cooperation_unit',
- },
- ),
- migrations.CreateModel(
- name='MongoDevice',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(max_length=50, unique=True, verbose_name='设备本身id')),
- ('dver_num', models.CharField(default='', max_length=50, verbose_name='设备固件版本号')),
- ('device_model', models.PositiveIntegerField(default=0)),
- ('device_type_id', models.PositiveIntegerField(default=0, verbose_name='设备类型id')),
- ('device_name', models.CharField(default='', max_length=50, verbose_name='设备名称')),
- ('owner_uid', models.PositiveIntegerField(default=0, verbose_name='负责人uid')),
- ('user_dealer', models.PositiveIntegerField(default=0, verbose_name='负责人uid')),
- ('province', models.CharField(default='', max_length=50, verbose_name='设备归属 省')),
- ('city', models.CharField(default='', max_length=50, verbose_name='设备归属 市')),
- ('district', models.CharField(default='', max_length=50, verbose_name='设备归属 县')),
- ('device_code', models.PositiveIntegerField(default=0, verbose_name='设备编码 当设备为性诱设备的时候必须存在')),
- ('device_status', models.PositiveIntegerField(default=1, verbose_name='设备状态 1在线 0离线')),
- ('off_time', models.PositiveIntegerField(default=0, verbose_name='设备离线时间')),
- ('ftp_push_addr', models.CharField(default='', max_length=50, verbose_name='设备推送图片地址')),
- ('serverconf', models.TextField(default='', verbose_name='服务器配置')),
- ('lng', models.CharField(default='', max_length=50, verbose_name='经度')),
- ('lat', models.CharField(default='', max_length=50, verbose_name='纬度')),
- ('gps', models.PositiveIntegerField(default=2, verbose_name='纬度')),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('glass_slide_time', models.IntegerField(default=0)),
- ('cultivate_time', models.IntegerField(default=0)),
- ('add_position', models.PositiveIntegerField(default=0, verbose_name='是否手动添加位置')),
- ('simid', models.CharField(default='', max_length=50, verbose_name='海康流量卡')),
- ('disable', models.PositiveIntegerField(default=0, verbose_name='禁用识别统计')),
- ('decoy', models.CharField(default='', max_length=50, verbose_name='性诱设备诱芯')),
- ('sim_dealer', models.CharField(default=0, max_length=50, verbose_name='SIM经销商')),
- ('xy_uptime', models.IntegerField(default=0)),
- ('networking', models.CharField(default=0, max_length=10, verbose_name='联网方式')),
- ('equipment', models.CharField(default=0, max_length=10, verbose_name='设备状态')),
- ('sale_uid', models.IntegerField(default=0, verbose_name='销售用户uid')),
- ('salesman_task_number', models.CharField(default=0, max_length=20, verbose_name='销售用户#任务单号')),
- ('whether_equipment_status', models.CharField(default=0, max_length=10, verbose_name='是否更新设备状态')),
- ('device_expire_time', models.IntegerField(default=0)),
- ('device_activation', models.IntegerField(default=0)),
- ('device_expire', models.CharField(default=0, max_length=10, verbose_name='设备是否到期')),
- ('device_expire_days', models.CharField(default=0, max_length=10, verbose_name='设备到期天数')),
- ('water_pump_switch', models.CharField(default=0, max_length=10, verbose_name='水泵开关')),
- ('device_notes', models.CharField(blank=True, default=0, max_length=20, null=True, verbose_name='设备备注')),
- ('water_pump_times', models.CharField(default=0, max_length=10, verbose_name='水泵控制时间')),
- ('water_pump_switch_times', models.CharField(default=0, max_length=10, verbose_name='下发水泵开关的时间')),
- ('xy_expire_time', models.IntegerField(default=0)),
- ('device_tag', models.IntegerField(choices=[(51, '土壤墒情站')], default=0, verbose_name='设备标记')),
- ],
- options={
- 'db_table': 'sa_device',
- },
- ),
- migrations.CreateModel(
- name='MongoDevice_Desc',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(blank=True, max_length=50, null=True, verbose_name='对应的设备id')),
- ('photo_id', models.CharField(blank=True, max_length=50, null=True, verbose_name='照片ID')),
- ('desc_user', models.CharField(blank=True, max_length=50, null=True, verbose_name='添加描述的用户')),
- ('add_time', models.IntegerField(default=0)),
- ('crop_name', models.CharField(blank=True, max_length=20, null=True, verbose_name='作物名称')),
- ('pest_case', models.CharField(blank=True, max_length=30, null=True, verbose_name='虫害情况')),
- ('pest_name', models.CharField(blank=True, max_length=50, null=True, verbose_name='害虫名称')),
- ('pest_num', models.CharField(blank=True, max_length=10, null=True, verbose_name='害虫数量')),
- ('photo_time', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_desc',
- },
- ),
- migrations.CreateModel(
- name='MongoDevice_Payment',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50, verbose_name='设备号')),
- ('device_type', models.CharField(default='', max_length=10, verbose_name='设备类型')),
- ('order_number', models.CharField(default='', max_length=50, verbose_name='订单编号')),
- ('addtime', models.IntegerField(default=0, verbose_name='下单时间')),
- ('upltime', models.IntegerField(default=0, verbose_name='支付时间')),
- ('price', models.CharField(blank=True, max_length=20, null=True, verbose_name='支付钱数')),
- ('menu', models.CharField(blank=True, max_length=20, null=True, verbose_name='套餐')),
- ('payment_method', models.CharField(default=1, max_length=20, verbose_name='支付方式')),
- ('recharge_user', models.CharField(blank=True, max_length=20, null=True, verbose_name='充值用户')),
- ('paystatus', models.CharField(default=0, max_length=20, verbose_name='支付状态')),
- ('paytype', models.PositiveIntegerField(default=0, verbose_name='充值状态')),
- ],
- options={
- 'db_table': 'sa_device_payment',
- },
- ),
- migrations.CreateModel(
- name='MongoDevice_QP_SimInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(blank=True, max_length=50, null=True, verbose_name='设备ID')),
- ('device_name', models.CharField(blank=True, max_length=100, null=True, verbose_name='设备名称')),
- ('device_type', models.CharField(blank=True, max_length=10, null=True, verbose_name='设备类型')),
- ('iccid', models.CharField(blank=True, max_length=30, null=True, verbose_name='iccid')),
- ('msisdn', models.CharField(blank=True, max_length=30, null=True, verbose_name='msisdn')),
- ('imsi', models.CharField(blank=True, max_length=30, null=True, verbose_name='imsi')),
- ('ratePlanExpirationDate', models.CharField(blank=True, max_length=30, null=True, verbose_name='套餐过期时间')),
- ('activeDuration', models.CharField(blank=True, max_length=30, null=True, verbose_name='激活宽限期(天)')),
- ('ratePlanId', models.CharField(blank=True, max_length=20, null=True, verbose_name='卡当前套餐ID')),
- ('sim_type', models.CharField(blank=True, max_length=20, null=True, verbose_name='卡类型')),
- ('totalDataVolume', models.CharField(blank=True, max_length=20, null=True, verbose_name='卡套餐大小, 单位M')),
- ('deviceStatus', models.CharField(blank=True, max_length=10, null=True, verbose_name='卡在运营商的状态')),
- ('useCountAsVolume', models.CharField(blank=True, max_length=10, null=True, verbose_name='卡套餐单位')),
- ('expireDate', models.CharField(blank=True, max_length=20, null=True, verbose_name='过期时间')),
- ('ratePlanEffetiveDate', models.CharField(blank=True, max_length=20, null=True, verbose_name='卡套餐生效时间')),
- ('dataUsage', models.CharField(blank=True, max_length=20, null=True, verbose_name='卡本月用量, 单位M')),
- ('nbCard', models.CharField(blank=True, max_length=10, null=True, verbose_name='是否NB卡')),
- ('imeiStatus', models.CharField(blank=True, max_length=20, null=True, verbose_name='机卡绑定状态')),
- ('orgName', models.CharField(blank=True, max_length=30, null=True, verbose_name='卡所属机构名称')),
- ('testingExpireDate', models.CharField(blank=True, max_length=30, null=True, verbose_name='测试期结束时间')),
- ('usedDataVolume', models.CharField(blank=True, max_length=30, null=True, verbose_name='卡套餐用量')),
- ('lastSyncDate', models.CharField(blank=True, max_length=30, null=True, verbose_name='餐用量同步时间')),
- ('realnameRequired', models.CharField(blank=True, max_length=30, null=True, verbose_name='卡实名需求')),
- ('realNameCertifystatus', models.CharField(blank=True, max_length=30, null=True, verbose_name='卡实名审核状态')),
- ('speedLimit', models.CharField(blank=True, max_length=30, null=True, verbose_name='网络限速值,单位:Kbps')),
- ('carrier', models.CharField(blank=True, max_length=30, null=True, verbose_name='运营商')),
- ('openDate', models.CharField(blank=True, max_length=30, null=True, verbose_name='出库时间')),
- ('iratePlanName', models.CharField(blank=True, max_length=30, null=True, verbose_name='卡当前套餐')),
- ('startDate', models.CharField(blank=True, max_length=30, null=True, verbose_name='激活时间')),
- ('status', models.CharField(blank=True, max_length=30, null=True, verbose_name='SIM卡状态')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_qp_sim_info',
- },
- ),
- migrations.CreateModel(
- name='MongoDevice_SimInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(blank=True, max_length=50, null=True, verbose_name='设备ID')),
- ('device_name', models.CharField(blank=True, max_length=100, null=True, verbose_name='设备名称')),
- ('device_type', models.CharField(blank=True, max_length=10, null=True, verbose_name='设备类型')),
- ('iccid', models.CharField(blank=True, max_length=30, null=True, verbose_name='iccid')),
- ('msisdn', models.CharField(blank=True, max_length=50, null=True, verbose_name='msisdn')),
- ('imsi', models.CharField(blank=True, max_length=30, null=True, verbose_name='imsi')),
- ('sp_code', models.CharField(blank=True, max_length=30, null=True, verbose_name='短信端口')),
- ('carrier', models.CharField(blank=True, max_length=30, null=True, verbose_name='运营商')),
- ('data_plan', models.CharField(blank=True, max_length=20, null=True, verbose_name='套餐大小')),
- ('data_usage', models.CharField(blank=True, max_length=20, null=True, verbose_name='当月用量')),
- ('account_status', models.CharField(blank=True, max_length=20, null=True, verbose_name='卡状态')),
- ('expiry_date', models.CharField(blank=True, max_length=20, null=True, verbose_name='计费结束日期')),
- ('active', models.CharField(blank=True, max_length=10, null=True, verbose_name='激活状态')),
- ('test_valid_date', models.CharField(blank=True, max_length=20, null=True, verbose_name='测试期起始日期')),
- ('silent_valid_date', models.CharField(blank=True, max_length=20, null=True, verbose_name='沉默期起始日期')),
- ('test_used_data_usage', models.CharField(blank=True, max_length=20, null=True, verbose_name='测试期已用流量')),
- ('active_date', models.CharField(blank=True, max_length=20, null=True, verbose_name='激活日期')),
- ('data_balance', models.CharField(blank=True, max_length=20, null=True, verbose_name='剩余流量,单位M')),
- ('outbound_date', models.CharField(blank=True, max_length=20, null=True, verbose_name='出库日期')),
- ('support_sms', models.CharField(blank=True, max_length=10, null=True, verbose_name='是否支持短信')),
- ('sim_alarm', models.TextField(blank=True, null=True, verbose_name='sim卡提示配置')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_sim_info',
- },
- ),
- migrations.CreateModel(
- name='MongoDeviceConfig',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('d_id', models.PositiveIntegerField(default=0, verbose_name='设备自增id')),
- ('device_config', models.TextField(default='', verbose_name='设备配置')),
- ('cmd', models.CharField(max_length=50, verbose_name='配置属性')),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_config',
- },
- ),
- migrations.CreateModel(
- name='MongoDevicePest',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('user', models.CharField(blank=True, max_length=50, null=True, verbose_name='害虫所属用户')),
- ('pest_add_time', models.IntegerField(default=0)),
- ('pest_name', models.CharField(max_length=50, verbose_name='害虫名称')),
- ],
- options={
- 'db_table': 'sa_device_pest',
- },
- ),
- migrations.CreateModel(
- name='MongoDevicePestInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('photo_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('pest_name', models.CharField(default=0, max_length=50)),
- ('pest_num', models.CharField(default=0, max_length=50)),
- ('at', models.CharField(default=0, max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(default=0, max_length=50, verbose_name='环境湿度')),
- ('upltime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_pest_info',
- },
- ),
- migrations.CreateModel(
- name='MongoDeviceTemporary',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('equipment', models.CharField(default=0, max_length=10, verbose_name='设备状态')),
- ('whether_equipment_status', models.CharField(default=0, max_length=10, verbose_name='是否更新设备状态')),
- ('device_expire_time', models.IntegerField(default=0)),
- ('device_activation', models.IntegerField(default=0)),
- ('device_expire', models.CharField(default=0, max_length=10, verbose_name='设备是否到期')),
- ('device_expire_days', models.CharField(default=0, max_length=10, verbose_name='设备到期天数')),
- ],
- options={
- 'db_table': 'sa_device_temporary',
- },
- ),
- migrations.CreateModel(
- name='MongoDeviceType',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('type_name', models.CharField(default='', max_length=50, verbose_name='设备类型名称 ')),
- ('img_url', models.TextField(default='', verbose_name='设备类型图片url地址')),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_type',
- },
- ),
- migrations.CreateModel(
- name='MongoFarmInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('farmname', models.CharField(default='', max_length=50, verbose_name='农场名称')),
- ('farmaddr', models.CharField(default='', max_length=50, verbose_name='农场地址')),
- ('farmdesc', models.CharField(default='', max_length=50, verbose_name='农场描述')),
- ('farmarea', models.CharField(default='', max_length=50, verbose_name='农场面积')),
- ('farmframe', models.CharField(default='', max_length=200, verbose_name='农场坐标点')),
- ('user', models.CharField(default='', max_length=50, verbose_name='所属用户')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_farm_info_record',
- },
- ),
- migrations.CreateModel(
- name='MongoLandInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属农场')),
- ('landname', models.CharField(blank=True, max_length=20, null=True, verbose_name='地块名称')),
- ('landuse', models.CharField(blank=True, max_length=20, null=True, verbose_name='地块用途')),
- ('landaddr', models.CharField(blank=True, max_length=50, null=True, verbose_name='地块地址')),
- ('landarea', models.CharField(blank=True, max_length=20, null=True, verbose_name='地块面积')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_land_info',
- },
- ),
- migrations.CreateModel(
- name='MongoMake_Log',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('log_user', models.CharField(blank=True, max_length=50, null=True, verbose_name='用户名')),
- ('log_time', models.IntegerField(default=0)),
- ('log_ip', models.CharField(blank=True, max_length=100, null=True, verbose_name='IP地址')),
- ('log_desc', models.CharField(blank=True, max_length=100, null=True, verbose_name='操作描述')),
- ],
- options={
- 'verbose_name': '用户操作日志表',
- 'verbose_name_plural': '用户操作日志表',
- 'db_table': 'sa_make_log',
- },
- ),
- migrations.CreateModel(
- name='MongoManual_Alert_Record',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('user_id', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='用户id')),
- ('device_type_id', models.IntegerField(default=0, verbose_name='设备类型')),
- ('conf', models.TextField(default=0, verbose_name='短信预警内容')),
- ('liaisons', models.CharField(max_length=50, verbose_name='联系人名称')),
- ('phone', models.IntegerField(default=0, verbose_name='联系人电话')),
- ('create_time', models.IntegerField(default=0, verbose_name='创建时间')),
- ('status', models.IntegerField(default=0, verbose_name='是否已读')),
- ],
- options={
- 'db_table': 'sa_device_manual_alert_record',
- },
- ),
- migrations.CreateModel(
- name='MongoMenuPerGroupModel',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('name', models.CharField(max_length=20, verbose_name='权限组名称')),
- ('menus', models.TextField(verbose_name='菜单id列表')),
- ('uid', models.IntegerField(verbose_name='创建用户uid')),
- ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
- ('modify_time', models.DateTimeField(auto_now=True, verbose_name='修改时间')),
- ],
- options={
- 'db_table': 'sa_menu_per_group',
- },
- ),
- migrations.CreateModel(
- name='MongoMsg_Conf',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(blank=True, max_length=50, null=True, verbose_name='设备ID')),
- ('conf', models.TextField(blank=True, null=True, verbose_name='短信配置')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_msg_conf',
- },
- ),
- migrations.CreateModel(
- name='MongoMsg_Send',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('mobile', models.CharField(blank=True, max_length=20, verbose_name='手机号')),
- ('equip_id', models.CharField(blank=True, max_length=20, verbose_name='设备号')),
- ('uptime', models.IntegerField(default=0)),
- ('send_dec', models.CharField(blank=True, max_length=300, verbose_name='发送内容')),
- ('result_desc', models.TextField(blank=True, null=True, verbose_name='短信描述')),
- ],
- options={
- 'db_table': 'sa_device_msg_send',
- },
- ),
- migrations.CreateModel(
- name='MongoND_qxz_data',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('csq', models.CharField(max_length=10, verbose_name='信号强度')),
- ('temp', models.CharField(max_length=50, verbose_name='土壤温度')),
- ('swc', models.CharField(max_length=50, verbose_name='土壤湿度')),
- ('atm', models.CharField(max_length=10, verbose_name='大气压强')),
- ('at', models.CharField(max_length=10, verbose_name='空气温度')),
- ('ats', models.CharField(max_length=10, verbose_name='空气湿度')),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ],
- options={
- 'db_table': 'sa_nd_qxz_data',
- },
- ),
- migrations.CreateModel(
- name='MongoND_qxz_status',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('lat', models.CharField(max_length=50, verbose_name='纬度')),
- ('lng', models.CharField(max_length=50, verbose_name='经度')),
- ('topic', models.CharField(default='10', max_length=10, verbose_name='列标题')),
- ('inidepth', models.CharField(default='10', max_length=10, verbose_name='初始深度')),
- ('depth', models.CharField(default='', max_length=50, verbose_name='层级深度')),
- ('csq', models.CharField(max_length=10, verbose_name='信号强度')),
- ('temp', models.CharField(max_length=50, verbose_name='土壤温度')),
- ('swc', models.CharField(max_length=50, verbose_name='土壤湿度')),
- ('atm', models.CharField(max_length=10, verbose_name='大气压强')),
- ('at', models.CharField(max_length=10, verbose_name='空气温度')),
- ('ats', models.CharField(max_length=10, verbose_name='空气湿度')),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ],
- options={
- 'db_table': 'sa_nd_qxz_status',
- },
- ),
- migrations.CreateModel(
- name='MongoNL_Device',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default=0, max_length=50, verbose_name='设备号')),
- ('device_data', models.TextField(default='', verbose_name='具体状态数据')),
- ('protocolType', models.CharField(max_length=50, verbose_name='配置属性')),
- ('addtime', models.IntegerField(default=0)),
- ('at', models.CharField(max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(max_length=50, verbose_name='环境湿度')),
- ],
- options={
- 'db_table': 'sa_nl_device',
- },
- ),
- migrations.CreateModel(
- name='MongoNL_Device_Status',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default=0, max_length=50, verbose_name='设备号')),
- ('addtime', models.IntegerField(default=0)),
- ('at', models.CharField(max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(max_length=50, verbose_name='环境湿度')),
- ('rain', models.CharField(max_length=50, verbose_name='是否下雨')),
- ('wind', models.CharField(max_length=50, verbose_name='风速风向')),
- ('weather', models.CharField(max_length=50, verbose_name='天气')),
- ('warn', models.CharField(max_length=50, verbose_name='害虫预警情况')),
- ('lure', models.CharField(max_length=50, verbose_name='诱芯')),
- ('xy_uptime', models.IntegerField(default=0)),
- ('xy_expire_time', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_nl_device_status',
- },
- ),
- migrations.CreateModel(
- name='MongoOperateLogs',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('uid', models.PositiveIntegerField(default=0, verbose_name='操作用户id')),
- ('target_id', models.CharField(default='', max_length=100, verbose_name='被操作目标id')),
- ('content', models.CharField(max_length=500, verbose_name='操作内容')),
- ('operation_type', models.PositiveIntegerField(default=0, verbose_name='操作类型对设备操作为0 对用户操作为1')),
- ('ip', models.CharField(max_length=100, verbose_name='操作者ip')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_operate_logs',
- },
- ),
- migrations.CreateModel(
- name='MongoOtherUserTypeModel',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('other_name', models.CharField(max_length=50, verbose_name='其他用户公司名称')),
- ('other_type', models.CharField(max_length=50, verbose_name='公司标志')),
- ],
- options={
- 'db_table': 'sa_other_user_type',
- },
- ),
- migrations.CreateModel(
- name='MongoOutStock',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属基地')),
- ('land', models.CharField(default='', max_length=50, verbose_name='所属地块')),
- ('suppliesname', models.CharField(default='', max_length=50, verbose_name='物料名称')),
- ('suppliescode', models.CharField(default='', max_length=50, verbose_name='物料编号')),
- ('typename', models.CharField(default='', max_length=50, verbose_name='品类')),
- ('stockbatch', models.CharField(blank=True, max_length=20, null=True, verbose_name='出库批次')),
- ('stocknum', models.CharField(blank=True, max_length=20, null=True, verbose_name='出库数量')),
- ('firm', models.CharField(blank=True, max_length=20, null=True, verbose_name='生产企业')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_out_stock_info',
- },
- ),
- migrations.CreateModel(
- name='MongoPest_distribute',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('pest_name', models.CharField(max_length=50)),
- ('province', models.CharField(default='', max_length=50, verbose_name='害虫统计 省')),
- ('city', models.CharField(default='', max_length=50, verbose_name='害虫统计 市')),
- ('avg_num', models.CharField(max_length=10)),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'verbose_name': '害虫地域密度',
- 'verbose_name_plural': '害虫地域密度',
- 'db_table': 'sa_pest_distribute',
- },
- ),
- migrations.CreateModel(
- name='MongoPestAnswers',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('pestbank_id', models.CharField(blank=True, max_length=50, null=True)),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='用户')),
- ('title', models.CharField(blank=True, max_length=20, null=True, verbose_name='标题')),
- ('content', models.TextField(blank=True, null=True, verbose_name='问题描述')),
- ('img_urls', models.CharField(blank=True, max_length=500, null=True, verbose_name='图片路径')),
- ('lower', models.CharField(blank=True, default=0, max_length=20, null=True, verbose_name='二级评论')),
- ('user_type', models.CharField(default=0, max_length=20, verbose_name='用户身份')),
- ('adtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'verbose_name': '病虫害提问表',
- 'verbose_name_plural': '病虫害提问表',
- 'db_table': 'sa_pest_answers',
- },
- ),
- migrations.CreateModel(
- name='MongoPestBank',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('course', models.CharField(blank=True, max_length=100, null=True, verbose_name='所属科目')),
- ('name', models.CharField(blank=True, max_length=32, null=True, verbose_name='病虫害名')),
- ('img_urls', models.CharField(blank=True, max_length=300, null=True, verbose_name='识别出来的图片')),
- ('prevention', models.TextField(blank=True, null=True, verbose_name='防止方法')),
- ('search', models.IntegerField(default=0, verbose_name='搜索排名')),
- ('code', models.CharField(blank=True, max_length=10, null=True, verbose_name='病虫害区分')),
- ],
- options={
- 'verbose_name': '病虫害知识库表',
- 'verbose_name_plural': '病虫害知识库表',
- 'db_table': 'sa_pest_bank',
- },
- ),
- migrations.CreateModel(
- name='MongoPestBankNew',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('name', models.CharField(blank=True, max_length=32, null=True, verbose_name='病虫害名')),
- ('alias', models.CharField(blank=True, max_length=32, null=True, verbose_name='别名')),
- ('types', models.CharField(blank=True, max_length=10, null=True, verbose_name='区分')),
- ('cycle', models.CharField(blank=True, max_length=32, null=True, verbose_name='周期')),
- ('distribution', models.CharField(blank=True, max_length=32, null=True, verbose_name='分布')),
- ('pathogen', models.CharField(blank=True, max_length=32, null=True, verbose_name='病原体')),
- ('features', models.CharField(blank=True, max_length=100, null=True, verbose_name='特征')),
- ('habits', models.CharField(blank=True, max_length=300, null=True, verbose_name='习惯')),
- ('host', models.CharField(blank=True, max_length=50, null=True, verbose_name='寄主')),
- ('summary', models.CharField(blank=True, max_length=50, null=True, verbose_name='概括')),
- ('taxonomy', models.CharField(blank=True, max_length=100, null=True, verbose_name='分类')),
- ('symptom', models.CharField(blank=True, max_length=100, null=True, verbose_name='症状')),
- ('prevention', models.TextField(blank=True, null=True, verbose_name='防止方法')),
- ('img_urls', models.TextField(blank=True, null=True, verbose_name='识别出来的图片')),
- ('thumb', models.TextField(blank=True, null=True, verbose_name='类似')),
- ('search', models.IntegerField(default=0, verbose_name='搜索排名')),
- ],
- options={
- 'verbose_name': '新病虫害知识库表',
- 'verbose_name_plural': '新病虫害知识库表',
- 'db_table': 'sa_pest_bank_new',
- },
- ),
- migrations.CreateModel(
- name='MongoPestSupplement',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('pestbank_id', models.CharField(default='', max_length=50)),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='用户')),
- ('content', models.TextField(blank=True, null=True, verbose_name='补充内容')),
- ('review', models.CharField(default=0, max_length=5, verbose_name='是否审核')),
- ('adtime', models.IntegerField(default=0)),
- ],
- options={
- 'verbose_name': '病虫害补充数据表',
- 'verbose_name_plural': '病虫害补充数据表',
- 'db_table': 'sa_pest_supplement',
- },
- ),
- migrations.CreateModel(
- name='MongoPlantInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属农场')),
- ('batch', models.CharField(blank=True, max_length=20, null=True, verbose_name='批次名称')),
- ('land', models.CharField(blank=True, max_length=20, null=True, verbose_name='所属地块')),
- ('planttype', models.CharField(blank=True, max_length=20, null=True, verbose_name='种植类别')),
- ('plantname', models.CharField(blank=True, max_length=20, null=True, verbose_name='作物名称')),
- ('pickcode', models.CharField(default='0', max_length=20, verbose_name='采收状态')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_plant_info',
- },
- ),
- migrations.CreateModel(
- name='MongoProductInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('productphoto', models.CharField(blank=True, max_length=500, null=True, verbose_name='产品图片')),
- ('productdesc', models.CharField(blank=True, max_length=500, null=True, verbose_name='产品描述')),
- ('photo1', models.CharField(blank=True, max_length=500, null=True, verbose_name='生长期1')),
- ('photo2', models.CharField(blank=True, max_length=500, null=True, verbose_name='生长期2')),
- ('photo3', models.CharField(blank=True, max_length=500, null=True, verbose_name='生长期3')),
- ('photo4', models.CharField(blank=True, max_length=500, null=True, verbose_name='生长期4')),
- ('photo5', models.CharField(blank=True, max_length=500, null=True, verbose_name='生长期5')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_product_info',
- },
- ),
- migrations.CreateModel(
- name='MongoProjectArea',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('project_user_id', models.PositiveIntegerField(default=0, verbose_name='项目区域所属用户id')),
- ('project_name', models.CharField(blank=True, max_length=20, null=True, verbose_name='项目区域名称')),
- ('project_coordinates', models.TextField(verbose_name='项目区域坐标')),
- ('addtime', models.IntegerField(default=0)),
- ('upltime', models.IntegerField(default=0)),
- ],
- options={
- 'verbose_name': '大屏项目区域表',
- 'verbose_name_plural': '大屏项目区域表',
- 'db_table': 'sa_project_area',
- },
- ),
- migrations.CreateModel(
- name='MongoPutStock',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属基地')),
- ('land', models.CharField(default='', max_length=50, verbose_name='所属地块')),
- ('suppliesname', models.CharField(default='', max_length=50, verbose_name='物料名称')),
- ('suppliescode', models.CharField(default='', max_length=50, verbose_name='物料编号')),
- ('typename', models.CharField(default='', max_length=50, verbose_name='品类')),
- ('stockbatch', models.CharField(blank=True, max_length=20, null=True, verbose_name='入库批次')),
- ('stocknum', models.CharField(blank=True, max_length=20, null=True, verbose_name='入库数量')),
- ('firm', models.CharField(blank=True, max_length=20, null=True, verbose_name='生产企业')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_put_stock_info',
- },
- ),
- migrations.CreateModel(
- name='MongoQualityInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('qualitydesc', models.CharField(blank=True, max_length=30, null=True, verbose_name='质检标题')),
- ('qualityphoto', models.CharField(blank=True, max_length=300, null=True, verbose_name='质检图片')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_quality_info',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Alarm',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('conf', models.TextField(blank=True, null=True, verbose_name='短信配置')),
- ('phone', models.CharField(blank=True, max_length=20, verbose_name='手机号')),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ],
- options={
- 'db_table': 'sa_qxz_alarm',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Alarm_Log',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('logs', models.TextField(blank=True, null=True, verbose_name='短信反馈')),
- ('ekey', models.CharField(blank=True, max_length=20, verbose_name='通道号')),
- ('info', models.CharField(blank=True, max_length=20, verbose_name='内容')),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ],
- options={
- 'db_table': 'sa_qxz_alarm_log',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Alarm_Log_New',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('user_id', models.CharField(default='', max_length=50, verbose_name='用户id')),
- ('warning_name', models.CharField(default='', max_length=50, verbose_name='预警设置名称')),
- ('ekey', models.TextField(blank=True, verbose_name='通道号')),
- ('warning_content', models.TextField(default='', verbose_name='预警内容')),
- ('send_user', models.TextField(default='', verbose_name='发送用户')),
- ('status', models.IntegerField(default=0, verbose_name='是否已读')),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ],
- options={
- 'db_table': 'sa_qxz_alarm_log_new',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Alarm_New',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('user_id', models.CharField(default='', max_length=50, verbose_name='用户id')),
- ('warning_id', models.CharField(default='', max_length=50, verbose_name='预警设置id')),
- ('device_id', models.CharField(default='', max_length=50, verbose_name='设备号')),
- ('conf', models.TextField(blank=True, null=True, verbose_name='短信配置')),
- ('send_user_id', models.TextField(default='', verbose_name='多个联系人id')),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ],
- options={
- 'db_table': 'sa_qxz_alarm_new',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Auto_Switch',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ('qxz_auto', models.TextField(blank=True, null=True, verbose_name='气象站阈值')),
- ],
- options={
- 'db_table': 'sa_qxz_auto_switch',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Base_Info',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('volt', models.CharField(blank=True, max_length=20, null=True, verbose_name='电压')),
- ('rssi', models.CharField(blank=True, max_length=20, null=True, verbose_name='信号强度')),
- ('iccid', models.CharField(blank=True, max_length=50, null=True, verbose_name='设备卡号')),
- ('lng', models.CharField(blank=True, max_length=50, null=True, verbose_name='经度')),
- ('lat', models.CharField(blank=True, max_length=50, null=True, verbose_name='纬度')),
- ('led', models.CharField(blank=True, max_length=10, null=True, verbose_name='led点阵屏')),
- ('ledinfo', models.CharField(blank=True, max_length=100, null=True, verbose_name='led屏幕内容')),
- ('dver', models.CharField(blank=True, max_length=100, null=True, verbose_name='设备版本号')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_qxz_base_info',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Conf',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('e1', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道1')),
- ('e2', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道2')),
- ('e3', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道3')),
- ('e4', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道4')),
- ('e5', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道5')),
- ('e6', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道6')),
- ('e7', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道7')),
- ('e8', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道8')),
- ('e9', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道9')),
- ('e10', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道10')),
- ('e11', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道11')),
- ('e12', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道12')),
- ('e13', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道13')),
- ('e14', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道14')),
- ('e15', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道15')),
- ('e16', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道16')),
- ('e17', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道17')),
- ('e18', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道18')),
- ('e19', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道19')),
- ('e20', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道20')),
- ('e21', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道21')),
- ('e22', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道22')),
- ('e23', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道23')),
- ('e24', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道24')),
- ('e25', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道25')),
- ('e26', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道26')),
- ('e27', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道27')),
- ('e28', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道28')),
- ('e29', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道29')),
- ('e30', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道30')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_qxz_conf',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Control_History',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('topic', models.CharField(max_length=30, verbose_name='订阅主题')),
- ('return_value', models.TextField(verbose_name='气象站设备反馈内容')),
- ('return_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ],
- options={
- 'db_table': 'sa_qxz_control_history',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Default_Conf',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('e1', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道1')),
- ('e2', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道2')),
- ('e3', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道3')),
- ('e4', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道4')),
- ('e5', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道5')),
- ('e6', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道6')),
- ('e7', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道7')),
- ('e8', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道8')),
- ('e9', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道9')),
- ('e10', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道10')),
- ('e11', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道11')),
- ('e12', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道12')),
- ('e13', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道13')),
- ('e14', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道14')),
- ('e15', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道15')),
- ('e16', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道16')),
- ('e17', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道17')),
- ('e18', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道18')),
- ('e19', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道19')),
- ('e20', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道20')),
- ('e21', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道21')),
- ('e22', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道22')),
- ('e23', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道23')),
- ('e24', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道24')),
- ('e25', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道25')),
- ('e26', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道26')),
- ('e27', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道27')),
- ('e28', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道28')),
- ('e29', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道29')),
- ('e30', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道30')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_qxz_default_conf',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Info_Record',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('volt', models.CharField(blank=True, max_length=20, null=True, verbose_name='电压')),
- ('rssi', models.CharField(blank=True, max_length=20, null=True, verbose_name='信号强度')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_qxz_info_record',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Switch',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ('qxz_switch_data', models.TextField(blank=True, null=True, verbose_name='气象站开关名字')),
- ],
- options={
- 'db_table': 'sa_qxz_switch',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Switch_Status',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ('qxz_switch', models.TextField(blank=True, null=True, verbose_name='气象站开关')),
- ],
- options={
- 'db_table': 'sa_qxz_switch_status',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZ_Timing_Switch',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('upl_time', models.IntegerField(default=0, verbose_name='上报时间')),
- ('qxz_timing', models.TextField(blank=True, null=True, verbose_name='气象站开关定时')),
- ],
- options={
- 'db_table': 'sa_qxz_timing_switch',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZdata_New',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('uptime', models.IntegerField(default=0)),
- ('e1', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道1')),
- ('e2', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道2')),
- ('e3', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道3')),
- ('e4', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道4')),
- ('e5', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道5')),
- ('e6', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道6')),
- ('e7', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道7')),
- ('e8', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道8')),
- ('e9', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道9')),
- ('e10', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道10')),
- ('e11', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道11')),
- ('e12', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道12')),
- ('e13', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道13')),
- ('e14', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道14')),
- ('e15', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道15')),
- ('e16', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道16')),
- ('e17', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道17')),
- ('e18', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道18')),
- ('e19', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道19')),
- ('e20', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道20')),
- ('e21', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道21')),
- ('e22', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道22')),
- ('e23', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道23')),
- ('e24', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道24')),
- ('e25', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道25')),
- ('e26', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道26')),
- ('e27', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道27')),
- ('e28', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道28')),
- ('e29', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道29')),
- ('e30', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道30')),
- ],
- options={
- 'db_table': 'sa_qxz_data',
- },
- ),
- migrations.CreateModel(
- name='MongoQXZstatus_New',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('is_online', models.CharField(blank=True, max_length=5, null=True, verbose_name='在线状态')),
- ('uptime', models.IntegerField(default=0)),
- ('e1', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道1')),
- ('e2', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道2')),
- ('e3', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道3')),
- ('e4', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道4')),
- ('e5', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道5')),
- ('e6', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道6')),
- ('e7', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道7')),
- ('e8', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道8')),
- ('e9', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道9')),
- ('e10', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道10')),
- ('e11', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道11')),
- ('e12', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道12')),
- ('e13', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道13')),
- ('e14', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道14')),
- ('e15', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道15')),
- ('e16', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道16')),
- ('e17', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道17')),
- ('e18', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道18')),
- ('e19', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道19')),
- ('e20', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道20')),
- ('e21', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道21')),
- ('e22', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道22')),
- ('e23', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道23')),
- ('e24', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道24')),
- ('e25', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道25')),
- ('e26', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道26')),
- ('e27', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道27')),
- ('e28', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道28')),
- ('e29', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道29')),
- ('e30', models.CharField(blank=True, max_length=30, null=True, verbose_name='通道30')),
- ('interval', models.CharField(blank=True, max_length=30, null=True, verbose_name='设备数据上传时间间隔')),
- ],
- options={
- 'db_table': 'sa_qxz_status',
- },
- ),
- migrations.CreateModel(
- name='MongoRole_Projection',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('RTid', models.PositiveIntegerField(default=0, unique=True)),
- ('role_company', models.CharField(blank=True, max_length=50, null=True, verbose_name='公司名称')),
- ('projection_index_title', models.TextField(default='5G+智慧农业云平台', verbose_name='首页标题')),
- ('projection_bzy_title', models.TextField(default='智能孢子监测系统', verbose_name='孢子仪标题')),
- ('projection_fb_title', models.TextField(default='设备分布展示', verbose_name='设备分布标题')),
- ('projection_zh_title', models.TextField(default='数字监测预警系统', verbose_name='设备综合标题')),
- ('projection_cbd_title', models.TextField(default='虫情测报系统', verbose_name='测报灯标题')),
- ('projection_qxz_title', models.TextField(default='气象监测系统', verbose_name='气象站标题')),
- ('water_title', models.TextField(default='水肥一体控制系统展示大屏', verbose_name='水肥默认标题')),
- ('elect_title', models.TextField(default='机井水电双控系统展示大屏', verbose_name='水电默认标题')),
- ('wheat_scab', models.TextField(default='小麦赤霉病检测平台', verbose_name='小麦赤霉病默认标题')),
- ('water_fertilizer_control', models.TextField(default='水肥一体控制系统(X)', verbose_name='水肥一体控制默认标题')),
- ],
- options={
- 'verbose_name': '投屏主题',
- 'verbose_name_plural': '投屏主题',
- 'db_table': 'sa_role_projection',
- },
- ),
- migrations.CreateModel(
- name='MongoRole_Table',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('role_describe', models.CharField(blank=True, max_length=50, null=True, verbose_name='角色描述')),
- ('role_cre_time', models.IntegerField(default=0)),
- ('role_cre_user', models.CharField(blank=True, max_length=20, null=True, verbose_name='角色创建者')),
- ('role_logo', models.CharField(default='/data/home_logo/log.jpg', max_length=200, verbose_name='首页logo')),
- ('role_footer', models.TextField(default='Copyright©2007-2019 All Rrights Resvered\u3000版权所有:河南云飞科技发展有限公司', verbose_name='首页footer信息')),
- ('role_header', models.TextField(default='智慧农业大数据平台', verbose_name='首页header信息')),
- ('qr_show', models.BooleanField(default=True)),
- ],
- options={
- 'verbose_name': '用户组列表',
- 'verbose_name_plural': '用户组列表',
- 'db_table': 'sa_role_table',
- },
- ),
- migrations.CreateModel(
- name='MongoSCDData',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.PositiveIntegerField(default=0, verbose_name='设备自增id')),
- ('device_data', models.TextField(default='', verbose_name='具体历史状态数据')),
- ('addtime', models.IntegerField(default=0)),
- ('device_status', models.CharField(default=1, max_length=10, verbose_name='四情数据区分')),
- ],
- options={
- 'db_table': 'sa_device_scd_data',
- },
- ),
- migrations.CreateModel(
- name='MongoSellInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('sellname', models.CharField(blank=True, max_length=20, null=True, verbose_name='产品名称')),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('selltime', models.CharField(blank=True, max_length=30, null=True, verbose_name='售卖时间')),
- ('batch', models.CharField(blank=True, max_length=30, null=True, verbose_name='售卖批次')),
- ('sellnum', models.CharField(blank=True, max_length=30, null=True, verbose_name='售卖数量')),
- ('clientname', models.CharField(blank=True, max_length=30, null=True, verbose_name='客户名称')),
- ('clienttel', models.CharField(blank=True, max_length=30, null=True, verbose_name='客户电话')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_sell_info',
- },
- ),
- migrations.CreateModel(
- name='MongoSf_Control_Data',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('user', models.CharField(default='', max_length=50)),
- ('relayNum', models.CharField(blank=True, max_length=200, null=True, verbose_name='设备通道操作编号')),
- ('relayState', models.CharField(blank=True, max_length=200, null=True, verbose_name='设备操作记录')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_sf_control_data',
- },
- ),
- migrations.CreateModel(
- name='MongoSf_Data',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('device_data', models.CharField(blank=True, max_length=200, null=True, verbose_name='设备历史数据')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_sf_data',
- },
- ),
- migrations.CreateModel(
- name='MongoSf_Info',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('device_name', models.CharField(default='', max_length=50)),
- ('eleNum', models.CharField(blank=True, max_length=200, null=True, verbose_name='16路要素通道的索引')),
- ('eleName', models.CharField(blank=True, max_length=200, null=True, verbose_name='16路要素通道的名称')),
- ('relayNum', models.CharField(blank=True, max_length=200, null=True, verbose_name='32路继电器通道的索引')),
- ('relayName', models.CharField(blank=True, max_length=200, null=True, verbose_name='32路继电器通道的名称')),
- ('lng', models.CharField(blank=True, max_length=30, null=True, verbose_name='经度')),
- ('lat', models.CharField(blank=True, max_length=30, null=True, verbose_name='纬度')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_sf_info',
- },
- ),
- migrations.CreateModel(
- name='MongoSf_Status',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('device_addr', models.CharField(blank=True, max_length=200, null=True, verbose_name='设备电磁阀定位')),
- ('device_status', models.CharField(blank=True, max_length=200, null=True, verbose_name='当前设备状态')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_sf_status',
- },
- ),
- migrations.CreateModel(
- name='MongoSimInfo',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('iccid', models.CharField(max_length=30, unique=True, verbose_name='sim卡号')),
- ('expiry_time', models.IntegerField(default=0, verbose_name='到期时间')),
- ('sim_type', models.IntegerField(default=0, verbose_name='sim卡厂商')),
- ('sim_data', models.TextField(default='', verbose_name='sim信息')),
- ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
- ('modify_time', models.DateTimeField(auto_now=True, verbose_name='修改时间')),
- ],
- options={
- 'db_table': 'sa_sim_info',
- },
- ),
- migrations.CreateModel(
- name='MongoStockInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('farm', models.CharField(default='', max_length=50, verbose_name='所属基地')),
- ('land', models.CharField(default='', max_length=50, verbose_name='所属地块')),
- ('suppliesname', models.CharField(default='', max_length=50, verbose_name='物料名称')),
- ('suppliescode', models.CharField(default='', max_length=50, verbose_name='物料编号')),
- ('typename', models.CharField(default='', max_length=50, verbose_name='品类')),
- ('stockbatch', models.CharField(blank=True, max_length=20, null=True, verbose_name='库存')),
- ('stocknum', models.CharField(blank=True, max_length=20, null=True, verbose_name='库存数量')),
- ('firm', models.CharField(blank=True, max_length=20, null=True, verbose_name='生产企业')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_stock_info',
- },
- ),
- migrations.CreateModel(
- name='MongoSYCBData',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.PositiveIntegerField(default=0, verbose_name='设备自增id')),
- ('device_data', models.TextField(default='', verbose_name='具体历史状态数据')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_sycb_data',
- },
- ),
- migrations.CreateModel(
- name='MongoTransportInfo',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('backcode', models.CharField(default='', max_length=50, verbose_name='溯源码')),
- ('transname', models.CharField(blank=True, max_length=30, null=True, verbose_name='产品名称')),
- ('stime', models.CharField(blank=True, max_length=30, null=True, verbose_name='发货时间')),
- ('etime', models.CharField(blank=True, max_length=30, null=True, verbose_name='到货时间')),
- ('saddr', models.CharField(blank=True, max_length=30, null=True, verbose_name='发货地点')),
- ('province', models.CharField(blank=True, max_length=30, null=True, verbose_name='省-到货地点')),
- ('city', models.CharField(blank=True, max_length=30, null=True, verbose_name='市-到货地点')),
- ('area', models.CharField(blank=True, max_length=30, null=True, verbose_name='县-到货地点')),
- ('eaddr', models.CharField(blank=True, max_length=30, null=True, verbose_name='到货地点')),
- ('detailaddr', models.CharField(blank=True, max_length=100, null=True, verbose_name='详细到货地址')),
- ('trans', models.CharField(blank=True, max_length=30, null=True, verbose_name='运输方法')),
- ('batch', models.CharField(blank=True, max_length=30, null=True, verbose_name='批次名称')),
- ('user', models.CharField(blank=True, max_length=20, null=True, verbose_name='操作人')),
- ('uptime', models.IntegerField(default=0, verbose_name='操作时间')),
- ],
- options={
- 'db_table': 'sa_transport_info',
- },
- ),
- migrations.CreateModel(
- name='MongoUserDeviceOrderModel',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('uid', models.IntegerField(default=0, verbose_name='负责人uid')),
- ('device_id', models.CharField(max_length=50, verbose_name='设备id')),
- ('order', models.IntegerField(default=0, verbose_name='排序字段')),
- ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
- ],
- options={
- 'db_table': 'sa_user_device_order',
- },
- ),
- migrations.CreateModel(
- name='MongoUserEarlyWarningConfig',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('user_id', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='用户id')),
- ('title', models.CharField(max_length=50, verbose_name='标题')),
- ('create_time', models.IntegerField(default=0, verbose_name='创建时间')),
- ('device_type_id', models.IntegerField(default=0, verbose_name='设备类型')),
- ('status', models.IntegerField(default=1, verbose_name='状态')),
- ],
- options={
- 'db_table': 'sa_device_user_early_warning_config',
- },
- ),
- migrations.CreateModel(
- name='MongoUserLoginLog',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('uid', models.PositiveIntegerField(default=0)),
- ('ip', models.GenericIPAddressField(default='')),
- ('addtime', models.PositiveIntegerField(default=0)),
- ('device_type', models.PositiveIntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_user_login_log',
- },
- ),
- migrations.CreateModel(
- name='MongoUserMenuPerGroupModel',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('uid', models.IntegerField(unique=True, verbose_name='用户uid')),
- ('menus', models.TextField(verbose_name='菜单id列表')),
- ('group_ids', models.CharField(max_length=256, verbose_name='权限组id列表')),
- ],
- options={
- 'db_table': 'sa_user_menu_per_group',
- },
- ),
- migrations.CreateModel(
- name='MongoUserPestWarningSMSConf',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('user_id', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='用户id')),
- ('warning_id', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='预警设置id')),
- ('device_ids', models.TextField(default='', verbose_name='多个设备号')),
- ('warning_type', models.IntegerField(default=0, verbose_name='预警类型')),
- ('conf', models.TextField(default=0, verbose_name='短信预警内容')),
- ('send_user', models.TextField(default=0, verbose_name='多个发送用户')),
- ('create_time', models.IntegerField(default=0, verbose_name='创建时间')),
- ],
- options={
- 'db_table': 'sa_device_user_pest_warning_sms_conf',
- },
- ),
- migrations.CreateModel(
- name='MongoUserSaleDevice',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('uid', models.PositiveIntegerField(verbose_name='用户UID')),
- ('device_id', models.CharField(max_length=50, unique=True, verbose_name='设备本身id')),
- ],
- options={
- 'db_table': 'sa_user_sale_device',
- },
- ),
- migrations.CreateModel(
- name='MongoUserUploadsPictures',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('uid', models.PositiveIntegerField(default=0, verbose_name='用户ID')),
- ('addr', models.CharField(default='', max_length=200, verbose_name='原图路径')),
- ('indentify_photo', models.CharField(default='', max_length=200, verbose_name='识别图路径')),
- ('indentify_result', models.CharField(default='', max_length=100)),
- ('addtime', models.IntegerField(default=0, verbose_name='上传时间戳秒级')),
- ('interface', models.CharField(default='', max_length=50)),
- ],
- options={
- 'db_table': 'user_uploads_pictures',
- },
- ),
- migrations.CreateModel(
- name='MongoUserWarningLiaisons',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('user_id', models.CharField(blank=True, default='', max_length=50, null=True, verbose_name='用户id')),
- ('liaisons', models.CharField(default='', max_length=50, verbose_name='联系人名称')),
- ('phone', models.IntegerField(default=0, verbose_name='联系人电话')),
- ('send_count', models.IntegerField(default=0, verbose_name='发送次数')),
- ('create_time', models.IntegerField(default=0, verbose_name='创建时间')),
- ],
- options={
- 'db_table': 'sa_device_user_warning_liaisons',
- },
- ),
- migrations.CreateModel(
- name='MongoVersion_Record',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('app_name', models.CharField(blank=True, max_length=50, verbose_name='app版本名称')),
- ('app_num', models.CharField(blank=True, max_length=50, verbose_name='版本号')),
- ('app_desc', models.CharField(blank=True, max_length=50, verbose_name='更新描述')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_app_version_record',
- 'ordering': ['-id'],
- },
- ),
- migrations.CreateModel(
- name='MongoWarm_Base_Info',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('have_camera', models.CharField(blank=True, max_length=20, null=True, verbose_name='是否有监控')),
- ('camera_addr', models.TextField(default='', verbose_name='播放地址')),
- ('runmode', models.CharField(blank=True, max_length=20, null=True, verbose_name='设备运行状态')),
- ('dev_list', models.TextField(blank=True, null=True, verbose_name='设备列表及名称')),
- ('remark', models.TextField(blank=True, null=True, verbose_name='设备列表的新名称')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_warm_base_info',
- },
- ),
- migrations.CreateModel(
- name='MongoWarm_Input_Status',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('output', models.TextField(blank=True, null=True, verbose_name='控制IO输入点状态上报')),
- ('remark', models.TextField(blank=True, null=True, verbose_name='控制IO输入点备注')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_warm_input_status',
- },
- ),
- migrations.CreateModel(
- name='MongoWarm_Output_Status',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('output', models.TextField(blank=True, null=True, verbose_name='控制IO输出点状态上报')),
- ('remark', models.TextField(blank=True, null=True, verbose_name='控制IO输出点备注')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_warm_output_status',
- },
- ),
- migrations.CreateModel(
- name='MongoWarm_Switch_Auto_His',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('dev_name', models.CharField(blank=True, max_length=20, null=True, verbose_name='开关名称')),
- ('ctl_mod', models.CharField(blank=True, max_length=20, null=True, verbose_name='控制模式')),
- ('switch_list', models.TextField(blank=True, null=True, verbose_name='开关状态')),
- ('remark', models.TextField(blank=True, null=True, verbose_name='开关状态备注')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_warm_switch_auto_his',
- },
- ),
- migrations.CreateModel(
- name='MongoWarm_Switch_Data',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('data', models.TextField(blank=True, null=True, verbose_name='开关状态')),
- ('remark', models.TextField(blank=True, null=True, verbose_name='开关状态备注')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_warm_switch_data',
- },
- ),
- migrations.CreateModel(
- name='MongoWarm_Switch_Status',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('dev_name', models.CharField(default='', max_length=50, verbose_name='开关名称')),
- ('status', models.TextField(blank=True, null=True, verbose_name='开关状态')),
- ('remark', models.TextField(blank=True, null=True, verbose_name='开关状态备注')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_warm_switch_status',
- },
- ),
- migrations.CreateModel(
- name='MongoWarm_Weather_Data',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('data', models.TextField(blank=True, null=True, verbose_name='气象要素')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_warm_weather_data',
- },
- ),
- migrations.CreateModel(
- name='MongoWarm_Weather_Status',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('status', models.TextField(blank=True, null=True, verbose_name='气象要素')),
- ('uptime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_warm_weather_status',
- },
- ),
- migrations.CreateModel(
- name='MongoWheatdata',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('device_id', models.CharField(default='', max_length=50)),
- ('province', models.CharField(blank=True, max_length=20, null=True, verbose_name='省')),
- ('city', models.CharField(blank=True, max_length=20, null=True, verbose_name='市')),
- ('county', models.CharField(blank=True, max_length=20, null=True, verbose_name='县')),
- ('uptime', models.IntegerField(default=0, verbose_name='上传时间')),
- ('data', models.TextField(blank=True, null=True, verbose_name='数据')),
- ],
- options={
- 'db_table': 'sa_device_wheatdata',
- },
- ),
- migrations.CreateModel(
- name='MongoWheatIncidence',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('device_id', models.CharField(default='', max_length=50)),
- ('province', models.CharField(blank=True, max_length=20, null=True, verbose_name='省')),
- ('city', models.CharField(blank=True, max_length=20, null=True, verbose_name='市')),
- ('county', models.CharField(blank=True, max_length=20, null=True, verbose_name='县')),
- ('uptime', models.IntegerField(default=0, verbose_name='上传时间')),
- ('incidence', models.CharField(blank=True, max_length=200, null=True, verbose_name='发生率')),
- ],
- options={
- 'db_table': 'sa_device_wheatincidence',
- },
- ),
- migrations.CreateModel(
- name='MongoWheatstatus',
- fields=[
- ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
- ('device_id', models.CharField(default='', max_length=50)),
- ('province', models.CharField(blank=True, max_length=20, null=True, verbose_name='省')),
- ('city', models.CharField(blank=True, max_length=20, null=True, verbose_name='市')),
- ('county', models.CharField(blank=True, max_length=20, null=True, verbose_name='县')),
- ('uptime', models.IntegerField(default=0, verbose_name='上传时间')),
- ('status', models.TextField(blank=True, max_length=500, null=True, verbose_name='状态')),
- ],
- options={
- 'db_table': 'sa_device_wheatstatus',
- },
- ),
- migrations.CreateModel(
- name='MongoXCTData',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.PositiveIntegerField(default=0, verbose_name='设备自增id')),
- ('device_data', models.TextField(default='', verbose_name='具体历史状态数据')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_xct_data',
- },
- ),
- migrations.CreateModel(
- name='MongoXCTphoto',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('addr', models.CharField(default=0, max_length=200, verbose_name='照片路径')),
- ('at', models.CharField(default=0, max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(default=0, max_length=50, verbose_name='环境湿度')),
- ('describe', models.CharField(default=0, max_length=50, verbose_name='描述')),
- ('indentify_photo', models.CharField(default=0, max_length=200, verbose_name='识别照片路径')),
- ('indentify_result', models.CharField(default=0, max_length=100)),
- ('photo_status', models.PositiveIntegerField(default=1)),
- ('is_mark', models.PositiveIntegerField(default=0)),
- ('mark', models.TextField(default='[]')),
- ('label', models.TextField(blank=True)),
- ],
- options={
- 'db_table': 'sa_device_xct_photo',
- },
- ),
- migrations.CreateModel(
- name='MongoXYCBData',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.PositiveIntegerField(default=0, verbose_name='设备自增id')),
- ('device_data', models.TextField(default='', verbose_name='具体历史状态数据')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_xycb_data',
- },
- ),
- migrations.CreateModel(
- name='MongoXYThreeData',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.PositiveIntegerField(default=0, verbose_name='设备自增id')),
- ('device_data', models.TextField(default='', verbose_name='具体历史状态数据')),
- ('addtime', models.IntegerField(default=0)),
- ],
- options={
- 'db_table': 'sa_device_xy_three_data',
- },
- ),
- migrations.CreateModel(
- name='MongoXYThreephoto',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('device_id', models.CharField(default='', max_length=50)),
- ('addtime', models.IntegerField(default=0)),
- ('uptime', models.IntegerField(default=0)),
- ('addr', models.CharField(default=0, max_length=200, verbose_name='照片路径')),
- ('at', models.CharField(default=0, max_length=50, verbose_name='环境温度')),
- ('ah', models.CharField(default=0, max_length=50, verbose_name='环境湿度')),
- ('describe', models.CharField(default=0, max_length=50, verbose_name='描述')),
- ('indentify_photo', models.CharField(default=0, max_length=200, verbose_name='识别照片路径')),
- ('indentify_result', models.CharField(default=0, max_length=100)),
- ('photo_status', models.PositiveIntegerField(default=1)),
- ('is_mark', models.PositiveIntegerField(default=0)),
- ('mark', models.TextField(default='[]')),
- ],
- options={
- 'db_table': 'sa_device_xy_three_photo',
- },
- ),
- migrations.CreateModel(
- name='Purview',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('parent_perm_id', models.PositiveIntegerField(default=0, verbose_name='父级权限')),
- ('purview_name', models.CharField(default='', max_length=100, verbose_name='权限名称')),
- ('path', models.CharField(default='', max_length=100, verbose_name='接口标识')),
- ('menu', models.CharField(default='', max_length=100, verbose_name='菜单标识')),
- ('addtime', models.PositiveIntegerField(default=0)),
- ('uptime', models.PositiveIntegerField(default=0)),
- ('url', models.TextField(default=0, verbose_name='页面路由')),
- ('enable', models.BooleanField(default=True, verbose_name='是否启用')),
- ('priority', models.IntegerField(default=0, verbose_name='排序优先级,整数0最小')),
- ],
- options={
- 'db_table': 'sa_purview',
- },
- ),
- migrations.CreateModel(
- name='Role',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('role_name', models.CharField(default='', max_length=100, verbose_name='角色名称')),
- ('role_message', models.TextField(default='', verbose_name='角色描述')),
- ('role_perm', models.TextField(default='', verbose_name='角色拥有的权限')),
- ('role_status', models.PositiveIntegerField(default=1)),
- ('addtime', models.PositiveIntegerField(default=0)),
- ('uptime', models.PositiveIntegerField(default=0)),
- ('add_by', models.PositiveIntegerField(blank=True, default=None, null=True, verbose_name='创建人')),
- ],
- options={
- 'db_table': 'sa_role',
- },
- ),
- migrations.CreateModel(
- name='UserPurview',
- fields=[
- ('id', models.AutoField(primary_key=True, serialize=False)),
- ('parent_perm_id', models.PositiveIntegerField(default=0, verbose_name='父级权限')),
- ('purview_name', models.CharField(default='', max_length=100, verbose_name='权限名称')),
- ('path', models.CharField(default='', max_length=100, verbose_name='接口标识')),
- ('menu', models.CharField(default='', max_length=100, verbose_name='菜单标识')),
- ('addtime', models.PositiveIntegerField(default=0)),
- ('uptime', models.PositiveIntegerField(default=0)),
- ('url', models.TextField(default=0, verbose_name='页面路由')),
- ],
- options={
- 'db_table': 'sa_user_purview',
- },
- ),
- migrations.AlterUniqueTogether(
- name='mongootherusertypemodel',
- unique_together={('other_name', 'other_type')},
- ),
- migrations.AlterUniqueTogether(
- name='mongomenupergroupmodel',
- unique_together={('name', 'uid')},
- ),
- migrations.AlterUniqueTogether(
- name='mongodeviceconfig',
- unique_together={('d_id', 'cmd')},
- ),
- ]
|