캡스톤

테이블 (6)

item

  • item_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • price — INTEGER — NOT NULL
  • image_url — VARCHAR(500)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

member

  • member_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — 일반
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image — VARCHAR(500)
  • point — INTEGER
  • total_distance — DOUBLE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

member_item

  • member_item_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • item_id — BIGINT — 외래 키 → item.item_id — NOT NULL
  • is_equipped — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

music_recommendation

  • music_id — BIGINT
  • walk_id — BIGINT — 외래 키 → walk.walk_id — NOT NULL
  • track_title — VARCHAR(255) — NOT NULL
  • artist — VARCHAR(255) — NOT NULL
  • album_cover — VARCHAR(500)
  • spotify_track_id — VARCHAR(100)
  • ai_comment — TEXT — EX
  • mood_tag — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

social_login

  • social_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL — 제공자
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

walk

  • walk_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • path_line — GEOMETRY(LineString, 4326)
  • distance — DOUBLE
  • step_count — INTEGER
  • duration — INTEGER
  • start_location — VARCHAR(255)
  • result_image_url — VARCHAR(500)
  • started_at — TIMESTAMP
  • ended_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP