FitOn ERD

Tables (46)

cart

  • cart_id — INT — Primary key — NOT NULL — 장바구니 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • created_at — TIMESTAMP — NOT NULL — 생성일
  • updated_at — TIMESTAMP — 수정일

cart_items

  • cart_item_id — INT — Primary key — NOT NULL — 장바구니 아이템 ID
  • cart_id — INT — Foreign key → cart.cart_id — NOT NULL — 장바구니 ID
  • product_id — INT — Foreign key → products.product_id — NOT NULL — 상품 ID
  • quantity — INT — NOT NULL — 수량
  • created_at — TIMESTAMP — NOT NULL — 생성일
  • updated_at — TIMESTAMP — 수정일

community

  • community_id — INT — Primary key — NOT NULL — 커뮤니티 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • category_id — INT — Foreign key → community_categories.category_id — NOT NULL — 카테고리 ID
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — LONGTEXT — NOT NULL — 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • view_count — INT — NOT NULL — 조회수
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

community_categories

  • category_id — INT — Primary key — NOT NULL — 카테고리 ID
  • category_name — VARCHAR(100) — NOT NULL — 카테고리 이름

community_comments

  • comment_id — INT — Primary key — NOT NULL — 댓글 ID
  • community_id — INT — Foreign key → community.community_id — NOT NULL — 커뮤니티 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • content — TEXT — NOT NULL — 내용
  • parent_comment_id — INT — Foreign key → community_comments.comment_id — 부모 댓글 ID
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

community_likes

  • community_id — INT — Foreign key → community.community_id — NOT NULL — 커뮤니티 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • created_at — TIMESTAMP — NOT NULL — 생성일

events

  • event_id — INT — Primary key — NOT NULL — 이벤트 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — LONGTEXT — NOT NULL — 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • view_count — INT — NOT NULL — 조회수
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

faqs

  • faq_id — INT — Primary key — NOT NULL — FAQ ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • question — VARCHAR(255) — NOT NULL — 질문
  • answer — LONGTEXT — NOT NULL — 답변
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

info

  • info_id — INT — Primary key — NOT NULL — 정보 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • category_id — INT — Foreign key → info_categories.category_id — NOT NULL — 카테고리 ID
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — LONGTEXT — NOT NULL — 내용
  • image_url — VARCHAR(255) — NOT NULL — 이미지 URL
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • view_count — INT — NOT NULL — 조회수
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

info_categories

  • category_id — INT — Primary key — NOT NULL — 카테고리 ID
  • category_name — VARCHAR(100) — NOT NULL — 카테고리 이름

info_comments

  • comment_id — INT — Primary key — NOT NULL — 댓글 ID
  • info_id — INT — Foreign key → info.info_id — NOT NULL — 정보 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • content — TEXT — NOT NULL — 내용
  • parent_comment_id — INT — Foreign key → info_comments.comment_id — 부모 댓글 ID
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

info_likes

  • info_id — INT — Foreign key → info.info_id — NOT NULL — 정보 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • created_at — TIMESTAMP — NOT NULL — 생성일

inquiries

  • inquiry_id — INT — Primary key — NOT NULL — 문의 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • inquiry_type_id — INT — Foreign key → inquiry_types.inquiry_type_id — NOT NULL — 문의 유형 ID
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — LONGTEXT — NOT NULL — 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부
  • status_id — INT — Foreign key → statuses.status_id — NOT NULL — 상태 ID

inquiry_answers

  • answer_id — INT — Primary key — NOT NULL — 답변 ID
  • inquiry_id — INT — Foreign key → inquiries.inquiry_id — NOT NULL — 문의 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • content — LONGTEXT — NOT NULL — 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

inquiry_types

  • inquiry_type_id — INT — Primary key — NOT NULL — 문의 유형 ID
  • type_name — VARCHAR(100) — NOT NULL — 유형 이름

notices

  • notice_id — INT — Primary key — NOT NULL — 공지사항 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — LONGTEXT — NOT NULL — 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • view_count — INT — NOT NULL — 조회수
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

order_cancellations

  • cancellation_id — INT — Primary key — NOT NULL — 취소 ID
  • order_id — INT — Foreign key → orders.order_id — NOT NULL — 주문 ID
  • order_item_id — INT — Foreign key → order_items.order_item_id — NOT NULL — 주문 항목 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • request_date — TIMESTAMP — NOT NULL — 요청일
  • processed_date — TIMESTAMP — 처리일
  • status_id — INT — Foreign key → statuses.status_id — NOT NULL — 상태 ID
  • reason — TEXT — NOT NULL — 이유

