class an_area(Base):
"""
区域
"""
__tablename__ = "an_area"
isdelete = Column(Boolean, default=0)
id = Column(String(40), primary_key=True)
area_name = Column(String(128), comment="区域名称")
class t_bgs_odd_number(Base):
"""
分单号表
"""
__tablename__ = "t_bgs_odd_number"
id = Column(String(40), primary_key=True)
odd_number = Column(String(50), comment="分单号")
master_number = Column(String(40), comment="对应的主单号")
class an_storing_location(Base):
"""
仓位
"""
__tablename__ = "an_storing_location"
isdelete = Column(Boolean, default=0)
id = Column(String(40), primary_key=True)
area_id = Column(String(40), comment="区域id")
storing_location_name = Column(String(128), comment="仓位名称")
class an_merchandise_inventory_main(Base):
"""
盘库记录主单
"""
__tablename__ = "an_merchandise_inventory_main"
id = Column(String(40), primary_key=True)
stork_user_id = Column(String(40), nullable=False)
stork_user_name = Column(String(50), nullable=False)
createtime = Column(DateTime, default=datetime.datetime.now())
class t_bgs_packing_dictionaries(Base):
"""
包装名称表
"""
__tablename__ = "t_bgs_packing_dictionaries"
id = Column(Integer, primary_key=True, autoincrement=True)
packing_name = Column(String(255), comment="包装名称")
packing_name_englist = Column(String(255), comment="包装英文")
packing_id = Column(Integer)
class an_preservation_type(Base):
"""
类别
"""
__tablename__ = "an_preservation_type"
isdelete = Column(Boolean, default=0)
id = Column(String(40), primary_key=True)
storing_id = Column(String(40), comment="仓位id")
preservation_type_name = Column(String(128), comment="类别名称")
class an_master_number_remark(Base):
"""
盘库备注
"""
__tablename__ = "an_master_number_remark"
id = Column(String(40), primary_key=True)
master_number_id = Column(String(40), comment="进出港主单id")
message = Column(String(255), comment="备注")
createtime = Column(String(255), comment="备注时间")
user_id = Column(String(40), comment="备注人")
class an_checklist(Base):
"""
检查单
"""
__tablename__ = "an_checklist"
id = Column(String(40), primary_key=True)
check_no = Column(DECIMAL(precision=28, scale=1),
nullable=False,
comment="题号")
check_item = Column(Text, nullable=False, comment="题目内容")
check_genre = Column(String(200), nullable=False, comment="题目标签")
check_type = Column(String(50), nullable=False, comment="检查单类型")
class air_hwys_dgr_level(Base):
__tablename__ = "air_hwys_dgr_level"
id = Column(String(200), primary_key=True) # 主键
dgr_id = Column(String(200)) # 关联外键
dgr_level = Column(String(200)) # 等级
airliner_capacity = Column(String(200)) # 客机容量
airliner_description_no = Column(String(200)) # 客机说明号
airliner_is_single = Column(String(200)) # 客机是否可单一
airfreighter_capacity = Column(String(200)) # 货机容量
airfreighter_description_no = Column(String(200)) # 货机说明号
airfreighter_is_single = Column(String(200)) # 货机是否可单一
message = Column(String(2000)) # 备注
class an_mechandise_inventory_part(Base):
"""
盘库记录分单
"""
__tablename__ = "an_mechandise_inventory_part"
id = Column(String(40), primary_key=True)
main_id = Column(String(40), comment="盘库记录主单id")
master_id = Column(String(40), comment="进出港id")
master_number = Column(String(40), comment="主单号")
master_number_cut = Column(String(4), comment="主单号后四位切片")
createtime = Column(DateTime, default=datetime.datetime.now())
preservation_area = Column(String(128), comment="区域")
storing_location = Column(String(128), comment="仓位")
preservation_type = Column(String(128), comment="类别")
board_no = Column(String(255), comment="板号")
class t_bgs_file(Base):
"""
文件存储
"""
__tablename__ = "t_bgs_file"
id = Column(String(40), primary_key=True)
file_name = Column(String(100), comment="文件名")
file_type = Column(String(10), comment="文件类型1,2,3")
file_src = Column(String(255), comment="文件路径")
f_id = Column(String(40), comment="关联外键")
file_suffix = Column(String(20), comment="文件后缀")
create_time = Column(DateTime, default=datetime.datetime.now())
file_class = Column(String(100), comment="标记")
class an_mechandis_inventory_time(Base):
"""
盘库时间
"""
__tablename__ = "an_mechandis_inventory_time"
id = Column(String(40), primary_key=True)
start_time_hour = Column(String(10), nullable=False, default=0)
start_time_minute = Column(String(10), default=0)
start_time_second = Column(String(10), default=0)
end_time_hour = Column(String(10), nullable=False, default=12)
end_time_minute = Column(String(10), default=0)
end_time_second = Column(String(10), default=0)
times = Column(Integer, comment="次数1or2")
class an_procedure_picture(Base):
"""
进出港图片
"""
__tablename__ = "an_procedure_picture"
id = Column(String(40), primary_key=True)
procedure_id = Column(String(40))
file_name = Column(String(100), comment="图片名")
file_src = Column(String(255), comment="图片路径")
file_url = Column(String(255), comment="图片路由，暂未用到")
user_id = Column(String(40), comment="用户id")
user_name = Column(String(50), comment="用户名")
createtime = Column(DateTime, comment="创建时间")
type = Column(
String(255),
comment=
"图片类型stork入库shipping_front正面shipping_diaforward斜前shipping_diaback斜后shipping_back后面whole整体check_item检查单"
)
class air_hwys_dgr_container(Base):
__tablename__ = "air_hwys_dgr_container"
id = Column(String(200), primary_key=True) # 主键
dgr_level_id = Column(String(200)) # 关联外键
dgr_container = Column(String(200)) # 容器类型
dgr_container_capacity = Column(String(200)) # 容量
dgr_type = Column(String(60)) # 客机/货机
dgr_container_message = Column(String(2000)) #
class an_check_history_item(Base):
"""
检查结果
"""
__tablename__ = "an_check_history_item"
id = Column(String(40), primary_key=True)
check_id = Column(String(40), comment="检查单题目id")
history_id = Column(String(40), comment="检查历史id")
check_no = Column(DECIMAL(precision=28, scale=1),
nullable=False,
comment="题号")
check_item = Column(Text, nullable=False, comment="题目内容")
check_genre = Column(String(200), nullable=False, comment="题目标签")
check_answer = Column(String(10), comment="结果YES NO N/A")
class an_check_history(Base):
"""
检查历史
"""
__tablename__ = "an_check_history"
id = Column(String(40), primary_key=True)
check_type = Column(String(50), nullable=False, comment="检查单类型")
user_id = Column(String(40), nullable=False, comment="操作人")
user_name = Column(String(50), nullable=False, comment="操作人姓名")
createtime = Column(DateTime,
default=datetime.datetime.now(),
comment="操作时间")
master_id = Column(String(40), comment="主单id")
times = Column(String(10), comment="次数first第一次second第二次")
class t_bgs_shipper_consignee_info(Base):
"""
收发货人信息表
"""
__tablename__ = "t_bgs_shipper_consignee_info"
id = Column(String(40), primary_key=True)
company_name = Column(String(255), comment="公司名称")
company_address = Column(String(255), comment="公司地址")
country = Column(String(255), comment="国家")
phone = Column(String(255), comment="电话")
name = Column(String(255), comment="姓名")
mailbox = Column(String(255), comment="邮箱")
fax = Column(String(255), comment="传真")
state_code = Column(String(255), comment="洲代码")
info_state = Column(String(255), comment="货运人信息状态1发货人2收货人")
odd_number = Column(String(40), comment="归属分单号")
master_number = Column(String(255), comment="主单号")
city = Column(String(255), comment="城市")
class t_bgs_un_pack(Base):
"""
包装详情
"""
__tablename__ = "t_bgs_un_pack"
id = Column(Integer, primary_key=True, autoincrement=True)
status = Column(String(255), comment="打包状态")
packInfo = Column(String(255), comment="打包信息")
Qnumber = Column(Integer)
material = Column(String(255))
introduceX = Column(String(255))
packNumber = Column(String(255))
unit = Column(String(255), comment="单位")
weight = Column(String(255), comment="重量")
oddNumberId = Column(String(255), comment="分单号id")
oddNumber = Column(String(255), comment="分单号")
masterNumber = Column(String(255), comment="主单号id")
unNumber = Column(String(255), comment="UN编号")
unNumberId = Column(String(255), comment="UN编号id")
MAIN_DANGEROUS_ID = Column(Integer, comment="主要危险品ID")
packaging_category = Column(String(255), comment="包装类别")
product_name = Column(String(255), comment="品名")
TechnicalName = Column(String(255), comment="技术名称")
productNameSelect = Column(String(255), comment="两个特殊下拉项")
difference = Column(String(255))
class air_hwys_jd(Base):
__tablename__ = "air_hwys_jd"
id = Column(String(200), primary_key=True) # 主键id
jcno = Column(String(1000)) # 进仓编号
createtime = Column(DATE, default=datetime.datetime.now()) # 创建时间
endtime = Column(DATE) # 出鉴定日期
reportno = Column(String(1000)) # 报告编号
chinesename = Column(String(2000)) # 中文品名
englishname = Column(String(2000)) # 英文品名
appearance = Column(String(200)) # 外观-颜色
identificationunits = Column(String(200)) # 鉴定委托单位
cost = Column(String(200), default="未填写") # 费用
remarks = Column(String(2000)) # 备注
principal = Column(String(200)) # 鉴定委托人
jdtime = Column(DATE) # 做鉴定日期
singlenode = Column(String(20)) # 是否结单
crz = Column(String(200)) # 客服人
unno = Column(String(200)) # UN信息
wphw = Column(String(20)) # 危险品/普货
cz = Column(String(200)) # 单据操作者
flag = Column(String(10)) # 是否带入中文品名
flag2 = Column(String(10)) # 是否带入英文品名
flag3 = Column(String(10)) # 是否带入成本费用
flag4 = Column(String(10), default="0") # 展示标识
flag5 = Column(String(10)) # 带入鉴定单
factory = Column(String(200)) # 生产厂家
appearance2 = Column(String(200)) # 外观-状态
casno = Column(String(100)) # CAS NO号码
costtype = Column(String(50)) # 费用种类
class air_hwys_lines(Base):
__tablename__ = "air_hwys_lines"
id = Column(String(200), primary_key=True) # 主键id
airline = Column(String(200)) # 航线编号
aircompany = Column(String(200)) # 航空公司
airname = Column(String(200)) # 航空类型
flight = Column(String(200)) # 航班编号
depa = Column(String(50)) # 起飞地
dest = Column(String(50)) # 目的地
mydate = Column(String(50)) # 航班日期
etd = Column(String(50)) # 起飞时间
eta = Column(String(50)) # 落地时间
supporttime = Column(String(100)) # 交单时间
aircraft = Column(String(200)) # 机型
remark = Column(Text) # 备注
class an_procedure(Base):
"""
进出港
"""
__tablename__ = "an_procedure"
id = Column(String(40), primary_key=True)
master_number = Column(String(40), nullable=False, comment="运单号")
master_number_cut = Column(String(4), nullable=False, comment="运单号后四位")
port_of_departure = Column(String(255), comment="起运港")
destination_port = Column(String(255), comment="目的港")
type_of_shipping = Column(String(255), comment="运输方式")
freight_type = Column(String(255), comment="货运类型")
product_number = Column(Integer, comment="件数")
preservation_area = Column(String(128), comment="区域")
storing_location = Column(String(128), comment="仓位")
preservation_type = Column(String(128), comment="类别")
board_no = Column(String(255), comment="板号")
weight = Column(Integer, comment="重量")
remarks = Column(String(255), comment="备注")
inputer_id = Column(String(40), comment="操作人id", nullable=False)
inputer_name = Column(String(50), comment="操作人", nullable=False)
inputer_card_no = Column(String(255), comment="操作人证件号", nullable=False)
handover_name = Column(String(50), comment="交接人")
handover_card_no = Column(String(255), comment="交接人身份证号")
handover_inputer_id = Column(String(40), comment="交接操作人id")
handover_inputer_name = Column(String(50), comment="交接操作人")
delivery_name = Column(String(50), comment="出库人")
delivery_card_no = Column(String(255), comment="出库人身份证号")
delivery_inputer_id = Column(String(40), comment="出库操作人id")
delivery_inputer_name = Column(String(50), comment="出库操作人")
repeat_warehousing_name = Column(String(50), comment="重新入库人")
repeat_warehousing_card_no = Column(String(255), comment="重新入库人身份证号")
repeat_warehousing_inputer_id = Column(String(40), comment="重新入库操作人id")
repeat_warehousing_inputer_name = Column(String(50), comment="重新入库操作人")
create_time = Column(DateTime,
default=datetime.datetime.now(),
comment="创建时间")
handover_time = Column(DateTime, comment="交接时间")
delivery_time = Column(DateTime, comment="出库时间")
repeat_warehousing_time = Column(DateTime, comment="重新入库时间")
procedure_type = Column(String(10), comment="出入港类型，in入港out出港")
preservation = Column(String(10), comment="出入库状态，in入库out出库repeat重新入库")
class oauth_client_details(Base):
__tablename__ = "oauth_client_details"
client_id = Column(String(255), primary_key=True)
resource_ids = Column(String(255))
client_secret = Column(String(255), nullable=False)
scope = Column(String(255), nullable=False)
authorized_grant_types = Column(String(255), nullable=False)
web_server_redirect_uri = Column(String(255))
authorities = Column(String(255))
access_token_validity = Column(Integer, nullable=False)
refresh_token_validity = Column(Integer, nullable=False)
additional_information = Column(Text)
autoapprove = Column(Boolean, nullable=False)
origin_secret = Column(String(255))
class t_bgs_main_single_number(Base):
"""
主单号表
"""
__tablename__ = "t_bgs_main_single_number"
id = Column(String(40), primary_key=True)
master_number = Column(String(30), comment="主单号")
type_of_shipping = Column(String(255), comment="运输方式")
freight_type = Column(String(255), comment="货运类型")
port_of_departure = Column(String(255), comment="起运港")
destination_port = Column(String(255), comment="目的港")
emergency_contact = Column(String(255), comment="紧急联系人电话")
ATTN = Column(String(255), comment="紧急联系人")
statement = Column(String(255), comment="声明")
statement_name = Column(String(255), comment="声明人名称")
statement_title = Column(String(255), comment="声明人职务")
statement_address = Column(String(255), comment="声明人地址")
name_image_file = Column(String(255), comment="签名图片位置")
WARNING = Column(String(255), comment="警告")
create_time = Column(DateTime, default=datetime.datetime.now())
place_and_data = Column(String(255), comment="签名日期")
note = Column(String(255), comment="备注")
is_print = Column(String(255), comment="是否生成预申报单预览1生成0不生成")
is_pack = Column(String(255), comment="是否打包")
order_time = Column(String(255), comment="预约时间")
class an_user(Base):
"""
android端用户表
"""
__tablename__ = "an_user"
user_id = Column(String(40), primary_key=True)
user_name = Column(String(255), nullable=False, comment="用户名")
user_password = Column(String(128), nullable=False, comment="密码")
user_mobile = Column(String(20), comment="手机号")
isdelete = Column(String(4), default="0", comment="状态0可用1不可用")
createtime = Column(DateTime,
default=datetime.datetime.now(),
nullable=False,
comment="创建时间")
updatetime = Column(DateTime,
default=datetime.datetime.now(),
nullable=False,
comment="更新时间")
cardno = Column(String(255), comment="证件号")
cardtype = Column(String(10), comment="证件类型1身份证2护照3港澳台")
user_sex = Column(String(10), comment="性别1男2女")
user_truename = Column(String(50), nullable=False, comment="姓名")
user_email = Column(String(128), comment="邮箱")
user_level = Column(String(10), default="0", comment="用户权限")
class t_bgs_un_dictionaries(Base):
__tablename__ = "t_bgs_un_dictionaries"
id = Column(Integer, primary_key=True)
UNNumberA = Column(String(11), comment="UN编号")
ProperShippingNameB = Column(String(5000), comment="英文品名")
ClassDivSubC = Column(String(255))
HazardLabelsD = Column(String(255))
PackingGroupE = Column(String(255))
ExceptedQtyF = Column(String(255))
PCALtdQtyPIG = Column(String(255))
PCALtdQtyMaxNetQtyH = Column(String(255))
PCAPII = Column(String(255))
PCAMaxNetQtyJ = Column(String(255))
CAOPIK = Column(String(255))
CAOMaxNetQtyL = Column(String(255))
SPM = Column(String(255))
ERGN = Column(String(255))
ColumnENEqui = Column(String(255))
ColumnSORT = Column(String(3000))
ColumnBOLD = Column(String(5000))
ColumnSearch = Column(String(5000))
Images = Column(String(255))
class t_bgs_un(Base):
"""un与主分单对应表"""
__tablename__ = "t_bgs_un"
id = Column(String(40), primary_key=True)
UN_NUMBER = Column(String(255), comment="UN编号")
packaging_instruction = Column(String(255), comment="包装指导")
packaging_grade = Column(String(255), comment="包装等级")
packaging_category = Column(String(255), comment="包装类别")
product_Name = Column(String(255), comment="品名")
introduce = Column(String(255), comment="说明")
MAIN_DANGEROUS_ID = Column(Integer, comment="主要危险品id")
SECOND_DANGEROUS_IDA = Column(String(255), comment="次要危险品ida")
SECOND_DANGEROUS_IDB = Column(String(255), comment="次要危险品idb")
odd_number = Column(String(40), comment="分单号")
master_number = Column(String(255), comment="主单号")
RadioactivityLevel = Column(String(255), comment="放射性等级")
TIM = Column(String(255))
nuclideName = Column(String(255))
height = Column(String(255))
width = Column(String(255))
un_long = Column(String(255))
weight = Column(String(255), comment="重量")
unit = Column(String(255), comment="单位")
packNumber = Column(String(255), comment="件数")
material = Column(String(255), comment="材质")
TechnicalName = Column(String(255), comment="技术名称")
productNameSelect = Column(String(255), comment="两个特殊下拉项")
difference = Column(String(255))
class air_hwys_dgr(Base):
__tablename__ = "air_hwys_dgr"
id = Column(String(200), primary_key=True) # 主键
unno = Column(String(200)) # UN号
unname = Column(String(200)) # 运输专用名称
untype = Column(String(40)) # 类别
