Push Service

Tables (5)

CLIENT_PUSH_ETC_KEY (Untitled4)

  • NO (Key2) — Foreign key → CLIENT_PUSH_INFO.NO — NOT NULL
  • PUSH_ETC_CODE (Key) — Foreign key → PUSH_CODE.CODE_TYPE — NOT NULL
  • ETC_VALUE (Field2)
  • REG_DATE (Field3)

CLIENT_PUSH_INFO (Untitled)

  • NO (Key) — Primary key — NOT NULL
  • END_POINT (Field)
  • PUBLIC_KEY (Field2)
  • PRIVATE_KEY (Field3)
  • USE_YN (Field4)
  • REG_DATE (Field5)

PUSH_ALARM_HISTORY (Untitled2)

  • NO (Key2) — Foreign key → CLIENT_PUSH_INFO.NO — NOT NULL
  • CAMP_CODE (Key) — Foreign key → PUSH_CAMP_INFO.CAMP_CODE — NOT NULL
  • REG_DATE (Field5)

PUSH_CAMP_INFO (Untitled3)

  • CAMP_CODE (Key) — Primary key — NOT NULL
  • CAMP_NAME (Field)
  • CAMP_TITLE (Field10)
  • CAMP_IMAGE (Field2)
  • CAMP_W_URL (Field3)
  • CAMP_M_URL (Field9)
  • CAMP_USE_YN (Field8)
  • CAMP_START_DATE (Field11)
  • CAMP_END_DATE (Field12)
  • REG_USER_ID (Field4)
  • REG_DATE (Field5)
  • ALT_USER_ID (Field6)
  • ALT_DATE (Field7)

PUSH_CODE (Untitled5)

  • CODE_TYPE (Key) — Primary key — NOT NULL
  • CODE_ID (Key2) — Primary key — NOT NULL
  • CODE_VALUE (Field)