Study_Forest

Tables (4)

Habit_Table (Untitled4)

  • ID (레코드수) — int — Primary key
  • habit_name (습관명) — varcahr
  • habit_description (습관 상세) — text

Study_Details_Table (Untitled)

  • user_habit_fk_uuid (외래키) — varcahr — Primary key
  • uuid (유일키) — varchar — Primary key
  • ID (Id) — int
  • nickname (Study_nickname) — varcahr
  • study_name (스터디 명칭) — varcahr
  • study_introduction (스터디 소개) — text
  • bakcground_img (배경이미지) — varcahr
  • createdAt (생성일자) — datetime
  • updatedAt (수정일자) — datetime
  • passwd (비밀번호) — varcahr

User_Habit_Table (Untitled2)

  • unique_id (유일키2) — varcahr — Foreign key → User_Table.unique_id
  • ID (레코드 수) — int — Foreign key → User_Table.ID
  • ID (레코드수2) — int — Foreign key → Habit_Table.ID
  • ID (레코드수) — int
  • username(email) (사용자ID) — varcahr
  • habit_name (습관명) — varcahr
  • habit_day_cnt (습관 적용 일수) — int
  • habit_day (습관 적용 요일) — varcahr
  • shared (공유여부) — tinyint
  • createdAt (생성일자) — datetime
  • updatedAt (숮어일자) — datetime
  • passwd (비밀번호) — varcahr

User_Table (Untitled3)

  • unique_id (유일키) — varcahr — Primary key
  • ID (레코드 수) — int — Primary key
  • username(email) (사용자아이디) — varcahr
  • 이름 — varcahr
  • 성 — varcahr
  • createdAt (생성일자) — datetime
  • passwd (비밀번호) — varcahr