project

Tables (15)

REVIEW

  • REVIEW_ID — INT — Primary key — NOT NULL — 리뷰 ID
  • USER_ID — VARCHAR(20) — NOT NULL — 회원 ID
  • PRODUCT_ID — INT — NOT NULL — 상품 ID
  • ITEM_ID — INT — NOT NULL — 항목 ID (ORDER_ITEM 참조)
  • RATING — INT — NOT NULL — 별점 (1~5점)
  • CONTENT — VARCHAR(1000) — NOT NULL — 내용
  • REVIEW_STATUS — VARCHAR(20) — NOT NULL — 리뷰 상태 (NORMAL/DELETED/HIDDEN)
  • CREATED_AT — DATETIME — NOT NULL — 작성일
  • UPDATED_AT — DATETIME — 수정일

SMS_AUTH

  • AUTH_ID — BIGINT — Primary key — NOT NULL — 인증 ID
  • USER_ID — VARCHAR(20) — Foreign key → USER.USER_ID — NOT NULL — 회원 ID
  • AUTH_TYPE — VARCHAR(10) — NOT NULL — 인증 타입 (EMAIL/SMS/SNS)
  • AUTH_PURPOSE — VARCHAR(20) — NOT NULL — 인증 목적 (JOIN/FIND_PWD)
  • AUTH_CODE — VARCHAR(10) — NOT NULL — 인증 코드
  • IS_VERIFIED — CHAR(1) — NOT NULL — 인증 여부 (Y/N)
  • EXPIRE_AT — DATETIME — NOT NULL — 만료 일시

USER

  • USER_ID — VARCHAR(20) — Primary key — NOT NULL — 아이디
  • USER_PWD — VARCHAR(100) — NOT NULL — 비밀번호 (해시 암호화)
  • USER_NAME — VARCHAR(20) — NOT NULL — 이름
  • USER_PHONE — VARCHAR(20) — NOT NULL — 핸드폰번호 (본인인증 수단)
  • EMAIL — VARCHAR(30) — NOT NULL — 이메일
  • NICKNAME — VARCHAR(20) — 닉네임
  • GRADE_ID — INT — Foreign key → USER_GRADE.GRADE_ID — 회원등급 (USER_GRADE 참조)
  • USER_STATUS — VARCHAR(10) — NOT NULL — 회원상태 (ACTIVE/STOP/WITHDRAW)
  • CREATED_AT — DATE — NOT NULL — 가입일
  • UPDATED_AT — DATE — 수정일

USER_ADDRESS

  • ADDRESS_ID — INT — Primary key — NOT NULL — 주소 ID
  • USER_ID — VARCHAR(20) — Foreign key → USER.USER_ID — NOT NULL — 회원 ID
  • ADDRESS_ALIAS — VARCHAR(20) — NOT NULL — 배송지 별칭 (우리집, 회사 등)
  • ADDRESS — VARCHAR(200) — NOT NULL — 기본 주소 (도로명 주소)
  • DETAILED_ADDRESS — VARCHAR(100) — NOT NULL — 상세 주소
  • DEFAULT_YN — CHAR(1) — NOT NULL — 기본배송지여부 (Y/N)

USER_GRADE

  • GRADE_ID — INT — Primary key — NOT NULL — 등급 ID
  • GRADE_NAME — VARCHAR(20) — NOT NULL — 등급명
  • MIN_AMOUNT — INT — NOT NULL — 최소 금액 (등급 유지/상향 기준)
  • DISCOUNT_RATE — DECIMAL(4, 2) — NOT NULL — 할인율
  • DESCRIPTION — VARCHAR(200) — 설명

chat_messages

  • id — INT — Primary key — NOT NULL
  • room_id — INT — Foreign key → chat_rooms.id — NOT NULL
  • sender_id — INT — Foreign key → users.id — NOT NULL
  • message_type — ENUM('text', 'image') — NOT NULL
  • content — TEXT
  • image_url — VARCHAR(500)
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

chat_requests

  • id — INT — Primary key — NOT NULL
  • sender_id — INT — Foreign key → users.id — NOT NULL
  • receiver_id — INT — Foreign key → users.id — NOT NULL
  • status — ENUM('pending', 'accepted', 'rejected') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

chat_rooms

  • id — INT — Primary key — NOT NULL
  • request_id — INT — Foreign key → chat_requests.id — NOT NULL
  • user1_id — INT — Foreign key → users.id — NOT NULL
  • user2_id — INT — Foreign key → users.id — NOT NULL
  • last_message — VARCHAR(500) — 채팅목록 미리보기
  • last_message_at — TIMESTAMP
  • user1_read_at — TIMESTAMP — user1 마지막 읽은 시간
  • user2_read_at — TIMESTAMP — user2 마지막 읽은 시간
  • created_at — TIMESTAMP — NOT NULL

comments

  • id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → posts.id — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

follows

  • follower_id — INT — Foreign key → users.id — NOT NULL — 팔로우 하는 사람
  • following_id — INT — Foreign key → users.id — NOT NULL — 팔로우 받는 사람
  • created_at — TIMESTAMP — NOT NULL

likes

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • post_id — INT — Foreign key → posts.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

post_images

  • id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → posts.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL — 이미지 순서
  • created_at — TIMESTAMP — NOT NULL

post_items

  • id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → posts.id — NOT NULL
  • brand_name — VARCHAR(100) — 브랜드명 직접 입력
  • item_name — VARCHAR(200) — NOT NULL
  • category — ENUM('top', 'bottom', 'outer', 'shoes', 'bag', 'acc', 'etc') — NOT NULL
  • purchase_url — VARCHAR(500) — 구매처 URL
  • price — DECIMAL(10, 2)
  • currency — VARCHAR(10) — NOT NULL
  • size_purchased — VARCHAR(20) — 구매 사이즈
  • fit_review — ENUM('small', 'true', 'large')
  • rating — TINYINT — 1~5점
  • review_text — TEXT
  • created_at — TIMESTAMP — NOT NULL

posts

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT — NOT NULL
  • style — ENUM('techwear', 'amekaji', 'casual', 'street', 'workwear', 'etc') — NOT NULL
  • tags — JSON — "#고어텍스","#아크테릭스"
  • likes_count — INT — NOT NULL
  • comments_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

users

  • id — INT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • profile_image — VARCHAR(500)
  • bio — TEXT
  • height — INT — 착용 참고용 키(cm)
  • weight — INT — 착용 참고용 몸무게(kg)
  • is_online — BOOLEAN — NOT NULL
  • last_seen_at — TIMESTAMP
  • refresh_token — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_active — BOOLEAN — NOT NULL