PMC_DB

Tables (24)

ANALYSIS_HISTORY (AI 결과값)

  • ID (Key) — INT — Primary key — NOT NULL
  • SYSTEM_GB (Key2) — CHAR — Primary key — NOT NULL
  • TRANS_DATE (Key3) — DATETIME — Primary key — NOT NULL
  • HUMAN_PET_GB (Key6) — Primary key — NOT NULL
  • USER_ID (Key5) — INT — Foreign key → USER.ID — NOT NULL
  • PET_ID (Key7) — INT — Foreign key → PET.ID — NOT NULL
  • TYPE (Field7) — INT
  • PROC_STATUS (Field8) — CHAR
  • USE_FL (Field9) — TINYINT
  • ANA_DATE (Field10) — DATETIME
  • AGGR_IDX (Field11) — DOUBLE
  • STR_IDX (Field12) — DOUBLE
  • ANX_IDX (Field13) — DOUBLE
  • SUSP_IDX (Field) — DOUBLE
  • BAL_IDX (Field2) — DOUBLE
  • CHARM_IDX (Field3) — DOUBLE
  • ENER_IDX (Field4) — DOUBLE
  • SELF_IDX (Field5) — DOUBLE
  • SUPPR_IDX (Field6) — DOUBLE
  • NEURO_IDX (Field14) — DOUBLE
  • READ_DATE (Field15) — DATETIME

ANANLYSIS_FIXED (Untitled)

  • VALUE_GB (Key) — CHAR — Primary key — NOT NULL
  • AVERAGE_VAL (Field) — DOUBLE
  • STD_DEV_VAL (Field2) — DOUBLE
  • BIGO (Field3) — VARCHAR

ARTICLE (게시글)

  • ID (Key) — INT — Primary key — NOT NULL
  • TYPE (Field) — INT — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USER.ID
  • TITLE (Field3) — VARCHAR
  • CONTENT (Field4) — TEXT
  • IMAGE (Field5) — VARCHAR
  • CLICK_CNT (Field6) — INT
  • MARK_ID (Field7) — INT
  • EMOTION (Field8) — VARCHAR
  • ADD_TIME (Field9) — DATETIME
  • DEL_TIME (Field10) — DATETIME

ARTICLE_COMMENT (댓글)

  • ID (Key) — INT — Primary key — NOT NULL
  • USER_ID (Key3) — INT — Foreign key → USER.ID — NOT NULL
  • ARTICLE_ID (Key2) — INT — Foreign key → ARTICLE.ID — NOT NULL
  • COMMENT (Field3) — VARCHAR
  • PARENT (Field4) — INT
  • LOCKED (Field5) — TINYINT — NOT NULL
  • IMAGE (Field6) — VARCHAR — NOT NULL
  • ADD_TIME (Field7) — DATETIME

ARTICLE_IMAGE (게시글 이미지)

  • ID (Key) — INT — Primary key — NOT NULL
  • ARTICLE_ID (Key2) — VARCHAR — Foreign key → ARTICLE.ID — NOT NULL
  • IMAGE (Field2) — VARCHAR — NOT NULL
  • ADD_TIME (Field3) — DATETIME — NOT NULL

ARTICLE_LIKE (게시글 좋아요 수)

  • ID (Key) — INT — Primary key — NOT NULL
  • USER_ID (Key3) — INT — Foreign key → USER.ID — NOT NULL
  • ARTICLE_ID (Key2) — INT — Foreign key → ARTICLE.ID — NOT NULL
  • COMMENT_ID (Field3) — INT

ARTICLE_SINGO (신고)

  • ID (Key) — INT — Primary key — NOT NULL
  • ARTICLE_ID (Key2) — INT — Foreign key → ARTICLE.ID
  • TYPE (Field2) — TINYINT — NOT NULL
  • SINGO_ID (Key3) — INT — Foreign key → USER.ID
  • SINGO_TYPE (Field4) — INT
  • SINGO_CONTENT (Field5) — VARCHAR
  • SINGO_TIME (Field6) — DATETIME

DOG (견종)

  • ID (Key) — INT — Primary key — NOT NULL
  • NAME (Field) — VARCHAR — NOT NULL
  • SIZE (Field2) — VARCHAR
  • INQ_SEQ (Field3) — INT

EVENT (이벤트)

  • ID (Key) — INT — Primary key — NOT NULL
  • TYPE (Field) — INT
  • MEMO (Field2) — VARCHAR
  • TITLE (Field3) — TEXT
  • CONTENT (Field4) — TEXT
  • START_DATE (Field5) — DATETIME — NOT NULL
  • END_DATE (Field6) — DATETIME — NOT NULL
  • URL (Field7) — VARCHAR
  • POPUP_IMG (Field8) — VARCHAR
  • POPUP_TYPE (Field9) — INT
  • POPUP_LOCATION (Field10) — INT
  • EVENT_IMG (Field11) — VARCHAR
  • UPDATED_DATE (Field12) — DATETIME
  • CREATED_DATE (Field13) — DATETIME