order_exchanges

  • exchange_id — INT — Primary key — NOT NULL — 교환 ID
  • order_id — INT — Foreign key → orders.order_id — NOT NULL — 주문 ID
  • order_item_id — INT — Foreign key → order_items.order_item_id — NOT NULL — 주문 항목 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • request_date — TIMESTAMP — NOT NULL — 요청일
  • processed_date — TIMESTAMP — 처리일
  • status_id — INT — Foreign key → statuses.status_id — NOT NULL — 상태 ID
  • reason — TEXT — NOT NULL — 이유

order_items

  • order_item_id — INT — Primary key — NOT NULL — 주문 항목 ID
  • order_id — INT — Foreign key → orders.order_id — NOT NULL — 주문 ID
  • product_id — INT — Foreign key → products.product_id — NOT NULL — 상품 ID
  • quantity — INT — NOT NULL — 수량
  • price — DECIMAL(10, 2) — NOT NULL — 가격
  • discount_rate — DECIMAL(5, 2) — 할인율

order_returns

  • return_id — INT — Primary key — NOT NULL — 반품 ID
  • order_id — INT — Foreign key → orders.order_id — NOT NULL — 주문 ID
  • order_item_id — INT — Foreign key → order_items.order_item_id — NOT NULL — 주문 항목 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • request_date — TIMESTAMP — NOT NULL — 요청일
  • processed_date — TIMESTAMP — 처리일
  • status_id — INT — Foreign key → statuses.status_id — NOT NULL — 상태 ID
  • reason — TEXT — NOT NULL — 이유

orders

  • order_id — INT — Primary key — NOT NULL — 주문 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • order_date — TIMESTAMP — NOT NULL — 주문일
  • status_id — INT — Foreign key → statuses.status_id — NOT NULL — 상태 ID
  • total — DECIMAL(10, 2) — NOT NULL — 총액
  • shipping_fee — DECIMAL(10, 2) — NOT NULL — 배송비

product_categories

  • category_id — INT — Primary key — NOT NULL — 카테고리 ID
  • name — VARCHAR(100) — NOT NULL — 카테고리 이름

product_images

  • image_id — INT — Primary key — NOT NULL — 이미지 ID
  • product_id — INT — Foreign key → products.product_id — NOT NULL — 상품 ID
  • image_url — VARCHAR(255) — NOT NULL — 이미지 URL
  • is_main_image — BOOLEAN — NOT NULL — 메인 이미지 여부

product_inquiries

  • inquiry_id — INT — Primary key — NOT NULL — 문의 ID
  • product_id — INT — Foreign key → products.product_id — NOT NULL — 상품 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — LONGTEXT — NOT NULL — 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부
  • status_id — INT — Foreign key → statuses.status_id — NOT NULL — 상태 ID
  • inquiry_type_id — INT — Foreign key → product_inquiry_types.inquiry_type_id — NOT NULL — 문의 유형 ID

product_inquiry_answers

  • answer_id — INT — Primary key — NOT NULL — 답변 ID
  • inquiry_id — INT — Foreign key → product_inquiries.inquiry_id — NOT NULL — 문의 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • content — LONGTEXT — NOT NULL — 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

product_inquiry_types

  • inquiry_type_id — INT — Primary key — NOT NULL — 문의 유형 ID
  • type_name — VARCHAR(100) — NOT NULL — 유형 이름

product_reviews

  • review_id — INT — Primary key — NOT NULL — 리뷰 ID
  • product_id — INT — Foreign key → products.product_id — NOT NULL — 상품 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • rating — INT — NOT NULL — 평점
  • review_text — TEXT — NOT NULL — 리뷰 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

products

  • product_id — INT — Primary key — NOT NULL — 상품 ID
  • name — VARCHAR(255) — NOT NULL — 상품 이름
  • description — TEXT — NOT NULL — 상품 설명
  • price — DECIMAL(10, 2) — NOT NULL — 가격
  • stock — INT — NOT NULL — 재고
  • category_id — INT — Foreign key → product_categories.category_id — NOT NULL — 카테고리 ID
  • content — LONGTEXT — NOT NULL — 내용
  • discount_rate — DECIMAL(5, 2) — 할인율
  • created_at — TIMESTAMP — NOT NULL — 생성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

review_images

  • image_id — INT — Primary key — NOT NULL — 이미지 ID
  • review_id — INT — Foreign key → product_reviews.review_id — NOT NULL — 리뷰 ID
  • image_url — VARCHAR(255) — NOT NULL — 이미지 URL

roles

  • role_id — INT — Primary key — NOT NULL — 권한 ID
  • role_name — VARCHAR(50) — NOT NULL — 권한 이름

routine_comments

  • comment_id — INT — Primary key — NOT NULL — 댓글 ID
  • routine_id — INT — Foreign key → routines.routine_id — NOT NULL — 루틴 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • content — TEXT — NOT NULL — 내용
  • parent_comment_id — INT — Foreign key → routine_comments.comment_id — 부모 댓글 ID
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부

