class Device(Base):
__tablename__ = 'devices'
id = Column(Integer, primary_key=True)
name = Column(String(128), nullable=False)
description = Column(String(255), nullable=False)
active = Column(Integer, nullable=False, server_default=text("0"))
last_accept_time = Column(DateTime)
last_reject_time = Column(DateTime)
last_accept_nas = Column(String(128))
last_reject_nas = Column(String(128))
last_reject_message = Column(String(255))
permanent_user_id = Column(Integer)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
perc_time_used = Column(Integer)
perc_data_used = Column(Integer)
data_used = Column(BigInteger)
data_cap = Column(BigInteger)
time_used = Column(Integer)
time_cap = Column(Integer)
time_cap_type = Column(ENUM('hard', 'soft'), server_default=text("'soft'"))
data_cap_type = Column(ENUM('hard', 'soft'), server_default=text("'soft'"))
realm = Column(String(100), nullable=False, server_default=text("''"))
realm_id = Column(Integer)
profile = Column(String(100), nullable=False, server_default=text("''"))
profile_id = Column(Integer)
from_date = Column(DateTime)
to_date = Column(DateTime)
class FinPayuTransaction(Base):
__tablename__ = 'fin_payu_transactions'
id = Column(Integer, primary_key=True)
merchant_reference = Column(String(64), nullable=False)
payu_reference = Column(String(64), nullable=False)
transaction_type = Column(
ENUM('RESERVE', 'FINALISE', 'PAYMENT', 'EFFECT_STAGING', 'CREDIT',
'RESERVE_CANCEL', 'REGISTER_LINK'),
server_default=text("'PAYMENT'"))
transaction_state = Column(
ENUM('NEW', 'PROCESSING', 'SUCCESSFUL', 'FAILED'),
server_default=text("'NEW'"))
result_code = Column(Integer)
result_message = Column(String(255))
display_message = Column(String(255))
merchant_user_id = Column(String(255))
email = Column(String(255))
mobile = Column(String(255))
regional_id = Column(String(255))
first_name = Column(String(255))
last_name = Column(String(255))
amount_in_cents = Column(Integer, nullable=False)
currency_code = Column(String(255), server_default=text("'ZAR'"))
description = Column(String(255), nullable=False)
product_code = Column(String(255), nullable=False)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class MeshEntry(Base):
__tablename__ = 'mesh_entries'
id = Column(Integer, primary_key=True)
mesh_id = Column(Integer)
name = Column(String(128), nullable=False)
hidden = Column(Integer, nullable=False, server_default=text("0"))
isolate = Column(Integer, nullable=False, server_default=text("0"))
apply_to_all = Column(Integer, nullable=False, server_default=text("0"))
encryption = Column(
ENUM('none', 'wep', 'psk', 'psk2', 'wpa', 'wpa2'),
server_default=text("'none'"))
special_key = Column(
String(100), nullable=False, server_default=text("''"))
auth_server = Column(
String(255), nullable=False, server_default=text("''"))
auth_secret = Column(
String(255), nullable=False, server_default=text("''"))
dynamic_vlan = Column(Integer, nullable=False, server_default=text("0"))
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
chk_maxassoc = Column(Integer, nullable=False, server_default=text("0"))
maxassoc = Column(Integer, server_default=text("100"))
macfilter = Column(
ENUM('disable', 'allow', 'deny'), server_default=text("'disable'"))
permanent_user_id = Column(Integer, nullable=False)
class FinPayUTransaction(Base):
__tablename__ = 'fin_pay_u_transactions'
id = Column(Integer, primary_key=True)
user_id = Column(Integer)
voucher_id = Column(Integer)
top_up_id = Column(Integer)
merchantReference = Column(String(64), nullable=False)
payUReference = Column(String(64), nullable=False)
TransactionType = Column(
ENUM('RESERVE', 'FINALISE', 'PAYMENT', 'EFFECT_STAGING', 'CREDIT',
'RESERVE_CANCEL', 'REGISTER_LINK'),
server_default=text("'PAYMENT'"))
TransactionState = Column(
ENUM('NEW', 'PROCESSING', 'SUCCESSFUL', 'FAILED', 'TIMEOUT'),
server_default=text("'NEW'"))
ResultCode = Column(Integer)
ResultMessage = Column(String(255))
DisplayMessage = Column(String(255))
merchUserId = Column(String(255))
firstName = Column(String(255))
lastName = Column(String(255))
email = Column(String(255))
mobile = Column(String(255))
regionalId = Column(String(255))
amountInCents = Column(Integer, nullable=False)
currencyCode = Column(String(255), server_default=text("'ZAR'"))
description = Column(String(255), nullable=False)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class NodeIbssConnection(Base):
__tablename__ = 'node_ibss_connections'
id = Column(Integer, primary_key=True)
node_id = Column(Integer)
station_node_id = Column(Integer)
vendor = Column(String(255))
mac = Column(String(17), nullable=False)
tx_bytes = Column(BigInteger, nullable=False)
rx_bytes = Column(BigInteger, nullable=False)
tx_packets = Column(Integer, nullable=False)
rx_packets = Column(Integer, nullable=False)
tx_bitrate = Column(Integer, nullable=False)
rx_bitrate = Column(Integer, nullable=False)
tx_extra_info = Column(String(255), nullable=False)
rx_extra_info = Column(String(255), nullable=False)
authenticated = Column(ENUM('yes', 'no'), server_default=text("'no'"))
authorized = Column(ENUM('yes', 'no'), server_default=text("'no'"))
tdls_peer = Column(String(255), nullable=False)
preamble = Column(ENUM('long', 'short'), server_default=text("'long'"))
tx_failed = Column(Integer, nullable=False)
inactive_time = Column(Integer, nullable=False)
WMM_WME = Column(ENUM('yes', 'no'), server_default=text("'no'"))
tx_retries = Column(Integer, nullable=False)
MFP = Column(ENUM('yes', 'no'), server_default=text("'no'"))
signal = Column(Integer, nullable=False)
signal_avg = Column(Integer, nullable=False)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class NodeAction(Base):
__tablename__ = 'node_actions'
id = Column(Integer, primary_key=True)
node_id = Column(Integer, nullable=False)
action = Column(ENUM('execute'), server_default=text("'execute'"))
command = Column(String(500), server_default=text("''"))
status = Column(ENUM('awaiting', 'fetched', 'replied'),
server_default=text("'awaiting'"))
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class Na(Base):
__tablename__ = 'nas'
id = Column(Integer, primary_key=True)
nasname = Column(String(128), nullable=False, index=True)
shortname = Column(String(32))
nasidentifier = Column(String(64),
nullable=False,
server_default=text("''"))
type = Column(String(30), server_default=text("'other'"))
ports = Column(Integer)
secret = Column(String(60),
nullable=False,
server_default=text("'secret'"))
server = Column(String(64))
community = Column(String(50))
description = Column(String(200), server_default=text("'RADIUS Client'"))
connection_type = Column(ENUM('direct', 'openvpn', 'pptp', 'dynamic'),
server_default=text("'direct'"))
available_to_siblings = Column(Integer,
nullable=False,
server_default=text("1"))
record_auth = Column(Integer, nullable=False, server_default=text("0"))
ignore_acct = Column(Integer, nullable=False, server_default=text("0"))
dynamic_attribute = Column(String(50),
nullable=False,
server_default=text("''"))
dynamic_value = Column(String(50),
nullable=False,
server_default=text("''"))
monitor = Column(ENUM('off', 'ping', 'heartbeat'),
server_default=text("'off'"))
ping_interval = Column(Integer, nullable=False, server_default=text("600"))
heartbeat_dead_after = Column(Integer,
nullable=False,
server_default=text("600"))
last_contact = Column(DateTime)
session_auto_close = Column(Integer,
nullable=False,
server_default=text("0"))
session_dead_time = Column(Integer,
nullable=False,
server_default=text("3600"))
on_public_maps = Column(Integer, nullable=False, server_default=text("0"))
lat = Column(Float(asdecimal=True))
lon = Column(Float(asdecimal=True))
photo_file_name = Column(String(128),
nullable=False,
server_default=text("'logo.jpg'"))
user_id = Column(Integer)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class User(Base):
__tablename__ = 'user'
uid = Column(Integer, primary_key=True)
name = Column(String(64))
idcard = Column(String(18))
sex = Column(ENUM('男', '女', '保密'))
class Func(SAFRSBase, Base):
__tablename__ = 'func'
name = Column(CHAR(64, 'utf8_bin'), primary_key=True, server_default=text("''"))
ret = Column(TINYINT(1), nullable=False, server_default=text("'0'"))
dl = Column(CHAR(128, 'utf8_bin'), nullable=False, server_default=text("''"))
type = Column(ENUM('function', 'aggregate'), nullable=False)
class Voucher(Base):
__tablename__ = 'vouchers'
id = Column(Integer, primary_key=True)
name = Column(String(64), unique=True)
batch = Column(String(128), nullable=False, server_default=text("''"))
status = Column(
ENUM('new', 'used', 'depleted', 'expired'),
server_default=text("'new'"))
perc_time_used = Column(Integer)
perc_data_used = Column(Integer)
last_accept_time = Column(DateTime)
last_reject_time = Column(DateTime)
last_accept_nas = Column(String(128))
last_reject_nas = Column(String(128))
last_reject_message = Column(String(255))
user_id = Column(Integer)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
extra_name = Column(String(100), nullable=False, server_default=text("''"))
extra_value = Column(
String(100), nullable=False, server_default=text("''"))
password = Column(String(30), nullable=False, server_default=text("''"))
realm = Column(String(50), nullable=False, server_default=text("''"))
realm_id = Column(Integer)
profile = Column(String(50), nullable=False, server_default=text("''"))
profile_id = Column(Integer)
expire = Column(String(10), nullable=False, server_default=text("''"))
time_valid = Column(String(10), nullable=False, server_default=text("''"))
data_used = Column(BigInteger)
data_cap = Column(BigInteger)
time_used = Column(Integer)
time_cap = Column(Integer)
class DynamicClient(Base):
__tablename__ = 'dynamic_clients'
id = Column(Integer, primary_key=True)
name = Column(String(64), nullable=False, server_default=text("''"))
nasidentifier = Column(
String(128), nullable=False, server_default=text("''"))
calledstationid = Column(
String(128), nullable=False, server_default=text("''"))
last_contact = Column(DateTime)
last_contact_ip = Column(
String(128), nullable=False, server_default=text("''"))
timezone = Column(String(255), nullable=False, server_default=text("''"))
monitor = Column(
ENUM('off', 'heartbeat', 'socket'), server_default=text("'off'"))
session_auto_close = Column(
Integer, nullable=False, server_default=text("0"))
session_dead_time = Column(
Integer, nullable=False, server_default=text("3600"))
available_to_siblings = Column(
Integer, nullable=False, server_default=text("1"))
active = Column(Integer, nullable=False, server_default=text("1"))
on_public_maps = Column(Integer, nullable=False, server_default=text("0"))
lat = Column(Float(asdecimal=True))
lon = Column(Float(asdecimal=True))
photo_file_name = Column(
String(128), nullable=False, server_default=text("'logo.jpg'"))
user_id = Column(Integer)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class DynamicPhoto(Base):
__tablename__ = 'dynamic_photos'
id = Column(Integer, primary_key=True)
dynamic_detail_id = Column(Integer, nullable=False)
title = Column(
String(128), nullable=False, index=True, server_default=text("''"))
description = Column(
String(250), nullable=False, server_default=text("''"))
url = Column(String(250), nullable=False, server_default=text("''"))
file_name = Column(
String(128), nullable=False, server_default=text("'logo.jpg'"))
created = Column(DateTime)
modified = Column(DateTime)
active = Column(Integer, nullable=False, server_default=text("1"))
fit = Column(
ENUM('stretch_to_fit', 'horizontal', 'vertical', 'original',
'dynamic'),
server_default=text("'stretch_to_fit'"))
background_color = Column(
String(7), nullable=False, server_default=text("'ffffff'"))
slide_duration = Column(Integer, nullable=False, server_default=text("10"))
include_title = Column(Integer, nullable=False, server_default=text("1"))
include_description = Column(
Integer, nullable=False, server_default=text("1"))
class ProcsPriv(SAFRSBase, Base):
__tablename__ = "procs_priv"
Host = Column(CHAR(60, "utf8_bin"),
primary_key=True,
nullable=False,
server_default=text("''"))
Db = Column(CHAR(64, "utf8_bin"),
primary_key=True,
nullable=False,
server_default=text("''"))
User = Column(CHAR(32, "utf8_bin"),
primary_key=True,
nullable=False,
server_default=text("''"))
Routine_name = Column(CHAR(64),
primary_key=True,
nullable=False,
server_default=text("''"))
Routine_type = Column(ENUM("FUNCTION", "PROCEDURE"),
primary_key=True,
nullable=False)
Grantor = Column(CHAR(93, "utf8_bin"),
nullable=False,
index=True,
server_default=text("''"))
Proc_priv = Column(SET, nullable=False, server_default=text("''"))
Timestamp = Column(
TIMESTAMP,
nullable=False,
server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"))
class FinPaymentPlan(Base):
__tablename__ = 'fin_payment_plans'
id = Column(Integer, primary_key=True)
user_id = Column(Integer)
profile_id = Column(Integer)
name = Column(String(255), nullable=False)
description = Column(String(255), server_default=text("''"))
type = Column(ENUM('voucher', 'user'), server_default=text("'user'"))
currency_code = Column(
ENUM('USD', 'ZAR', 'GBP', 'EUR'), server_default=text("'ZAR'"))
value = Column(Numeric(15, 2))
tax = Column(Numeric(15, 2))
active = Column(Integer, nullable=False, server_default=text("0"))
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class PermanentUser(Base):
__tablename__ = 'permanent_users'
id = Column(Integer, primary_key=True)
username = Column(String(255), nullable=False)
password = Column(String(50), nullable=False)
token = Column(String(36))
name = Column(String(50), nullable=False)
surname = Column(String(50), nullable=False)
address = Column(String(255), nullable=False)
phone = Column(String(50), nullable=False)
email = Column(String(100), nullable=False)
auth_type = Column(String(128),
nullable=False,
server_default=text("'sql'"))
active = Column(Integer, nullable=False, server_default=text("0"))
last_accept_time = Column(DateTime)
last_reject_time = Column(DateTime)
last_accept_nas = Column(String(128))
last_reject_nas = Column(String(128))
last_reject_message = Column(String(255))
perc_time_used = Column(Integer)
perc_data_used = Column(Integer)
data_used = Column(BigInteger)
data_cap = Column(BigInteger)
time_used = Column(Integer)
time_cap = Column(Integer)
time_cap_type = Column(ENUM('hard', 'soft'), server_default=text("'soft'"))
data_cap_type = Column(ENUM('hard', 'soft'), server_default=text("'soft'"))
realm = Column(String(50), nullable=False, server_default=text("''"))
realm_id = Column(Integer)
profile = Column(String(50), nullable=False, server_default=text("''"))
profile_id = Column(Integer)
from_date = Column(DateTime)
to_date = Column(DateTime)
track_auth = Column(Integer, nullable=False, server_default=text("0"))
track_acct = Column(Integer, nullable=False, server_default=text("1"))
static_ip = Column(String(50), nullable=False, server_default=text("''"))
extra_name = Column(String(100), nullable=False, server_default=text("''"))
extra_value = Column(String(100),
nullable=False,
server_default=text("''"))
country_id = Column(Integer)
language_id = Column(Integer)
user_id = Column(Integer)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class PermanentUserNotification(Base):
__tablename__ = 'permanent_user_notifications'
id = Column(Integer, primary_key=True)
permanent_user_id = Column(Integer)
active = Column(Integer, nullable=False, server_default=text("1"))
method = Column(ENUM('whatsapp', 'email', 'sms'),
server_default=text("'email'"))
type = Column(ENUM('daily', 'usage'), server_default=text("'daily'"))
address_1 = Column(String(255))
address_2 = Column(String(255))
start = Column(Integer, server_default=text("80"))
increment = Column(Integer, server_default=text("10"))
last_value = Column(Integer)
last_notification = Column(DateTime)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class Employee(Base):
__tablename__ = 'employees'
emp_no = Column(Integer, primary_key=True)
birth_date = Column(Date, nullable=False)
first_name = Column(String(14), nullable=False)
last_name = Column(String(16), nullable=False)
gender = Column(ENUM('M', 'F'), nullable=False)
hire_date = Column(Date, nullable=False)
class TopUpTransaction(Base):
__tablename__ = 'top_up_transactions'
id = Column(Integer, primary_key=True)
user_id = Column(Integer)
permanent_user_id = Column(Integer)
permanent_user = Column(String(255))
top_up_id = Column(Integer)
type = Column(ENUM('data', 'time', 'days_to_use'),
server_default=text("'data'"))
action = Column(ENUM('create', 'update', 'delete'),
server_default=text("'create'"))
radius_attribute = Column(String(30),
nullable=False,
server_default=text("''"))
old_value = Column(String(30))
new_value = Column(String(30))
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class FinMyGateTransaction(Base):
__tablename__ = 'fin_my_gate_transactions'
id = Column(Integer, primary_key=True)
user_id = Column(Integer)
fin_my_gate_token_id = Column(Integer)
status = Column(
ENUM('pending', 'success', 'fail', 'submitted'),
server_default=text("'pending'"))
type = Column(
ENUM('credit_card', 'debit_order'),
server_default=text("'credit_card'"))
amount = Column(Numeric(15, 2))
my_gate_reference = Column(
String(255), nullable=False, server_default=text("''"))
message = Column(String(255), nullable=False, server_default=text("''"))
permanent_user = Column(
String(255), nullable=False, server_default=text("''"))
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class NodeNeighbor(Base):
__tablename__ = 'node_neighbors'
id = Column(Integer, primary_key=True)
node_id = Column(Integer)
gateway = Column(ENUM('yes', 'no'), server_default=text("'no'"))
neighbor_id = Column(Integer)
metric = Column(Numeric(6, 4), nullable=False)
hwmode = Column(String(5), server_default=text("'11g'"))
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class Model(Base):
__tablename__ = 'model'
id = Column(Integer, primary_key=True)
api_key = Column(String(100), nullable=False)
filename = Column(String(100), nullable=False)
filepath = Column(String(200), nullable=False)
learning_percent = Column(Float)
learning_log = Column(String(200))
learning_status = Column(ENUM('STOP', 'LEARNING', 'COMPLETE', 'FAILURE'),
nullable=False,
server_default=FetchedValue())
target = Column(ENUM('BROKEN', 'POWER'), nullable=False)
createdAt = Column(DateTime, nullable=False, server_default=FetchedValue())
updatedAt = Column(DateTime, nullable=False, server_default=FetchedValue())
buildingId = Column(ForeignKey('building.id'), index=True)
building = relationship('Building',
primaryjoin='Model.buildingId == Building.id',
backref='models')
class Func(SAFRSBase, Base):
__tablename__ = "func"
name = Column(CHAR(64, "utf8_bin"),
primary_key=True,
server_default=text("''"))
ret = Column(TINYINT(1), nullable=False, server_default=text("'0'"))
dl = Column(CHAR(128, "utf8_bin"),
nullable=False,
server_default=text("''"))
type = Column(ENUM("function", "aggregate"), nullable=False)
class TemplateAttribute(Base):
__tablename__ = 'template_attributes'
id = Column(Integer, primary_key=True)
template_id = Column(Integer)
attribute = Column(String(128), nullable=False)
type = Column(ENUM('Check', 'Reply'), server_default=text("'Check'"))
tooltip = Column(String(200), nullable=False)
unit = Column(String(100), nullable=False)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class UnknownAp(Base):
__tablename__ = 'unknown_aps'
id = Column(Integer, primary_key=True)
mac = Column(String(255), nullable=False)
vendor = Column(String(255))
last_contact_from_ip = Column(String(255))
last_contact = Column(DateTime)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
new_server = Column(String(255), nullable=False, server_default=text("''"))
new_server_status = Column(ENUM('awaiting', 'fetched', 'replied'),
server_default=text("'awaiting'"))
class MeshExit(Base):
__tablename__ = 'mesh_exits'
id = Column(Integer, primary_key=True)
mesh_id = Column(Integer)
name = Column(String(128), nullable=False)
type = Column(
ENUM('bridge', 'tagged_bridge', 'nat', 'captive_portal',
'openvpn_bridge'))
auto_detect = Column(Integer, nullable=False, server_default=text("0"))
vlan = Column(Integer)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
openvpn_server_id = Column(Integer)
class SocialLoginUser(Base):
__tablename__ = 'social_login_users'
id = Column(Integer, primary_key=True)
provider = Column(
ENUM('Facebook', 'Google', 'Twitter'),
server_default=text("'Facebook'"))
uid = Column(String(100), nullable=False, server_default=text("''"))
name = Column(String(100), nullable=False, server_default=text("''"))
first_name = Column(String(100), nullable=False, server_default=text("''"))
last_name = Column(String(100), nullable=False, server_default=text("''"))
email = Column(String(100), nullable=False, server_default=text("''"))
image = Column(String(100), nullable=False, server_default=text("''"))
locale = Column(String(5), nullable=False, server_default=text("''"))
timezone = Column(Integer, nullable=False, server_default=text("0"))
date_of_birth = Column(Date)
gender = Column(ENUM('male', 'female'), server_default=text("'male'"))
last_connect_time = Column(DateTime)
extra_name = Column(String(100), nullable=False, server_default=text("''"))
extra_value = Column(
String(100), nullable=False, server_default=text("''"))
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class TopUp(Base):
__tablename__ = 'top_ups'
id = Column(Integer, primary_key=True)
user_id = Column(Integer)
permanent_user_id = Column(Integer)
data = Column(BigInteger)
time = Column(Integer)
days_to_use = Column(Integer)
comment = Column(String(255), nullable=False)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
type = Column(ENUM('data', 'time', 'days_to_use'),
server_default=text("'data'"))
class ApProfileExit(Base):
__tablename__ = 'ap_profile_exits'
id = Column(Integer, primary_key=True)
ap_profile_id = Column(Integer)
type = Column(
ENUM('bridge', 'tagged_bridge', 'nat', 'captive_portal',
'openvpn_bridge'))
vlan = Column(Integer)
auto_dynamic_client = Column(Integer,
nullable=False,
server_default=text("0"))
realm_list = Column(String(128), nullable=False, server_default=text("''"))
auto_login_page = Column(Integer, nullable=False, server_default=text("0"))
dynamic_detail_id = Column(Integer)
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
openvpn_server_id = Column(Integer)
class DynamicDetailSocialLogin(Base):
__tablename__ = 'dynamic_detail_social_logins'
id = Column(Integer, primary_key=True)
dynamic_detail_id = Column(Integer, nullable=False)
profile_id = Column(Integer, nullable=False)
realm_id = Column(Integer, nullable=False)
name = Column(String(50), nullable=False)
enable = Column(Integer, nullable=False, server_default=text("0"))
record_info = Column(Integer, nullable=False, server_default=text("0"))
special_key = Column(
String(100), nullable=False, server_default=text("''"))
secret = Column(String(100), nullable=False, server_default=text("''"))
type = Column(ENUM('voucher', 'user'), server_default=text("'voucher'"))
extra_name = Column(String(100), nullable=False, server_default=text("''"))
extra_value = Column(
String(100), nullable=False, server_default=text("''"))
created = Column(DateTime, nullable=False)
modified = Column(DateTime, nullable=False)
class People(db.Model):
__tablename__ = 'people'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column(db.String(55), nullable=False)
gender = db.Column(ENUM('F', 'M'), nullable=False)
mobile = db.Column(db.String(30))
phone = db.Column(db.String(125))
wechat = db.Column(db.String(125))
email = db.Column(db.String(125))
attendance = db.Column(db.Integer)
first_name = db.Column(db.String(155), nullable=False)
last_name = db.Column(db.String(155), nullable=False)
chinese_name = db.Column(db.String(60), nullable=False)
start_date = db.Column(db.Date)
level_id = db.Column(db.Integer)
office_id = db.Column(db.Integer, db.ForeignKey('office.id'))
department_id = db.Column(db.Integer, db.ForeignKey('department.id'))
title_id = db.Column(db.Integer, db.ForeignKey('title.id'))
logical_company_id = db.Column(db.Integer,
db.ForeignKey('logical_company.id'))