友商旅机票相关表结构关联关系

PKID: int(11)AirportCode: varchar(10)AirportCNName: varchar(100)AirportENName: varchar(200)AirportCityCode: varchar(10)AirportCityCNName: varchar(100)AirportCityENName: varchar(200)AirportPinYin: varchar(100)AirportJianPin: varchar(100)CountryCode: varchar(10)CountryCNName: varchar(100)CountryENName:  varchar(200)AreaCode: varchar(10)AreaName: varchar(100)IsDomc: varchar(10)CreateBy: varchar(50)CreateTime: datetimeModifyBy: varcharModifyTime: datetimeIsHot: varchar(1)

PlatformOrderNo

PKID: int(11)ApplyOrderNo: varchar(20)LinkApplyOrderNo: varchar(20)UserCode: varchar(10)DepartmentID: int(11)ApplyType: int(11)TravelCode: varchar(20)Matters: varchar(100)FromLocationCode: varchar(10)FromLocationName: varchar(20)LocationCode: varchar(80)LocationName: varchar(400)StartDate: dateEndDate: dateRemark: varchar(100)ApproveType: int(11)ApproveStatus: int(11)ApproveLevel: int(11)CurrentLevel: int(11)CreateBy: varchar(50)ModifyTime: datetimeTimeStamp: bigintCreateTime:  datetimeIsdel: int(11)CostCenterCode: varchar(50)CostCenterCodeName: varchar(500)BillStatus: int(11)BookingDeptCode: varchar(50)BookingDeptName: varchar(200)CostCenterName: varchar(500)ouCode: varchar(20)ouName: varchar(50)

OrderNo

AirportCode

t_passengerinfo

ApplyOrderNo

t_base_airportcity

t_platform_orderassistant

t_platform_orderticket

t_flightinfo

TktNo

t_platform_order

t_tripapplyorder