routine_completions

  • completion_id — INT — Primary key — NOT NULL — 완료 ID
  • routine_id — INT — Foreign key → routines.routine_id — NOT NULL — 루틴 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • completion_date — DATE — NOT NULL — 완료일

routine_goals

  • goal_id — INT — Primary key — NOT NULL — 목적 ID
  • goal_name — VARCHAR(100) — NOT NULL — 목적 이름

routine_items

  • routine_item_id — INT — Primary key — NOT NULL — 루틴 아이템 ID
  • routine_id — INT — Foreign key → routines.routine_id — NOT NULL — 루틴 ID
  • exercise_name — VARCHAR(255) — NOT NULL — 운동 이름

routine_levels

  • level_id — INT — Primary key — NOT NULL — 난이도 ID
  • level_name — VARCHAR(100) — NOT NULL — 난이도 이름

routine_likes

  • routine_id — INT — Foreign key → routines.routine_id — NOT NULL — 루틴 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • created_at — TIMESTAMP — NOT NULL — 생성일

routine_parts

  • part_id — INT — Primary key — NOT NULL — 부위 ID
  • part_name — VARCHAR(100) — NOT NULL — 부위 이름

routine_shares

  • share_id — INT — Primary key — NOT NULL — 공유 ID
  • routine_id — INT — Foreign key → routines.routine_id — NOT NULL — 루틴 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • shared_at — TIMESTAMP — NOT NULL — 공유일

routines

  • routine_id — INT — Primary key — NOT NULL — 루틴 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — LONGTEXT — NOT NULL — 내용
  • created_at — TIMESTAMP — NOT NULL — 작성일
  • updated_at — TIMESTAMP — 수정일
  • view_count — INT — NOT NULL — 조회수
  • share_count — INT — 공유 수
  • is_deleted — BOOLEAN — NOT NULL — 삭제 여부
  • goal_id — INT — Foreign key → routine_goals.goal_id — NOT NULL — 목적 ID
  • level_id — INT — Foreign key → routine_levels.level_id — NOT NULL — 난이도 ID
  • part_id — INT — Foreign key → routine_parts.part_id — NOT NULL — 부위 ID
  • is_public — BOOLEAN — NOT NULL — 공개 여부
  • Field (image_url) — VARCHAR(255) — NOT NULL — 이미지 URL

shipping_addresses

  • address_id — INT — Primary key — NOT NULL — 주소 ID
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • recipient_name — VARCHAR(100) — NOT NULL — 수령인 이름
  • contact — VARCHAR(20) — NOT NULL — 연락처
  • postcode — VARCHAR(10) — NOT NULL — 우편번호
  • address — VARCHAR(255) — NOT NULL — 주소
  • address_detail — VARCHAR(255) — 상세 주소
  • address_name — VARCHAR(100) — NOT NULL — 주소 이름
  • is_default — BOOLEAN — NOT NULL — 기본 주소 여부
  • created_at — TIMESTAMP — NOT NULL — 생성일
  • updated_at — TIMESTAMP — 수정일

shipping_fees

  • fee_id — INT — Primary key — NOT NULL — 배송비 ID
  • fee_amount — DECIMAL(10, 2) — NOT NULL — 배송비 금액
  • free_shipping_threshold — DECIMAL(10, 2) — NOT NULL — 무료 배송 기준 금액

statuses

  • status_id — INT — Primary key — NOT NULL — 상태 ID
  • status_name — VARCHAR(50) — NOT NULL — 상태 이름

user_additional_info

  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • gender — ENUM('M', 'F', 'Other') — 성별
  • occupation — VARCHAR(100) — 직업
  • bench_press — INT — 벤치 프레스
  • squat — INT — 스쿼트
  • deadlift — INT — 데드리프트
  • profile_picture_url — VARCHAR(255) — 프로필 사진 URL

user_roles

  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • role_id — INT — Foreign key → roles.role_id — NOT NULL — 권한 ID

user_social_login

  • provider — VARCHAR(50) — Primary key — NOT NULL — 소셜 로그인 제공자
  • user_id — INT — Foreign key → users.user_id — NOT NULL — 회원 ID
  • provider_id — VARCHAR(255) — NOT NULL — 소셜 로그인 제공자 ID

users

  • user_id — INT — Primary key — NOT NULL — 회원 ID
  • email — VARCHAR(255) — NOT NULL — 이메일
  • name — VARCHAR(100) — NOT NULL — 이름
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • nickname — VARCHAR(50) — NOT NULL — 닉네임
  • phone — VARCHAR(20) — NOT NULL — 핸드폰번호
  • birth_date — DATE — NOT NULL — 생년월일
  • join_date — TIMESTAMP — NOT NULL — 가입일
  • is_active — BOOLEAN — NOT NULL — 활성 상태