class calabiyau_subscriber(SQLModel): id = SQLModel.Uuid(default=uuid4, internal=True) package_id = SQLModel.Uuid() domain = SQLModel.Fqdn(internal=True) tenant_id = SQLModel.Uuid(internal=True) username = SQLModel.Username(max_length=64, null=False) password = SQLModel.Password(max_length=150, null=True) email = SQLModel.Email(max_length=100) name = SQLModel.String(max_length=64) phone_mobile = SQLModel.Phone() phone_office = SQLModel.Phone() designation = SQLModel.Enum('', 'Mr', 'Mrs', 'Ms', 'Dr', 'Prof') static_ip4 = SQLModel.String(null=True, max_length=64) ctx = SQLModel.SmallInt(null=False, default=0) notified = SQLModel.Boolean(null=False, default=True) enabled = SQLModel.Boolean(default=True) creation_time = SQLModel.DateTime(null=False, default=now, readonly=True) volume_expire = SQLModel.DateTime(null=True) package_expire = SQLModel.DateTime(null=True) volume_used_bytes = SQLModel.BigInt(null=False, signed=False, default=0) volume_used = SQLModel.Boolean(null=False, default=False) calabiyau_unique = SQLModel.UniqueIndex(username, domain) calabiyau_pkg_ref = SQLModel.ForeignKey(package_id, calabiyau_package.id, on_delete='RESTRICT') primary_key = id
class calabiyau_package(SQLModel): id = SQLModel.Uuid(default=uuid4, internal=True) virtual_id = SQLModel.Uuid() domain = SQLModel.Fqdn(internal=True) name = SQLModel.String(max_length=64) plan = SQLModel.String(max_length=20) volume_gb = SQLModel.SmallInt(null=True, default=0) volume_metric = SQLModel.Enum('days', 'weeks', 'months') volume_span = SQLModel.TinyInt(null=True, default=0) volume_repeat = SQLModel.Boolean(default=True) package_metric = SQLModel.Enum('days', 'weeks', 'months') package_span = SQLModel.TinyInt(null=True, default=0) pool_id = SQLModel.String(null=True, max_length=64) static4 = SQLModel.Boolean(default=False) static6 = SQLModel.Boolean(default=False) simultaneous = SQLModel.Boolean(default=True) deactivate_login = SQLModel.String(max_length=20) deactivate_coa = SQLModel.String(max_length=20) activate_coa = SQLModel.String(max_length=20) fup_login = SQLModel.String(max_length=20) fup_coa = SQLModel.String(max_length=20) creation_time = SQLModel.DateTime(default=now, readonly=True) pkg_virtual_ref = SQLModel.ForeignKey(virtual_id, calabiyau_virtual.id, on_delete='RESTRICT') pkg_pool_ref = SQLModel.ForeignKey(pool_id, calabiyau_pool.id, on_delete='RESTRICT') primary_key = id
class calabiyau_session(SQLModel): id = SQLModel.Uuid(default=uuid4, internal=True) user_id = SQLModel.Uuid(null=True) username = SQLModel.String(max_length=128, null=False, default=None) acctsessionid = SQLModel.String(max_length=64, null=True, default=None) acctuniqueid = SQLModel.String(max_length=32, null=True, default=None) nasipaddress = SQLModel.Ip4(null=False) nasportid = SQLModel.String(max_length=15, null=True, default=None) nasport = SQLModel.String(max_length=32, null=True, default=None) nasporttype = SQLModel.String(max_length=32, null=True, default=None) acctstarttime = SQLModel.DateTime(null=True) acctupdated = SQLModel.DateTime(null=True) processed = SQLModel.DateTime(null=True) calledstationid = SQLModel.String(max_length=50, null=True, default=None) callingstationid = SQLModel.String(max_length=50, null=True, default=None) servicetype = SQLModel.String(max_length=32, default=None, null=True) framedprotocol = SQLModel.String(max_length=32, default=None, null=True) framedipaddress = SQLModel.Ip4(null=True) acctinputoctets = SQLModel.BigInt(signed=False, null=True, default=None) acctoutputoctets = SQLModel.BigInt(signed=False, null=True, default=None) accttype = SQLModel.String(max_length=32, null=True, default='start') ctx = SQLModel.SmallInt(null=False, default=0) primary_key = id session_uniqueid_index = SQLModel.UniqueIndex(acctuniqueid) session_username_index = SQLModel.Index(user_id) session_ipaddress_index = SQLModel.Index(framedipaddress) session_acctstarttime_index = SQLModel.Index(acctstarttime) session_acctupdated_index = SQLModel.Index(acctupdated) session_acct_prune_index = SQLModel.Index(accttype, processed) session_nasid_index = SQLModel.Index(acctsessionid) session_nas_index = SQLModel.Index(nasipaddress)
class calabiyau_topup(SQLModel): id = SQLModel.Uuid(default=uuid4, internal=True) user_id = SQLModel.Uuid() volume_gb = SQLModel.SmallInt(null=False, default=1) volume_metric = SQLModel.Enum('days', 'weeks', 'months') volume_span = SQLModel.TinyInt(null=False, default=1) volume_expire = SQLModel.DateTime(default=now, readonly=True) volume_repeat = SQLModel.Boolean(default=False) creation_time = SQLModel.DateTime(readonly=True, default=now) topup_user_index = SQLModel.Index(user_id) topup_user_ref = SQLModel.ForeignKey(user_id, calabiyau_subscriber.id) primary_key = id