CAMP

Tables (5)

TMS_CAMP_CHN_INFO

  • POST_ID (postid) — varchar — Primary key — NOT NULL
  • CONTENT_TYPE (Key) — varchar — Primary key — NOT NULL
  • CHANNEL_TYPE (Key2) — char — Primary key — NOT NULL
  • MSG_ID (msgid) — varchar — Foreign key → TMS_CAMP_MSG_INFO.MSG_ID — NOT NULL
  • MSG_TYPE (Key4) — varchar — Foreign key → TMS_CAMP_MSG_INFO.MSG_TYPE — NOT NULL
  • APP_GRP_ID (Key5) — int — Foreign key → TMS_CAMP_MSG_INFO.APP_GRP_ID — NOT NULL
  • CHANNEL_TYPE (Key6) — char — Foreign key → TMS_CAMP_MSG_INFO.CHANNEL_TYPE — NOT NULL
  • DIVIDE_SEND_USE_YN (Key7) — varchar — Foreign key → TMS_CAMP_MSG_INFO.DIVIDE_SEND_USE_YN — NOT NULL

TMS_CAMP_INFO

  • CAMP_ID (campid) — varchar — Primary key — NOT NULL
  • SITE_ID (Key) — int — Primary key — NOT NULL
  • REG_ID (Key2) — varchar — Primary key — NOT NULL
  • CAMP_TYPE (Key3) — char — Primary key — NOT NULL

TMS_CAMP_INFO_ATTACH (Untitled)

  • CONTENT_NAME (Key) — varchar — Primary key — NOT NULL
  • POST_ID (postid) — varchar — Foreign key → TMS_CAMP_CHN_INFO.POST_ID — NOT NULL
  • CONTENT_TYPE (Key2) — varchar — Foreign key → TMS_CAMP_CHN_INFO.CONTENT_TYPE — NOT NULL
  • CHANNEL_TYPE (Key22) — char — Foreign key → TMS_CAMP_CHN_INFO.CHANNEL_TYPE — NOT NULL

TMS_CAMP_MSG_INFO

  • MSG_ID (msgid) — varchar — Primary key — NOT NULL
  • MSG_TYPE (Key4) — varchar — Primary key — NOT NULL
  • APP_GRP_ID (Key5) — int — Primary key — NOT NULL
  • CHANNEL_TYPE (Key6) — char — Primary key — NOT NULL
  • DIVIDE_SEND_USE_YN (Key7) — varchar — Primary key — NOT NULL
  • CAMP_ID (campid) — varchar — Foreign key → TMS_CAMP_INFO.CAMP_ID — NOT NULL
  • SITE_ID (Key) — int — Foreign key → TMS_CAMP_INFO.SITE_ID — NOT NULL
  • REG_ID (Key2) — varchar — Foreign key → TMS_CAMP_INFO.REG_ID — NOT NULL
  • CAMP_TYPE (Key3) — char — Foreign key → TMS_CAMP_INFO.CAMP_TYPE — NOT NULL

TMS_CAMP_SEND_LIST_XX (Untitled2)

  • MEMBER_ID (Key) — varchar — Primary key — NOT NULL
  • POST_ID (postid) — varchar — Foreign key → TMS_CAMP_CHN_INFO.POST_ID — NOT NULL
  • CHANNEL_TYPE (Key2) — char — Foreign key → TMS_CAMP_CHN_INFO.CHANNEL_TYPE — NOT NULL