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 — 활성 상태