hperd

Tables (8)

News (뉴스)

  • news_id — int — Primary key — NOT NULL
  • titlet (itle) — String
  • content — String
  • imgurl (ingurl) — String
  • likeCount — int
  • location (Field) — String

art (예술)

  • pk (Pk) — Primary key — NOT NULL
  • identifyId (Field) — Long
  • startDate — String
  • endDate — String
  • area — String
  • place — String
  • imageUrl — String
  • likeCount — String

interest (관심사(태그))

  • intereest_Id (interest_id) — pk — Primary key — NOT NULL
  • interest_type — string

member (CopyOf사용자)

  • member_id — pk — Primary key — NOT NULL
  • nickname
  • location
  • email

member_Interest (멤버_관심사)

  • pk — Primary key — NOT NULL
  • member_id — pk — Foreign key → member.member_id — NOT NULL
  • intereest_Id (interest_id) — pk — Foreign key → interest.intereest_Id — NOT NULL

member_art_like (Untitled)

  • member_id — pk — Foreign key → member.member_id — NOT NULL
  • pk (Pk) — Foreign key → art.pk — NOT NULL

member_post_like (좋아요)

  • pk — Primary key — NOT NULL
  • member_id — pk — Foreign key → member.member_id — NOT NULL
  • news_id — int — Foreign key → News.news_id — NOT NULL

news_interest (뉴스_관심사)

  • pk — Primary key — NOT NULL
  • news_id — int — Foreign key → News.news_id — NOT NULL
  • intereest_Id (interest_id) — pk — Foreign key → interest.intereest_Id — NOT NULL