favory
테이블 (10)
댓글 (comments)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (favory_id) — bigint
- Field (user_id) — bigint
- Field (content) — varchar(100)
- Field (created_at) — timestamp(6)
- Field (updated_at) — timestamp(6)
- Field (deleted_at) — timestamp(6)
리뷰 (favory)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (user_id) — bigint
- Field (media_id) — bigint
- Field (title) — varchar(100)
- Field (content) — text
- Field (like_count) — bigint
- Field (created_at) — timestamp(6)
- Field (updated_at) — timestamp(6)
- Field (deleted_at) — timestamp(6)
리뷰태그 (favory_tag_mappings)
- Key (id) — bigint — 기본 키
- Field (favory_id) — bigint
- Field (tag_id) — bigint
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
미디어 (media)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (external_id) — varchar(200)
- Field (type) — varchar(20)
- Field (title) — VARCHAR(200)
- Field (creator) — VARCHAR(200)
- Field (year) — int
- Field (image_url) — varchar(500)
- Field (created_at) — timestamp(6)
- Field (updated_at) — timestamp(6)
미디어태그 (media_tag_mapping)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (media_id) — bigint
- Field (tag_id) — bigint
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
이메일인증 (email_verifications)
- Key (id) — bigint — 기본 키
- Field (email) — varchar(255)
- Field (code_hash) — varchar(255)
- Field (code_expires_at) — timestamp(6)
- Field (verify_token_hash) — varchar(255)
- Field (verify_token_expires_at) — timestamp(6)
- Field (verified_at) — timestamp(6)
- Field (created_at) — timestamp(6)
- Field (updated_at) — timestamp(6)
좋아요 (likes)
- Key (id) — bigint — 기본 키
- Field (user_id) — bigint
- Field (favory_id) — bigint
- Field (created_at) — datetime(6)
최근검색 (search_recent)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (user_id) — bigint
- Field (keyword) — varchar(200)
- Field (last_used_at) — timestamp(6)
- Field (created_at) — timestamp(6)
- Field (updated_at) — timestamp(6)
태그 (tags)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(50)
- Field (created_at) — timestamp(6)
- Field (updated_at) — timestamp(6)
회원 (users)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (email) — varchar(255)
- Field (password) — varchar(255)
- Field (provider) — enum('GOOGLE', 'LOCAL')
- Field (provider_id) — varchar(100)
- Field (nickname) — varchar(50)
- Field (profile_image_url) — varchar(500)
- Field (profile_message) — text
- Field (created_at) — timestamp(6)
- Field (updated_at) — timestamp(6)