FCM (푸시 토큰)

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USER.ID — NOT NULL
  • TOKEN (Field2) — VARCHAR
  • CREATE_DT (Field3) — DATETIME

FCM_LOG (푸시 뷰 로그)

  • ID (Key) — BIDINT — Primary key — NOT NULL
  • TYPE (Field) — VARCHAR
  • TITLE (Field2) — VARCHAR
  • MESSAGE (Field3) — VARCHAR
  • RESULT (Field4) — TEXT
  • TOPIC (Field5) — VARCHAR
  • FOREIGN_ID (Field6) — VARCHAR
  • FOREIGN_TABLE (Field7) — VARCHAR
  • OTHER_DATA (Field8) — TEXT
  • CREATE_DT (Field9) — DATETIME

FCM_VIEW_LOG (푸시 로그)

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • FCM_LOG_ID (Key2) — BIDINT — Foreign key → FCM_LOG.ID
  • CREATE_DT (Field2) — DATETIME

GAP_CONTENT (비교리포트 콘텐츠)

  • GAP_GB (Key2) — CHAR — Primary key — NOT NULL
  • SITUATION_GB (Key3) — CHAR — Primary key — NOT NULL
  • VALUE_GB (Key) — CHAR — Foreign key → ANANLYSIS_FIXED.VALUE_GB — NOT NULL
  • LEVEL_NUMBER (Field8) — CHAR — NOT NULL
  • GAP_FROM (Field) — DOUBLE
  • GAP_TO (Field2) — DOUBLE
  • LEVEL_FROM (Field3) — DOUBLE
  • LEVEL_TO (Field4) — DOUBLE
  • ANA_RESULT (Field5) — VARCHAR
  • SITUATION_EXP (Field6) — VARCHAR
  • RESEARCH_TIP (Field7) — VARCHAR

MARK (PMC 값)

  • ID (Key) — INT — Primary key — NOT NULL
  • PET_ID (Key3) — INT — Foreign key → PET.ID
  • USER_ID (Key2) — INT — Foreign key → USER.ID
  • CREATE_DATE (Field3) — DATETIME
  • TYPE (Field4) — INT
  • TITLE (Field5) — VARCHAR
  • TITLE_MEMO (Field6) — VARCHAR
  • ANA_PHOTO (Field7) — VARCHAR
  • MARK1 (Field8) — DOUBLE
  • MARK2 (Field9) — DOUBLE
  • MARK3 (Field10) — DOUBLE
  • MARK4 (Field11) — DOUBLE
  • MARK5 (Field13) — DOUBLE
  • MARK6 (Field14) — DOUBLE
  • MARK7 (Field12) — DOUBLE
  • MARK8 (Field15) — DOUBLE

PET (펫)

  • ID (Key) — INT — Primary key — NOT NULL
  • NAME (Field) — VARCHAR
  • PHOTO (Field2) — VARCHAR
  • TYPE (Field3) — INT
  • DOG_ID (Key3) — INT — Foreign key → DOG.ID — NOT NULL
  • GENDER (Field5) — INT
  • USER_ID (Key2) — INT — Foreign key → USER.ID — NOT NULL
  • REGISTRATION_NUM (Field7) — VARCHAR
  • EXTRA (Field8) — VARCHAR
  • MEMO (Field9) — TEXT
  • ELSE_DOG (Field10) — VARCHAR
  • BIRTHDAY (Field11) — DATETIME
  • BIRTHDAY2 (Field12) — DATETIME
  • EXTRA_TXT (Field13) — VARHCAR
  • CREATE_DT (Field14) — DATETIME
  • ACTIVE_FL (Field15) — TINYINT — NOT NULL

POPUP_SHOW (Untitled2)

  • ID (Key) — INT — Primary key — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USER.ID — NOT NULL
  • EVENT_ID (Key3) — INT — Foreign key → EVENT.ID — NOT NULL
  • HIDE_DATE (Field3) — DATETIME — NOT NULL
  • SHOW_DATE (Field4) — DATETIME — NOT NULL

PROMOTION_LOGS (프로모션 로그)

  • ID (Key) — INT — Primary key — NOT NULL
  • PROMOTION_ID (Key3) — INT — Foreign key → PROMOTION_SETTING.ID
  • CREATED_DATE (Field2) — DATETIME
  • USER_ID (Key2) — INT — Foreign key → USER.ID

PROMOTION_RANDOM (프로모션 난수)

  • ID (Key) — INT — Primary key — NOT NULL
  • PROMOTION_ID (Key2) — INT — Foreign key → PROMOTION_SETTING.ID
  • DEFAULT_CODE (Field2) — VARCHAR
  • USE_CODE (Field3) — VARCHAR
  • USER_ID (Field4) — INT
  • CREATE_DATE (Field5) — DATETIME

