class EV_EVENT_ACTION(db.Model):
__tablename__ = "EV_EVENT_ACTION"
#ev_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
ep_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
rule_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
act_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
act_status = db.Column(db.NVARCHAR(30),nullable=False) # READY / PROC / SUCC / FAIL(fail시 ev_event.expire_time = 초기화)
create_dt = db.Column(db.TIMESTAMP,default=db.func.current_timestamp())
class EV_TRIGGER_STATUS(db.Model):
__tablename__ = "EV_TRIGGER_STATUS"
ep_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
rule_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
trg_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
hold_yn = db.Column(db.NVARCHAR(1), nullable=False,default='N')
expire_time = db.Column(db.DATETIME,nullable=True)
trg_stat = db.Column(db.Integer ,nullable=True)
class OB_DEVICE_TYPE(db.Model):
__tablename__ = "OB_DEVICE_TYPE"
dv_type = db.Column(db.NVARCHAR(50), nullable=False, primary_key=True)
dv_name = db.Column(db.NVARCHAR(50), nullable=False)
dv_desc = db.Column(db.NVARCHAR(300))
dv_location = db.Column(db.NVARCHAR(100))
dv_timeout = db.Column(db.Integer, nullable=False, default=10)
dv_protocol = db.Column(db.NVARCHAR(100))
class EV_EVENT_SNAP(db.Model):
__tablename__ = "EV_EVENT_SNAP"
id = db.Column(db.Integer, primary_key=True)
ev_trace = db.Column(db.NVARCHAR(32),nullable=False)
ep_id = db.Column(db.NVARCHAR(32),nullable=False)
rule_id = db.Column(db.NVARCHAR(32),nullable=False)
expire_time = db.Column(db.TIMESTAMP,default=db.func.current_timestamp())
run_act_yn = db.Column(db.NVARCHAR(1),nullable=False,default='N')
create_dt = db.Column(db.TIMESTAMP,default=db.func.current_timestamp())
class EV_ACTION(db.Model):
__tablename__ = "EV_ACTION"
act_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
act_name = db.Column(db.NVARCHAR(50),nullable=False)
act_interval = db.Column(db.Integer,nullable=False,default=0) # 0 : just one, 0 < : repeat
param = db.Column(db.NVARCHAR(100),nullable=True) # param = JSON_TYPE
result = db.Column(db.NVARCHAR(100),nullable=True) # param = JSON_TYPE
status = db.Column(db.NVARCHAR(100),nullable=True)
create_dt = db.Column(db.DATETIME,nullable=False,default=db.func.current_timestamp())
class EV_TRIGGER_INFO(db.Model):
__tablename__ = "EV_TRIGGER_INFO"
trg_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
hold_time = db.Column(db.Integer,nullable=True)
hold_yn = db.Column(db.NVARCHAR(1), nullable=False,default='N')
trg_type = db.Column(db.NVARCHAR(30),nullable=False)
upper = db.Column(db.NUMERIC ,nullable=True)
under = db.Column(db.NUMERIC ,nullable=True)
value = db.Column(db.NUMERIC ,nullable=True)
class OB_DEVICE_MAP(db.Model):
__tablename__ = "OB_DEVICE_MAP"
dev_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
ep_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
class OB_RESOURCE_MAP(db.Model):
__tablename__ = "OB_RESOURCE_MAP"
rc_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
gw_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
class OB_RESOURCE(db.Model):
__tablename__ = "OB_RESOURCE"
rc_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
rc_name = db.Column(db.NVARCHAR(50), nullable=False)
create_dt = db.Column(db.DATETIME,
nullable=False,
default=db.func.current_timestamp())
class KiLuat(db.Model):
__tablename__ = 'KiLuat'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.INTEGER, primary_key=True)
can_bo_id = db.Column(db.INTEGER, db.ForeignKey('NhanSu.CanBo.id'))
hinh_thuc = db.Column(db.NVARCHAR)
so_quyet_dinh = db.Column(db.NVARCHAR(50))
ngay_quyet_dinh = db.Column(db.DATE)
noi_dung = db.Column(db.NVARCHAR(250))
ghi_chu = db.Column(db.NVARCHAR)
class OB_GATEWAY_MAP(db.Model):
__tablename__ = "OB_GATEWAY_MAP"
gw_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
dev_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
class OB_ENDPOINT_ORDER(db.Model):
gw_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
ep_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
ep_type = db.Column(db.NVARCHAR(50), nullable=False, primary_key=True)
sort_order = db.Column(db.Integer, nullable=False, default=1)
class OB_DEVICE(db.Model):
__tablename__ = "OB_DEVICE"
dev_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
dev_name = db.Column(db.NVARCHAR(50), nullable=False)
dev_location = db.Column(db.NVARCHAR(50))
dev_type = db.Column(db.NVARCHAR(50), nullable=False)
dev_inst = db.Column(db.DATE)
dev_info = db.Column(db.NVARCHAR(200))
last_update = db.Column(db.DATETIME, nullable=True)
class EV_TRIGGER(db.Model):
__tablename__ = "EV_TRIGGER"
trg_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
ep_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
trg_type = db.Column(db.NVARCHAR(50),nullable=False) # above, below, include, except, change
repeat_yn = db.Column(db.NVARCHAR(1),nullable=False,default='N')
repeat_ms = db.Column(db.Integer,nullable=False,default=0)
ep_id = db.Column(db.NVARCHAR(32),nullable=False)
value = db.Column(db.DECIMAL(15,2),nullable=True)
upper = db.Column(db.DECIMAL(15,2),nullable=True)
lower = db.Column(db.DECIMAL(15,2),nullable=True)
create_dt = db.Column(db.DATETIME,nullable=False,default=db.func.current_timestamp())
class KhenThuongTapThe(db.Model):
__tablename__ = 'KhenThuongTapThe'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.INTEGER, primary_key=True)
ten_tap_the = db.Column(db.NVARCHAR)
hinh_thuc_khen_thuong_id = db.Column(
db.SMALLINT, db.ForeignKey('NhanSu.HinhThucKhenThuong.id'))
so_quyet_dinh = db.Column(db.NVARCHAR(50))
ngay_quyet_dinh = db.Column(db.DATE)
don_vi_khen = db.Column(db.NVARCHAR(250))
noi_dung = db.Column(db.NVARCHAR(250))
so_tien = db.Column(db.INTEGER)
ghi_chu = db.Column(db.NVARCHAR)
class GiayToCanBo(db.Model):
__tablename__ = 'GiayToCanBo'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.INTEGER, primary_key=True)
can_bo_id = db.Column(db.INTEGER, db.ForeignKey('NhanSu.CanBo.id'))
giay_to_id = db.Column(db.SMALLINT, db.ForeignKey('NhanSu.GiayTo.id'))
so = db.Column(db.NVARCHAR(50))
ngay_cap = db.Column(db.DATE)
loai_cap = db.Column(db.NVARCHAR(30))
tinh_trang = db.Column(db.NVARCHAR(30))
loai_cap = db.Column(db.NVARCHAR(30))
ngay_thu = db.Column(db.DATE)
ghi_chu = db.Column(db.NVARCHAR)
class TrinhDoNghiepVuCanBo(db.Model):
__tablename__ = 'TrinhDoNghiepVuCanBo'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.SMALLINT, primary_key=True)
can_bo_id = db.Column(db.INTEGER, db.ForeignKey('NhanSu.CanBo.id'))
trinh_do_nghiep_vu_id = db.Column(
db.SMALLINT, db.ForeignKey('NhanSu.TrinhDoNghiepVu.id'))
co_so_dao_tao_id = db.Column(db.SMALLINT,
db.ForeignKey('NhanSu.CoSoDaoTao.id'))
chuyen_nganh = db.Column(db.NVARCHAR(50))
ngay_bat_dau = db.Column(db.DATE())
ngay_ket_thuc = db.Column(db.DATE())
ket_qua = db.Column(db.NVARCHAR(50))
ghi_chu = db.Column(db.NVARCHAR)
class PltdTapThe(db.Model):
__tablename__ = 'PltdTapThe'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.INTEGER, primary_key=True)
nam = db.Column(db.SMALLINT)
phan_loai = db.Column(db.NVARCHAR(100))
ghi_chu = db.Column(db.NVARCHAR)
class BoPhan(db.Model):
__tablename__ = 'BoPhan'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.SMALLINT, primary_key=True)
ten = db.Column(db.NVARCHAR(50), nullable=False)
ma = db.Column(db.VARCHAR(3))
khoi = db.Column(db.VARCHAR(20))
class OB_GATEWAY(db.Model):
__tablename__ = "OB_GATEWAY"
gw_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
gw_name = db.Column(db.NVARCHAR(50), nullable=False)
gw_type = db.Column(db.NVARCHAR(50), nullable=True)
gw_location = db.Column(db.NVARCHAR(50), nullable=True)
register = db.Column(db.NVARCHAR(1), nullable=True)
last_update = db.Column(db.DATETIME, nullable=True)
# delete_enable = db.Column(db.Integer,nullable=False,default=0)
# update_enable = db.Column(db.Integer,nullable=False,default=0)
create_dt = db.Column(db.DATETIME,
nullable=False,
default=db.func.current_timestamp())
class OB_ENDPOINT_TYPE(db.Model):
__tablename__ = "OB_ENDPOINT_TYPE"
ep_type = db.Column(db.NVARCHAR(50), nullable=False, primary_key=True)
ep_name = db.Column(db.NVARCHAR(50), nullable=False)
ep_scale = db.Column(db.Numeric(precision=15, scale=3, asdecimal=False),
default=1.0)
ep_unit = db.Column(db.NVARCHAR(20), nullable=True)
ep_pr_host = db.Column(
db.NVARCHAR(60), nullable=False,
default='127.0.0.1') # parent domain(connection info)
ep_interval = db.Column(db.Integer, nullable=False, default=10)
ep_limit = db.Column(db.NVARCHAR(10), nullable=False) # time / count
ep_hour = db.Column(db.Integer)
ep_day = db.Column(db.Integer)
ep_month = db.Column(db.Integer)
ep_count = db.Column(db.Integer)
class PltdCaNhanTheoThang(db.Model):
__tablename__ = 'PltdCaNhanTheoThang'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.INTEGER, primary_key=True)
can_bo_id = db.Column(db.INTEGER, db.ForeignKey('NhanSu.CanBo.id'))
thang = db.Column(db.DATE)
phan_loai = db.Column(db.NVARCHAR(5))
ghi_chu = db.Column(db.NVARCHAR)
class PlcbTheoNam(db.Model):
__tablename__ = 'PlcbTheoNam'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.INTEGER, primary_key=True)
can_bo_id = db.Column(db.INTEGER, db.ForeignKey('NhanSu.CanBo.id'))
nam = db.Column(db.SMALLINT)
phan_loai = db.Column(db.NVARCHAR(50))
ghi_chu = db.Column(db.NVARCHAR)
class EV_ACTION_INFO(db.Model):
__tablename__ = "EV_ACTION_INFO"
act_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
act_mode = db.Column(db.NVARCHAR(30),nullable=False,primary_key=True) # server / client
act_code = db.Column(db.NVARCHAR(50),nullable=False)
param1 = db.Column(db.NVARCHAR(50),nullable=True)
param2 = db.Column(db.NVARCHAR(50),nullable=True)
param3 = db.Column(db.NVARCHAR(50),nullable=True)
param4 = db.Column(db.NVARCHAR(50),nullable=True)
param5 = db.Column(db.NVARCHAR(50),nullable=True)
class DaoTaoNganHan(db.Model):
__tablename__ = 'DaoTaoNganHan'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.SMALLINT, primary_key=True)
can_bo_id = db.Column(db.INTEGER, db.ForeignKey('NhanSu.CanBo.id'))
co_so_dao_tao_id = db.Column(db.SMALLINT,
db.ForeignKey('NhanSu.CoSoDaoTao.id'))
lop_dao_tao_id = db.Column(db.SMALLINT,
db.ForeignKey('NhanSu.LopDaoTao.id'))
ngay_bat_dau = db.Column(db.DATE())
ngay_ket_thuc = db.Column(db.DATE())
ket_qua = db.Column(db.NVARCHAR(50))
ghi_chu = db.Column(db.NVARCHAR)
class EV_ACTION_PUSH(db.Model):
__tablename__ = "EV_ACTION_PUSH"
req_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
req_type = db.Column(db.NVARCHAR(32),nullable=False) # set_endpoint
#node_id = db.Column(db.NVARCHAR(32),nullable=False)
target_did = db.Column(db.NVARCHAR(32),nullable=False)
use_yn = db.Column(db.NVARCHAR(1),nullable=False)
req_value = db.Column(db.NVARCHAR(50),nullable=False)
req_stat = db.Column(db.NVARCHAR(30),nullable=False)
retry_id = db.Column(db.NVARCHAR(32),nullable=True) # confirm check msg_id
retry = db.Column(db.Integer,nullable=True)
next_retry = db.Column(db.DATETIME,nullable=True)
create_dt = db.Column(db.TIMESTAMP,default=db.func.current_timestamp())
class ViTri(db.Model):
__tablename__ = 'ViTri'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.INTEGER, primary_key=True)
can_bo_id = db.Column(db.INTEGER,
db.ForeignKey('NhanSu.CanBo.id'),
nullable=False)
bo_phan_id = db.Column(db.SMALLINT,
db.ForeignKey('NhanSu.BoPhan.id'),
nullable=False)
cong_viec = db.Column(db.NVARCHAR(255))
nhom_vi_tri_id = db.Column(db.SMALLINT,
db.ForeignKey('NhanSu.NhomViTri.id'))
ngay_bat_dau = db.Column(db.DATE())
ngay_ket_thuc = db.Column(db.DATE())
class RM_ENDPOINT_DATA(db.Model):
__tablename__ = "RM_ENDPOINT_DATA"
ep_id = db.Column(db.NVARCHAR(32), nullable=False, primary_key=True)
ep_month = db.Column(db.NVARCHAR(6), nullable=False,
primary_key=True) # yyyymmddhhmm
ep_day = db.Column(db.NVARCHAR(8), nullable=False,
primary_key=True) # yyyymmddhhmm
ep_time = db.Column(db.NVARCHAR(4), nullable=False,
primary_key=True) # yyyymmddhhmm
ep_sec = db.Column(db.NVARCHAR(12), nullable=False,
primary_key=True) # sss
ep_unix = db.Column(db.NVARCHAR(15), nullable=False, primary_key=True)
ep_data = db.Column(db.NVARCHAR(50), nullable=False)
ep_offset = db.Column(db.Integer, nullable=False, default=0)
ep_part = db.Column(db.Integer, nullable=False, default=0)
create_dt = db.Column(db.DATETIME, default=db.func.current_timestamp())
class CanBo(db.Model):
__tablename__ = 'CanBo'
__table_args__ = {"schema": "NhanSu"}
id = db.Column(db.INTEGER, primary_key=True)
ho_dem = db.Column(db.NVARCHAR(30))
ten = db.Column(db.NVARCHAR(15), index=True)
ngay_sinh = db.Column(db.Date())
gioi_tinh = db.Column(db.NCHAR(1), default='M')
nhom_mau = db.Column(db.VARCHAR(10))
dan_toc = db.Column(db.NVARCHAR(20))
que = db.Column(db.NVARCHAR(100))
dktt = db.Column(db.NVARCHAR(100))
noi_o = db.Column(db.NVARCHAR(100))
so_hieu = db.Column(db.VARCHAR(6))
ngay_vao_cong_an = db.Column(db.Date())
nganh_ngoai = db.Column(db.Boolean())
trinh_do_chinh_tri = db.Column(db.NVARCHAR(30))
trinh_do_ngoai_ngu = db.Column(db.NVARCHAR(30))
trinh_do_tin_hoc = db.Column(db.NVARCHAR(30))
trang_thai_cong_tac_id = db.Column(
db.SMALLINT, db.ForeignKey('NhanSu.TrangThaiCongTac.id'))
so_dien_thoai = db.relationship('SoDienThoai',
backref='chu_thue_bao',
lazy='dynamic')
class OB_ENDPOINT(db.Model):
__tablename__ = "OB_ENDPOINT"
ep_id = db.Column(db.NVARCHAR(32),
nullable=False,
default=uuid_gen(),
primary_key=True)
# dev_id = db.Column(db.NVARCHAR(32),nullable=False,primary_key=True)
ep_type = db.Column(db.NVARCHAR(50), nullable=False, primary_key=True)
ep_order = db.Column(db.Integer, default=1)
ep_name = db.Column(db.NVARCHAR(50), nullable=False)
ep_scale = db.Column(db.Numeric(precision=15, scale=3, asdecimal=False),
default=1.0)
ep_unit = db.Column(db.NVARCHAR(20), nullable=True)
ep_pr_host = db.Column(
db.NVARCHAR(20), nullable=False,
default='127.0.0.1') # parent domain(connection info)
ep_interval = db.Column(db.Integer, nullable=False, default=10)
ep_limit = db.Column(db.NVARCHAR(10), nullable=False) # time / count
ep_location = db.Column(db.NVARCHAR(20), nullable=True)
ep_hour = db.Column(db.Integer)
ep_day = db.Column(db.Integer)
ep_month = db.Column(db.Integer)
ep_count = db.Column(db.Integer)
last_update = db.Column(db.DATETIME, nullable=True)
