IVBLANC
Tables (8)
CLOTHES
- clothes_id — INT — Primary key — NOT NULL
- 카테고리 (category) — INT
- 색깔 (color) — VARCHAR(8)
- 소재 (material) — VARCHAR(10)
- 생성날짜 (create_date) — datetime
- 수정날짜 (update_date) — datetime
- 사진경로 (url) — VARCHAR(2000)
- favorite — INT
- size — INT
- 시즌 (season) — INT
- count — INT
- like (likepoint) — INT
- dislike (dislikepoint) — INT
- user_id — INT — Foreign key → USER.user_id — NOT NULL
FRIEND
- friend_id — INT — Primary key — NOT NULL
- 신청자 (applicant) — VARCHAR(255)
- 친구 (friend) — VARCHAR(255)
- 수락여부 (isaccept) — VARCHAR(1)
HISTORY
- history_id — INT — Primary key — NOT NULL
- 위치 (location) — decimal(10,7)
- 경도 (Field) — decimal(11,7)
- 날짜 (date) — timestamp
- 날씨 (weather) — VARCHAR(10)
- 기온 (temperature) — VARCHAR(10)
- 내용 (text) — VARCHAR(2000)
- 제목 (subject) — VARCHAR(255)
- stylephotorul (styleurl) — VARCHAR(2000)
- user_id — INT — Foreign key → USER.user_id — NOT NULL
PHOTO
- photo_id — INT — Primary key — NOT NULL
- 사진 (url) — VARCHAR(2000)
- diary_id — INT — Foreign key → HISTORY.history_id — NOT NULL
- user_id — INT — Foreign key → HISTORY.user_id — NOT NULL
STYLE
- style_id — INT — Primary key — NOT NULL
- madeby — VARCHAR(20) — NOT NULL
- favorite — INT
- url — VARCHAR(2000)
- photoname (photo_name) — VARCHAR(255)
- user_id — INT — Foreign key → USER.user_id — NOT NULL
STYLE_DETAIL
- sd_id — INT — Primary key — NOT NULL
- style_id — INT — Foreign key → STYLE.style_id — NOT NULL
- clothes_id — INT — Foreign key → CLOTHES.clothes_id — NOT NULL
- user_id — INT — Foreign key → STYLE.user_id — NOT NULL
USER
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(15) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- age — INT
- gender — INT
- phone — VARCHAR(15)
- social — INT
USER_TOKEN
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- jwt — VARCHAR(512)
- fcm — VARCHAR(512)
- 공유코드 (code) — VARCHAR(512)