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 (키워드)