bphtb_log_models.py
1.22 KB
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
from sqlalchemy import (
Column,
Integer,
String,
DateTime,
Text,
JSON,
)
from .log_models import Base
class Log(Base):
__tablename__ = 'log_iso'
id = Column(Integer, nullable=False, primary_key=True)
created = Column(DateTime(timezone=True), nullable=False)
ip = Column(String(15))
mti = Column(String(4), nullable=False)
bit_002 = Column(Text)
bit_003 = Column(Text)
bit_004 = Column(Text)
bit_007 = Column(Text)
bit_011 = Column(Text)
bit_012 = Column(Text)
bit_013 = Column(Text)
bit_015 = Column(Text)
bit_018 = Column(Text)
bit_022 = Column(Text)
bit_032 = Column(Text)
bit_033 = Column(Text)
bit_035 = Column(Text)
bit_037 = Column(Text)
bit_039 = Column(Text)
bit_041 = Column(Text)
bit_042 = Column(Text)
bit_043 = Column(Text)
bit_047 = Column(Text)
bit_049 = Column(Text)
bit_057 = Column(Text)
bit_058 = Column(Text)
bit_059 = Column(Text)
bit_060 = Column(Text)
bit_061 = Column(Text)
bit_062 = Column(Text)
bit_063 = Column(Text)
bit_070 = Column(Text)
bit_102 = Column(Text)
bit_107 = Column(Text)
bit_047_data = Column(JSON)
bit_048_data = Column(JSON)