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