aa

Tables (6)

tb_Etc

  • idx — int(11) — Primary key — NOT NULL
  • Station — char(3)
  • eHawbNo — varchar(30)
  • eOrderNo — varchar(50)
  • eDate — varchar(10)
  • eCnt — int(11)
  • remark — varchar(500)
  • wDate — datetime
  • wUserid — varchar(50)
  • wUserip — varchar(50)
  • INDEX — `idx_tb_Etc_Station`

tb_Etc_Area

  • zipCode — varchar(10) — Primary key — NOT NULL
  • eArea — varchar(30)

tb_Mawb

  • MawbNo — varchar(20) — Primary key — NOT NULL
  • Station — char(3) — Primary key — NOT NULL
  • ArrDate — varchar(8) — NOT NULL
  • ArrTime — varchar(4)
  • DepDate — varchar(8) — NOT NULL
  • DepTime — varchar(4)
  • wdate — varchar(50)
  • fltno — varchar(30)
  • mdate — varchar(50)
  • CustomsDivi — char(3) — 관세사
  • PickDate — varchar(8) — 픽업일자
  • PickTime — varchar(4)
  • Remark — varchar(200)
  • Kctdi — varchar(50)
  • Cnfrm_YN — varchar(1)
  • Rdate — datetime
  • INDEX — `idx_tb_Mawb_MawbNo`
  • INDEX — `idx_tb_Mawb_arrDate`
  • INDEX — `idx_arrdate`
  • INDEX — `idx_mawbno_station`

tb_OtherDelivery

  • OtherBL — varchar(30) — Primary key — NOT NULL
  • OriginalBL — varchar(50) — Primary key — NOT NULL
  • DlvStatus — varchar(20) — Primary key — NOT NULL
  • Station — char(3)
  • DlvCom — varchar(20)
  • DlvTime — varchar(20)
  • DlvBranch — varchar(20)
  • Remark — varchar(20)
  • WDate — timestamp — NOT NULL
  • WUserId — varchar(50)
  • WUserIp — varchar(50)
  • CloseYn — varchar(1)
  • INDEX — `idx_tb_OtherDelivery_OriginalBL`
  • INDEX — `idx_tb_OtherDelivery_WDate`
  • INDEX — `idx_tb_OtherDelivery_DlvStatus`
  • INDEX — `idx_tb_OtherDelivery_Station`
  • INDEX — `idx_tb_OtherDelivery_DelCom`

tb_PODErr

  • uid — int(11) — Primary key — NOT NULL
  • MawbNo — varchar(20)
  • HawbNo — varchar(30)
  • ErrCode — varchar(30)
  • wdate — varchar(50)
  • UploadType — char(3) — 업로드방식
  • ErrCommentKr — text — 오류내용-한글
  • ErrCommentEn — text — 오류내용-영문
  • Remark — varchar(1000)
  • obYn — varchar(10) — 쿠팡 고객 안내요청 여부
  • rWdate — datetime
  • INDEX — `IDX_tb_PODErr_ErrCode`
  • INDEX — `idx_tb_PODErr_01`
  • INDEX — `idx_tb_PODErr_MawbNo`

tb_PccError

  • HawbNo — varchar(30) — Primary key — NOT NULL
  • PCCYN — char(1) — 개인통관부호여부
  • MawbNo — varchar(20)
  • SmsSentDate — varchar(20)
  • Wdate — datetime
  • INDEX — `idx_tb_PccError_MawbNo`