newsColling
Tables (4)
member (회원)
- id (아이디) — Primary key — NOT NULL
- name (이름)
- expDate (유효기간)
- hpNumber (핸드폰번호)
- IP (아이피)
newsList (뉴스데이타)
- Key — Primary key — NOT NULL
- keyword (키워드) — Foreign key → totalKeyword.keyword — NOT NULL
- title (제목)
- news_url (뉴스url)
- image_url (이미지url)
- writer (언론사)
- createDt (등록일자)
totalKeyword (토탈키워드)
- keyword (키워드) — Primary key — NOT NULL
- cnt (키워드 등록유저수)
- date (등록날짜)
userKeyword (유저등록키워드)
- ID (아이디2) — Foreign key → member.id — NOT NULL
- keyword (키워드)