1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
| import { EntityModel } from '@midwayjs/orm';
| import { BaseEntity } from '@cool-midway/core';
| import { Column } from 'typeorm';
| /**
| * 设备信息表
| */
| @EntityModel('t_base_deviceinfo')
| export class BasedeviceinfoEntity extends BaseEntity {
| @Column({ comment: '设备高度', type: 'varchar', default: '', length: 50 })
| altitude: string;
|
| @Column({ comment: '账号', type: 'varchar', default: '', length: 50 })
| device_account: string;
|
| @Column({ comment: '唯一索引，设备物理id，如厂编号、subscribeno等', type: 'varchar', default: '', length: 50 })
| device_id: string;
|
| @Column({ comment: '端口', type: 'varchar', default: '', length: 50 })
| device_port: string;
|
| @Column({ comment: '密码', type: 'varchar', default: '', length: 50 })
| device_psw: string;
|
| @Column({ comment: '设备精度', type: 'varchar', default: '', length: 50 })
| dimension: string;
|
| @Column({ comment: '', type: 'varchar', default: '', length: 50 })
| heading_angle: string;
|
| @Column({ comment: 'IP地址', type: 'varchar', default: '', length: 50 })
| ipaddres: string;
|
| @Column({ comment: '纬度，精确到小数点后6位', type: 'varchar', default: '', length: 50 })
| latitude: string;
|
| @Column({ comment: '安装位置，**省**市**区**路**号**楼**方位', type: 'varchar', default: '', length: 50 })
| location: string;
|
| @Column({ comment: '设备逻辑ID', type: 'varchar', default: '', length: 50 })
| logic_id: string;
|
| @Column({ comment: '经度，精确到小数点后6位', type: 'varchar', default: '', length: 50 })
| longitude: string;
|
| @Column({ comment: '设备名称', type: 'varchar', default: '', length: 50 })
| name: string;
|
| @Column({ comment: '运维负责人', type: 'varchar', default: '', length: 50 })
| opertator: string;
|
| @Column({ comment: '俯仰角', type: 'varchar', default: '', length: 50 })
| petch_angle: string;
|
| @Column({ comment: '航向角', type: 'varchar', default: '', length: 50 })
| precision: string;
|
| @Column({ comment: '备注', type: 'varchar', default: '', length: 50 })
| remark: string;
|
| @Column({ comment: '横滚角', type: 'varchar', default: '', length: 50 })
| roll_angle: string;
|
| @Column({ comment: '状态,1-启用 0-停用', type: 'int', default: 1, width: 0 })
| status: number;
|
| }
|
|