PROMOTION_SETTING (프로모션)

  • ID (Key) — INT — Primary key — NOT NULL
  • TITLE (Field) — VARCHAR
  • PEOPLE (Field2) — INT
  • CAMERA_COUNT (Field3) — INT
  • MEMO (Field4) — TEXT
  • CODE (Field5) — VARCHAR
  • START_DATE (Field6) — DATETIME
  • END_DATE (Field7) — DATETIME
  • CREATE_DATE (Field8) — DATETIME
  • PET_COUNT (Field9) — INT
  • RANDOM (Field10) — INT
  • PERIOD (Field11) — INT
  • TYPE (Field12) — INT
  • DISCOUNT (Field13) — INT

QA (문의)

  • ID (Key) — INT — Primary key — NOT NULL
  • TITLE (Field) — TEXT
  • CONTENT (Field2) — TEXT — NOT NULL
  • DATE (Field3) — DATETIME — NOT NULL
  • USER_ID (Key2) — INT — Foreign key → USER.ID
  • EMAIL (Field5) — VARCHAR
  • PHONE (Field6) — VARCHAR
  • STATE (Field7) — INT
  • PUSH_CONTENT (Field8) — VARCHAR
  • PHONE_TYPE (Field9) — VARCHAR — NOT NULL

RANGE_CONTENT (상세진단 콘텐츠)

  • REPORT_GB (Key) — CHAR — Primary key — NOT NULL
  • LEVEL_NUMBER (Key3) — CHAR — Primary key — NOT NULL
  • VALUE_GB (Key2) — CHAR — Foreign key → ANANLYSIS_FIXED.VALUE_GB — NOT NULL
  • LEVEL_FROM (Field) — DOUBLE
  • LEVEL_TO (Field2) — DOUBLE
  • ANA_ONE_COM1 (Field3) — VARCHAR
  • ANA_ONE_COM2 (Field4) — VARCHAR
  • ANA_ONE_COM3 (Field5) — VARCHAR
  • ANA_RESULT (Field6) — VARCHAR
  • RESEARCH_TIP (Field7) — VARCHAR

RANGE_NAME (레벨)

  • VALUE_GB (Key4) — CHAR — Foreign key → ANANLYSIS_FIXED.VALUE_GB — NOT NULL
  • LEVEL_NUMBER (Field5) — CHAR — NOT NULL
  • LEVEL_FROM (Field) — DOUBLE
  • LEVEL_TO (Field2) — DOUBLE
  • LEVEL_NAME (Field3) — VARCHAR
  • UPDOWN_RANK (Field4) — CHAR

RNAK_DIST (데이터연구소용 평균값 DB)

  • AGE_GB (Key2) — CHAR — Primary key — NOT NULL
  • LEVEL_NUMBER (Key4) — CHAR — Primary key — NOT NULL
  • ID (Key5) — INT — Foreign key → DOG.ID — NOT NULL
  • AGE_FROM (Field) — INT
  • AGE_TO (Field2) — INT
  • LEVEL_FROM (Field3) — DOUBLE
  • LEVEL_TO (Field4) — DOUBLE
  • LEVEL_DIST (Field5) — DOUBLE
  • VALUE_GB (Key3) — CHAR — Foreign key → ANANLYSIS_FIXED.VALUE_GB — NOT NULL

USER (사용자)

  • ID (Key) — INT — Primary key — NOT NULL
  • SOCIAL_TYPE (Field) — INT — NOT NULL
  • EMAIL (Field3) — VARCHAR
  • PASSWORD (Field2) — VARCHAR
  • PHONE (Field4) — VARCHAR
  • NAME (Field5) — VARCHAR
  • NICK (Field6) — VARCHAR
  • FIRST_LOGIN (Field7) — DATETIME — NOT NULL
  • LAST_LOGIN (Field8) — DATETIME — NOT NULL
  • PROFILE_IMG (Field9) — VARCHAR
  • UID (파이어베이스유저아이디) — VARCHAR
  • GENDER (Field11) — INT
  • LOCATION (Field12) — VARCHAR
  • BIRTHDAY (Field13) — DATETIME
  • OCCUPATION (Field10) — VARCHAR
  • RAISE (Field14) — VARCHAR
  • TOGETHER (Field15) — VARCHAR
  • RECOMMAND_EMAIL (Field16) — VARCHAR
  • PET_CNT (Field17) — INT
  • PET_TYPE (Field18) — TINYINT
  • PROMOTION_TYPE (Key2) — INT — Foreign key → PROMOTION_SETTING.ID
  • OS_TYPE (Field20) — INT
  • RECV_SMS (Field21) — TINYINT — NOT NULL
  • RECV_PUSH (Field22) — TINYINT — NOT NULL
  • DEVICE_INFO (Field23) — VARCHAR
  • APP_VERSION (Field24) — VARCHAR
  • PREMIUM_DT (Field25) — DATETIME