WEE

Tables (11)

Category (Untitled3)

  • id (todoitem_id) — Primary key — NOT NULL
  • 투두 id (todo_id) — Foreign key → Todo.id — NOT NULL
  • 카테고리 (category_item) — String

Comment (Untitled9)

  • id (comment_id) — Primary key — NOT NULL
  • 사용자 id (user_id) — Foreign key → User.id — NOT NULL
  • 루틴공유방 id (share_id) — Foreign key → ShareCommunity.id — NOT NULL
  • 운동질문방 id (question_id) — Foreign key → QuestionCommunity.id — NOT NULL
  • 크루모집방 id (crew_id) — Foreign key → CrewCommunity.id — NOT NULL
  • 질문내용 (contents) — String
  • 채택여부(운동질문방만 필요!) (status) — TINYINT(1)

CrewCommunity (Untitled8)

  • id (crew_id) — BIGINT — Primary key — NOT NULL
  • 사용자 id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
  • 제목 (title) — VARCHAR
  • 내용 (contents) — VARCHAR
  • 좋아요 (like) — INT
  • 생성날짜 (create_date) — DATE
  • 조회수 (view_cnt) — INT
  • 답변개수 (comment_cnt) — INT
  • 시작예정일 (start_date) — DATE
  • 종료예정일 (end_date) — DATE
  • 위치 (location) — VARCHAR
  • 운동종류 (type) — VARCHAR
  • 모집인원 (headcount) — INT
  • 모집완료여부 (status) — VARCHAR

Image (Untitled11)

  • id (image_id) — Primary key — NOT NULL
  • id (todo_id) — Foreign key → Todo.id — NOT NULL
  • 사용자 id (user_id) — Foreign key → Todo.사용자 id — NOT NULL
  • 사진 (image) — String

Like (Untitled6)

  • id (like_id) — Primary key — NOT NULL
  • 사용자 id (user_id) — Foreign key → User.id — NOT NULL
  • 루틴공유방 id (share_id) — Foreign key → ShareCommunity.id — NOT NULL
  • 운동질문방 id (question_id) — Foreign key → QuestionCommunity.id — NOT NULL
  • 크루모집방 id (crew_id) — Foreign key → CrewCommunity.id — NOT NULL
  • 방 타입 (type) — String

QuestionCommunity (Untitled7)

  • id (question_id) — BIGINT — Primary key — NOT NULL
  • 사용자 id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
  • 제목 (title) — VARCHAR
  • 내용 (contents) — VARCHAR
  • 좋아요 (like) — INT
  • 생성날짜 (create_date) — DATE
  • 조회수 (view_cnt) — INT
  • 답변개수 (comment_cnt) — INT
  • 운동분류 (type) — VARCHAR
  • 채택여부 (status) — VARCHAR

Routine (Untitled4)

  • id (routine_id) — Primary key — NOT NULL
  • 사용자 id (user_id) — Foreign key → User.id — NOT NULL
  • 스토리사진 (image) — String

ShareCommunity (Untitled5)

  • id (share_id) — Primary key — NOT NULL
  • 사용자 id (user_id) — Foreign key → User.id — NOT NULL
  • 제목 (title) — String
  • 내용 (contents) — String
  • 좋아요 (like) — int
  • 생성날짜 (create_date) — Date
  • 조회수 (hit) — int
  • 답변개수 (comment_cnt) — int

Task (Untitled10)

  • id (task_id) — Primary key — NOT NULL
  • 투두아이템 id (todoitem_id) — Foreign key → Category.id — NOT NULL
  • 내용 (contents) — String
  • 완료여부 (is_completed) — Boolean

Todo (Untitled2)

  • id (todo_id) — Primary key — NOT NULL
  • 사용자 id (user_id) — Foreign key → User.id — NOT NULL
  • 날짜 (today) — Date
  • 일기 (diary) — String

User (Untitled)

  • id (user_id) — Primary key — NOT NULL
  • 이메일 (email) — String
  • 닉네임 (nickname) — String
  • 비밀번호 (password) — String
  • 성별 (gender) — Boolean — NOT NULL
  • 키 (height) — int — NOT NULL
  • 몸무게 (weight) — int — NOT NULL
  • 체지방 (body_fat) — int — NOT NULL
  • 목표 (goal) — String — NOT NULL
  • 관심 있는 운동 (interest) — String — NOT NULL
  • 채택 답변 레벨 (level) — int — NOT NULL