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_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_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_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 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 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(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)