캡스톤
테이블 (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