youreyes

Tables (5)

news (뉴스)

  • news_id (Key) — Long — Primary key — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2)
  • image (Field3)
  • Field4
  • url (Field5)
  • Field6
  • Field7
  • Field8
  • cluster_news (Field9)
  • cluster_id (Key2) — Foreign key → newsCluster.cluster_id — NOT NULL

newsCluster (뉴스 클러스터)

  • cluster_id (Key) — Primary key — NOT NULL
  • title (Field2)
  • Field3

product (상품)

  • product_id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)
  • image (Field3)
  • info (Field4)
  • url (Field5)
  • category (Field6)
  • (Field7)

review (상품 리뷰)

  • review_id (Key) — Primary key — NOT NULL
  • Field
  • product_id (Key2) — Foreign key → product.product_id — NOT NULL

user (회원)