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)