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)