togetherhomt

Tables (13)

Comment (Untitled4)

  • comment_id (댓글id) — PK — Primary key — NOT NULL
  • feed_id (게시물id) — PK — Foreign key → Feed.user_id — NOT NULL
  • user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
  • content (내용) — varchar(100)
  • created_at (생성일) — date

Copy Of User (CopyOfUntitled)

  • user_id (유저id) — PK — Primary key — NOT NULL
  • email (이메일) — varchar(50)
  • username (유저네임) — varchar(15)
  • password (패스워드) — varchar(50)

Feed (Untitled2)

  • feed_id (게시물id) — PK — Primary key — NOT NULL
  • user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
  • title (제목) — varchar(50)
  • contents (내용) — text
  • created_at (생성일) — date
  • media_url (미디어주소) — text
  • like_cnt (좋아요수) — long

Like (Untitled5)

  • article_id (게시물id) — PK — Foreign key → Feed.feed_id — NOT NULL
  • user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL

Notification (Untitled11)

  • notification_id (알림id) — PK — Primary key — NOT NULL
  • from (from유저) — PK — Foreign key → User.user_id — NOT NULL
  • to (to유저) — PK — Foreign key → Copy Of User.user_id — NOT NULL
  • type (타입) — enum
  • time (발신시간) — datetime

User (Untitled)

  • user_id (유저id) — PK — Primary key — NOT NULL
  • email (이메일) — varchar(50)
  • username (유저네임) — varchar(15)
  • password (패스워드) — varchar(50)
  • introduce (자기소개) — varchar(100)
  • profile_url (프로필사진) — text

attendance (Untitled10)

  • attendance_id (출석id) — PK — Primary key — NOT NULL
  • user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
  • performed_date (날짜) — Datetime
  • done (출석여부) — boolean

belong (Untitled9)

  • group_id (그룹id) — PK — Foreign key → group.group_id — NOT NULL
  • user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL

exercise (Untitled6)

  • exercise_id (운동id) — PK — Primary key — NOT NULL
  • type (타입) — enum
  • part (부위) — varchar(50)
  • name (이름) — varchar(50)
  • time (시간) — long
  • count (횟수) — long
  • video_url (비디오URL) — text

follow (Untitled3)

  • from — PK — Foreign key → User.user_id — NOT NULL
  • to — PK — Foreign key → Copy Of User.user_id — NOT NULL

group (Untitled8)

  • group_id (그룹id) — PK — Primary key — NOT NULL
  • main_category (대분류) — varchar(50)
  • middle_category (중분류) — varchar(50)
  • sub_category (소분류) — varchar(50)
  • name (이름) — varchar(50)

record (Untitled7)

  • record_id (기록id) — PK — Primary key — NOT NULL
  • user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
  • exercise_id (운동id) — PK — Foreign key → exercise.exercise_id — NOT NULL
  • performed_date (운동날짜시간) — DateTime

today_exercise (CopyOfUntitled7)

  • select_id (선택id) — PK — Primary key — NOT NULL
  • user_id (유저id) — PK — Foreign key → User.user_id — NOT NULL
  • exercise_id (운동id) — PK — Foreign key → exercise.exercise_id — NOT NULL
  • done (수행여부) — boolean