챌린지 플래너 데이터 모델링

테이블 (16)

Badge (Untitled3)

  • id (Key) — Long — 기본 키 — NOT NULL
  • badge_name — string
  • badge_desc — string
  • badge_Img — string
  • badege_point — int

Badge_list (Untitled10)

  • id — Long — 기본 키 — NOT NULL
  • user_id — Long — 외래 키 → User.id
  • badge_name — string
  • badge_desc — String
  • set_date — date
  • badge_img — String
  • badge_point — int

Challenge (Untitled4)

  • id (Key) — Long — 기본 키 — NOT NULL
  • title — string
  • start_day — date
  • end_day — date
  • week_count — int
  • total_count (totoal_count) — int
  • doing — int

Challenge_list (Untitled6)

  • id (Key) — Long — 기본 키 — NOT NULL
  • challenge_id — Long — 외래 키 → Challenge.id — NOT NULL
  • count — int
  • state — int
  • user_name — String
  • user_phone — String
  • user_email — String
  • user_img — String

Comment (Untitled7)

  • id — Long — 기본 키 — NOT NULL
  • created_date — date
  • comment — String
  • edit_date — date

Comment_list (Untitled12)

  • id — Long — 기본 키 — NOT NULL
  • post_id — Long — 외래 키 → Post.id — NOT NULL
  • comment_id — Long — 외래 키 → Comment.id — NOT NULL

Goal (Untitled2)

  • id — Long — 기본 키
  • goal_title — String
  • start_day — date
  • end_day — date
  • week_count — int
  • total_count — int
  • count — int
  • doing — int
  • state — int

Goal_list (Untitled9)

  • id — Long — 기본 키 — NOT NULL
  • user_id (uesr_id) — Long — 외래 키 → User.id
  • goal_title — string
  • start_day — date
  • end_day — date
  • week_count — int
  • coung (count) — int
  • doing — int
  • states (state) — int
  • total_count — int

Notification (Untitled8)

  • id — Long — 기본 키 — NOT NULL
  • title — string
  • content — string
  • create_date — date

Notification_img (Untitled16)

  • id — 기본 키 — NOT NULL
  • notification_id — Long — 외래 키 → Notification.id — NOT NULL
  • img_url

Post (Untitled5)

  • id — Long — 기본 키 — NOT NULL
  • category — String
  • title — String
  • created_date — date
  • edit_date — date
  • content — String

Post_list (Untitled11)

  • id — Long — 기본 키 — NOT NULL
  • user_id — Long — 외래 키 → User.id
  • title — string
  • category — string
  • create_date — date
  • edit_date — date

User (Untitled)

  • id — Long — 기본 키
  • name (asd) — string
  • password (Field) — string
  • email (Field2) — string
  • phoneNum (Field3) — string
  • img (Field4) — string
  • grade (Field5) — int
  • point (Field6) — int

User_comment (Untitled13)

  • id — Long — 기본 키 — NOT NULL
  • user_id — Long — 외래 키 → User.id
  • comment — String
  • created_date — date
  • edit_date — date

noti_list (Untitled14)

  • id — Long — 기본 키 — NOT NULL
  • noti_id — Long — 외래 키 → Notification.id — NOT NULL
  • user_name — string

post_img (Untitled15)

  • id — Long — 기본 키 — NOT NULL
  • post_id — Long — 외래 키 → Post.id — NOT NULL
  • img_url — string