My Life

Tables (11)

Action Info (행동 정의)

  • ACTION_NO — INT — Primary key — NOT NULL
  • ACTION_NAME (피드 클릭, 피드 삭제) — VARCHAR

CATEGORY (카테고리)

  • CATEGORY_NO — INT — Primary key — NOT NULL
  • CATEGORY_NAME — VARCHAR
  • PRAENT_CATEGORY_NO (0일 경우 최상위) — INT — Foreign key → CATEGORY.CATEGORY_NO — NOT NULL

FEED_TEMPLATE (피드 템플릿)

  • TEMPLATE_NO — INT — Primary key — NOT NULL
  • CONFIRM_MEMBER — VARCHAR
  • CONFIRM_DATE — datetime
  • CONFIRM_DETAIL (에 : 부적절한 컨텐츠) — VARCHAR
  • CONFIRM_STATUS (거절, 승인, 보류) — INT
  • CONTENT — VARCHAR

Feed App (피드와 연결된 앱)

  • FEED_APP_NO — INT — Primary key — NOT NULL
  • FEED_APP_NAME (예 : 뉴스, 에이북) — VARCHAR
  • FEED_APP_PASSWORD — VARCHAR

Main Feed (메인 피드)

  • FEED_NO — INT — Primary key — NOT NULL
  • USER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
  • CATEGORY_NO — INT — Foreign key → CATEGORY.CATEGORY_NO — NOT NULL
  • FEED_APP_NO — INT — Foreign key → Feed App.FEED_APP_NO — NOT NULL
  • TEMPLATE_NO — INT — Foreign key → FEED_TEMPLATE.TEMPLATE_NO — NOT NULL
  • CONTENT — VARCHAR
  • FEED_TYPE (부, 지식, 재미) — INT
  • INS_DATE — datetime
  • UPD_DATE — datetime
  • LINK — VARCHAR
  • FEED_RANK — int
  • PUSH_TITLE (예 : 오늘의 점심은?) — VARCHAR
  • PUSH_TEXT (예 : 당신을 위한 닭볶음탕) — VARCHAR

Main Feed History (메인 피드 히스토리)

  • FEED_NO — INT — Primary key — NOT NULL
  • ... — ...
  • DEL_DATE — datetime

NEWS (뉴스)

  • NEW_NO — INT — Primary key — NOT NULL
  • PUBL:ISHER_NO — INT — Foreign key → NEWS_PUBLISHER.PUBLISHER_NO — NOT NULL
  • CONTENTS — VARCHAR
  • NEWS_DATE — datetime
  • NEWS_LINK — VARCHAR
  • TITLE — VARCHAR

NEWS_PUBLISHER (뉴스 퍼블리셔)

  • PUBLISHER_NO — INT — Primary key — NOT NULL
  • Field

USER (유저)

  • USER_NO — INT — Primary key — NOT NULL
  • LAST_FEED_UPD_DATE — datetime

USER_PREFERENCE (유저 선호도)

  • PREFERENCE_NO — INT — Primary key — NOT NULL
  • USER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
  • CATEGORY_NO — INT — Foreign key → CATEGORY.CATEGORY_NO — NOT NULL
  • RANK — INT
  • VALUE — FLOAT
  • TYPE — INT

User Action History (유저 행동 히스토리)

  • HISTORY_NO — INT — Primary key — NOT NULL
  • USER_NO — INT — Foreign key → USER.USER_NO — NOT NULL
  • FEED_NO — INT — Foreign key → Main Feed.FEED_NO — NOT NULL
  • ACTION_NO — INT — Foreign key → Action Info.ACTION_NO — NOT NULL
  • FEED_APP_NO — INT — Foreign key → Main Feed.FEED_APP_NO — NOT NULL
  • TEMPLATE_NO — INT — Foreign key → Main Feed.TEMPLATE_NO — NOT NULL
  • DEL_YN — INT
  • ACTION_VALUE — VARCHAR