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