zippy_admin
Tables (27)
APT_HO_INFO_41310 (Untitled23)
- SIG_CD (Key) — Primary key — NOT NULL
- DONG_SN (Key2) — Primary key — NOT NULL
- HO_SN (Key3) — Primary key — NOT NULL
- BUL_MAN_NO (Field)
- HO_NM (Field2)
- HO_AREA (Field3)
- HO_AREA_WEB (Field4)
- HO_AREA_QRY (Field5)
- HO_PRICE (Field6)
- HO_PRICE_WEB (Field7)
- HO_OWN_TYPE (Field8)
- AREA_FLG (Field9)
- PRICE_FLG (Field10)
PROD_EPOST_DLV_INFO_SEND (Untitled2)
- RECEIP_NO (Key) — Primary key — NOT NULL
- DLV_POST_CD (Field)
- ADDR_CNT (Field2)
- RECEIVE_DATE (Field3)
- INS_DATE (Field4)
- INS_TIME (Field5)
- DEL_TF (Field6)
SLOCALDATA_LRG_CD (Untitled3)
- BIZ_LRG_CD (Key) — Primary key — NOT NULL
- BIZ_LRG_NM (Field)
- LMS_GUB (Field2)
SLOCALDATA_MID_CD (Untitled4)
- BIZ_LRG_CD (Key) — Primary key — NOT NULL
- BIZ_MID_CD (Key2) — Primary key — NOT NULL
- BIZ_LRG_NM (Field)
- BIZ_MID_NM (Field2)
- LMS_GUB (Field3)
TABLE_ADMIN_GRUOP (Untitled5)
- GROUP_NO (Key) — Primary key — NOT NULL
- GROUP_NAME (Field)
- GROUP_FLAG (Field2)
- USE_TF (Field3)
- DEL_TF (Field4)
- REG_ADM (Field5)
- REG_DATE (Field6)
- UP_ADM (Field7)
- UP_DATE (Field8)
- DEL_ADM (Field9)
- DEL_DATE (Field10)
TABLE_ADMIN_INFO (Untitled6)
- ADM_NO (Key3) — Primary key — NOT NULL
- ADM_ID (Key) — Primary key — NOT NULL
- PASSWD (Field)
- ADM_NAME (Field2)
- ADM_INFO (Field3)
- ADM_HPHONE (Field4)
- ADM_PHONE (Field5)
- ADM_EMAIL (Field6)
- GROUP_NO (Field7)
- ADM_FLAG (Field8)
- POSITION_CODE (Field9)
- DEPT_CODE (Field10)
- COM_CODE (Field11)
- USE_TF (Field12)
- DEL_TF (Field13)
- SMS_TF (Field14)
- REG_ADM (Field15)
- REG_DATE (Field16)
- UP_ADM (Field17)
- UP_DATE (Field18)
- DEL_ADM (Field19)
- DEL_DATE (Field20)
TABLE_ADMIN_MENU_RIGHT (Untitled7)
- MENU_CD (Key) — Primary key — NOT NULL
- GROUP_NO (Key2) — Primary key — NOT NULL
- READ_FLAG (Field11)
- REG_FLAG (Field12)
- UPD_FLAG (Field13)
- DEL_FLAG (Field14)
- FILE_FLAG (Field15)
- TOP_FLAG (Field16)
- MAIN_FLAG (Field)
- USE_TF (Field3)
- DEL_TF (Field4)
- REG_ADM (Field5)
- REG_DATE (Field6)
- UP_ADM (Field7)
- UP_DATE (Field8)
- DEL_ADM (Field9)
- DEL_DATE (Field10)
TBL_CODE_DETAIL (Untitled8)
- DCODE_NO (Key) — Primary key — NOT NULL
- PCODE (Key2) — Primary key — NOT NULL
- DCODE (Field)
- DCODE_NM (Field2)
- DCODE_EXT (Field11)
- DCODE_SEQ_NO (Field12)
- USE_TF (Field3)
- DEL_TF (Field4)
- REG_ADM (Field5)
- REG_DATE (Field6)
- UP_ADM (Field7)
- UP_DATE (Field8)
- DEL_ADM (Field9)
- DEL_DATE (Field10)
TBL_CODE_PARENT (Untitled9)
- PCODE_NO (Key2) — Primary key — NOT NULL
- SITE_NO (Field13)
- PCODE (Field)
- PCODE_NM (Field2)
- PCODE_EXT (Field11)
- PCODE_SEQ_NO (Field12)
- USE_TF (Field3)
- DEL_TF (Field4)
- REG_ADM (Field5)
- REG_DATE (Field6)
- UP_ADM (Field7)
- UP_DATE (Field8)
- DEL_ADM (Field9)
- DEL_DATE (Field10)
TBL_COMPANY (Untitled)
- CP_NO (Field2) — Primary key
- CP_TYPE (Field3)
- CP_NM (Field4)
- CP_PTHONE (Field5)
- CP_HPHONE (Field6)
- CP_FAX (Field7)
- CP_ZIP (Field8)
- CP_ADDR (Field9)
- RE_ZIP (Field39)
- RE_ADDR (Field40)
- HOMEPAGE (Field10)
- BIZ_NO (Field11)
- CEO_NM (Field12)
- UPJONG (Field13)
- UPTEA (Field14)
- DC_RATE (Field15)
- MANAGER_NM (Field16)
- PHONE (Field17)
- HPHOPE (Field18)
- FPHONE (Field19)
- EMAIL (Field20)
- EMAIL_TF (Field21)
- CONTRACT_START (Field22)
- CONTRACT_END (Field23)
- AD_TYPE (Field24)
- ACCOUNT_BANK (Field25)
- ACCOUNT (Field26)
- DELIVERY_LIMIT (Field27)
- DELIBERY_PRICE (Field28)
- MEMO (Field29)
- COM_AUTH_TF (Field30)
- USE_TF (Field31)
- DEL_TF (Field32)
- REG_ADM (Field33)
- REG_DATE (Field34)
- UP_ADM (Field35)
- UP_DATE (Field36)
- DEL_ADM (Field37)
- DEL_DATE (Field38)
TBL_PAGES (CopyOfUntitled)
- PAGE_NO (Field2)
- PAGE_LANG (Field3)
- PAGE_CD (Field4)
- PAGE_NAME (Field5)
- PAGE_URL (Field6)
- PAGE_SEQ01 (Field7)
- PAGE_SEQ02 (Field8)
- PAGE_SEQ03 (Field9)
- PAGE_SEQ04 (Field39)
- PAGE_SEQ05 (Field40)
- PAGE_FLAG (Field10)
- PAGE_RIGHT (Field11)
- TITLE_IMG (Field12)
- TITLE_IMG_OVER (Field13)
- PAGE_IMG (Field14)
- PAGE_IMG_OVER (Field15)
- PAGE_SCRIPT (Field16)
- PAGE_CONTENT (Field17)
- PAGE_INFO01 (Field18)
- PAGE_INFO02 (Field19)
- PAGE_INFO03 (Field20)
- USE_TF (Field31)
- DEL_TF (Field32)
- REG_ADM (Field33)
- REG_DATE (Field34)
- UP_ADM (Field35)
- UP_DATE (Field36)
- DEL_ADM (Field37)
- DEL_DATE (Field38)
TBL_POSA_PRICE (Untitled10)
- PRICE_NO (Key) — Primary key — NOT NULL
- GD_TYPE (Field)
- GD_INFO_CNT (Field2)
- ST_TYPE (Field3)
- E_PRICE (Field4)
- D_PRICE (Field5)
TBL_POSA_WORK_DELIVERY (Untitled11)
- WORK_NO (Key) — Primary key — NOT NULL
- DEL_NO (Key2) — Primary key — NOT NULL
- REV_NAME (Field)
- REV_TEL (Field2)
- REV_HP (Field3)
- REV_OFFICE_NAME (Field4)
- DEL_TYPE (Field5)
- DEL_DATE (Field6)
- ADDR_POST (Field7)
- ADDR_INFO (Field8)
- ADDR_INFO2 (Field9)
- SONGJANG_NO (Field10)
- SONGJANG_COM (Field11)
- BOX_INFO01 (Field12)
- BOX_INFO02 (Field13)
- BOX_INFO03 (Field14)
- BOX_INFO0 (Field15)
- DELIVERY_CNT (Field16)
TBL_POSA_WORK_FILE (Untitled12)
- FILE_NO (Key) — Primary key — NOT NULL
- WORK_NO (Field)
- FILE_TYPE (Field2)
- FILE_NM (Field3)
- FILE_RNM (Field4)
- FILE_SIZE (Field5)
TBL_POSA_WORK_INFO (Untitled13)
- WORK_NO (Key) — Primary key — NOT NULL
- GOODS_SEQ (Key2) — Primary key — NOT NULL
- GOODS_NM (Field)
- SUB_INFO01 (Field2)
- SUB_INFO02 (Field3)
- SUB_INFO03 (Field4)
- SUB_INFO04 (Field5)
- SUB_INFO05 (Field6)
TBL_POSA_WORK_MASTER (CopyOfUntitled11)
- WORK_NO (Key) — Primary key — NOT NULL
- ADDR_ADM (Key2) — Foreign key → TBL_POSA_WORK_MASTER.WORK_NO — NOT NULL
- WORK_STATE (Field)
- WORK_MEMO (Field2)
- WORK_REG_DATE (Field3)
- DEL_REQ_DATE (Field4)
- REG_NO (Field5)
- WORK_TITLE (Field6)
- REG_POST_OFFICE (Field7)
- REG_POST_TEL (Field8)
- REG_POST_EMAIL (Field9)
- REG_POST_MANAGER (Field10)
- REG_POST_HP (Field11)
- REG_POST_FAX (Field12)
- REQ_OFFICE (Field13)
- REQ_TEL (Field14)
- REQ_EMAIL (Field15)
- REQ_MANAGER (Field16)
- REQ_HP (Field17)
- REQ_FAX (Field18) — NOT NULL
- GOODS_TYPE (Field19)
- STD_TYPE (Field20)
- GOODS_QTY (Field21)
- GOODS_INFO01 (Field22)
- GOODS_INFO02 (Field23)
- GOODS_INFO03 (Field24)
- GOODS_MEMO (Field25)
- ADDR_TF (Field26)
- ADDR_END (Field28)
- DG_TF (Field29)
- DG_ADM (Field30)
- DG_END (Field31)
- WORK_OFFICE (Field32)
- WORK_ADM_NO (Field33)
- WORK_POSITION (Field34)
- WORK_TEL (Field35)
- WORK_HP (Field36)
- WORK_EMAIL (Field37)
- STATE_UP_DATE (Field38)
- USE_TF (Field39)
- DEL_TF (Field40)
- REG_ADM (Field41)
- REG_DATE (Field42)
- UP_ADM (Field43)
- UP_DATE (Field44)
- DEL_ADM (Field45)
- DEL_DATE (Field46)
- E_PRICE (Field47)
- D_PRICE (Field48)
- Z_PRICE (Field49)
- acc_price (Field50)
- fee_price (Field51)
- acc_reg_no (Field52)
- acc_time (Field53)
- goods_paper (Field54)
- paper_txt1 (Field55)
- paper_txt2 (Field56)
- paper_txt3 (Field57)
- paper_txt4 (Field58)
- req_memo (Field59)
- … +9
TBL_POSA_WORK_SMS_HISTORY (Untitled14)
- WORK_NO (Key) — Primary key — NOT NULL
- SEND_TYPE (Key2) — Primary key — NOT NULL
- SEND_PHONE (Key3) — Primary key — NOT NULL
- SEND_DATE (Field)
TBL_POST_INFO (Untitled15)
- POST_SEQ_NO (Key) — Primary key — NOT NULL
- POST_TYPE (Field)
- POST_TYPE2 (Field2)
- POST_NUM (Field3)
- POST_NAME (Field4)
- CHUNG (Field5)
- CHUNG_NAME (Field6)
- POST_ENAME (Field7)
- POST_CODE (Field8)
- POST_SNAME (Field9)
- POST_NUM2 (Field10)
- POST_NUM3 (Field11)
- POST_NUM4 (Field12)
- IS_EXP (Field13)
- IS_CLOSE (Field14)
- POST_NUM5 (Field15)
- LEVEL_NAME (Field16)
- IS_CON01 (Field17)
- IS_CON02 (Field18)
- IS_CON03 (Field19)
- IS_CON04 (Field20)
- IS_CON05 (Field21)
- IS_CON06 (Field22)
- POST_NUM6 (Field23)
- DELIV_NAME (Field24)
- DELIV_CODE1 (Field25)
- DELIV_CODE2 (Field26)
- TEL (Field27)
- ADDR (Field28)
- FAX1 (Field29)
- FAX2 (Field30)
- ETC_INFO_01 (Field31)
- ETC_INFO_02 (Field32)
- ETC_INFO_03 (Field33)
- ETC_INFO_04 (Field34)
- ETC_INFO_05 (Field35)
- ETC_INFO_06 (Field36)
- ETC_INFO_07 (Field37)
- ETC_INFO_08 (Field38)
- ETC_INFO_09 (Field39)
- ETC_INFO_10 (Field40)
- ETC_INFO_11 (Field41)
- ETC_INFO_12 (Field42)
- ETC_INFO_13 (Field43)
- ETC_INFO_14 (Field44)
- ETC_INFO_15 (Field45)
- ETC_INFO_16 (Field46)
TBL_POST_INFO2 (Untitled16)
- POST_SEQ_NO (Key) — Primary key — NOT NULL
- POST_NAME (Field)
- DELIVERY_NAME (Field2)
- POST_CODE (Field3)
- TEL (Field4)
- ADDR (Field5)
- FAX1 (Field6)
- FAX2 (Field7)
TBL_PRICE (Untitled17)
- PRICE_NO (Key) — Primary key — NOT NULL
- GD_TYPE (Field)
- GD_INFO_CNT (Field2)
- ST_TYPE (Field3)
- E_PRICE (Field4)
- D_PRICE (Field5)
TBL_RESERVE_NO (Untitled18)
- SEQ_NO (Key) — Primary key — NOT NULL
- CNT_NO (Field)
- THIS_DATE (Field2)
TBL_WORK_DELIVERY (Untitled19)
- WORK_NO (Key) — Primary key — NOT NULL
- DEL_NO (Key2) — Primary key — NOT NULL
- REV_NAME (Field)
- REV_TEL (Field2)
- REV_HP (Field3)
- REV_OFFICE_NAME (Field4)
- DEL_TYPE (Field5)
- DEL_DATE (Field6)
- ADDR_POST (Field7)
- ADDR_INFO (Field8)
- ADDR_INFO2 (Field9)
- SONGJANG_NO (Field10)
- SONGJANG_COM (Field11)
- BOX_INFO01 (Field12)
- BOX_INFO02 (Field13)
- BOX_INFO03 (Field14)
- BOX_INFO04 (Field15)
- DELIVERY_CNT (Field16)
TBL_WORK_FILE (Untitled20)
- FILE_NO (Key) — Primary key — NOT NULL
- WORK_NO (Field)
- FILE_TYPE (Field2)
- FILE_NM (Field3)
- FILE_RNM (Field4)
- FILE_SIZE (Field5)
TBL_WORK_INFO (Untitled21)
- WORK_NO (Key) — Primary key — NOT NULL
- GOODS_SEQ (Key2) — Primary key — NOT NULL
- GOODS_NM (Field)
- SUB_INFO01 (Field2)
- SUB_INFO02 (Field3)
- SUB_INFO03 (Field4)
- SUB_INFO04 (Field5)
- SUB_INFO05 (Field6)
TBL_WORK_MASTER (CopyOfCopyOfUntitled11)
- WORK_NO (Key) — Primary key — NOT NULL
- WORK_STATE (Field)
- WORK_MEMO (Field2)
- WORK_REG_DATE (Field3)
- DEL_REQ_DATE (Field4)
- REG_NO (Field5)
- WORK_TITLE (Field6)
- REG_POST_OFFICE (Field7)
- REG_POST_TEL (Field8)
- REG_POST_EMAIL (Field9)
- REG_POST_MANAGER (Field10)
- REG_POST_HP (Field11)
- REG_POST_FAX (Field12)
- REQ_OFFICE (Field13)
- REQ_TEL (Field14)
- REQ_EMAIL (Field15)
- REQ_MANAGER (Field16)
- REQ_HP (Field17)
- REQ_FAX (Field18) — NOT NULL
- GOODS_TYPE (Field19)
- STD_TYPE (Field20)
- GOODS_QTY (Field21)
- GOODS_INFO01 (Field22)
- GOODS_INFO02 (Field23)
- GOODS_INFO03 (Field24)
- GOODS_MEMO (Field25)
- ADDR_TF (Field26)
- ADDR_ADM (Field27)
- ADDR_END (Field28)
- DG_TF (Field29)
- DG_ADM (Field30)
- DG_END (Field31)
- WORK_OFFICE (Field32)
- WORK_ADM_NO (Field33)
- WORK_POSITION (Field34)
- WORK_TEL (Field35)
- WORK_HP (Field36)
- WORK_EMAIL (Field37)
- STATE_UP_DATE (Field38)
- USE_TF (Field39)
- DEL_TF (Field40)
- REG_ADM (Field41)
- REG_DATE (Field42)
- UP_ADM (Field43)
- UP_DATE (Field44)
- DEL_ADM (Field45)
- DEL_DATE (Field46)
- E_PRICE (Field47)
- D_PRICE (Field48)
- Z_PRICE (Field49)
- acc_price (Field50)
- fee_price (Field51)
TBL_WORK_SMS_HISTORY (CopyOfUntitled14)
- WORK_NO (Key) — Primary key — NOT NULL
- SEND_TYPE (Key2) — Primary key — NOT NULL
- SEND_PHONE (Key3) — Primary key — NOT NULL
- SEND_DATE (Field)
UDS_MSG (Untitled22)
- CMID (Key) — Primary key — NOT NULL
- UMID (Field)
- MSG_TYPE (Field2)
- STATUS (Field3)
- REQUEST_TIME (Field4)
- SEND_TIME (Field5)
- REPORT_TIME (Field6)
- DEST_PHONE (Field7)
- DEST_NAME (Field8)
- SEND_PHONE (Field9)
- SEND_NAME (Field10)
- SUBJECT (Field11)
- MSG_BODY (Field12)
- WAP_URL (Field13)
- COVER_FLAG (Field14)
- SMS_FLAG (Field15)
- REPLY_FLAG (Field16)
- RETRY_CNT (Field17)
- FAX_FILE (Field18)
- VXML_FILE (Field19)
- CALL_STATUS (Field20)
- USE_PAGE (Field21)
- USE_TIME (Field22)
- SN_RESULT (Field23)
- WAP_INFO (Field24)
- CINFO (Field25)