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)) # 类别