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