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)