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`