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