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