ASSA 파일 관리방식 변경
테이블 (17)
Untitled (user_comment_like)
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
- Key (comment_id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (images)
- Key (id) — int — 기본 키 — NOT NULL
- Key (chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (uploader_id) — int — 외래 키 → User.Key — NOT NULL
- Field (name) — varchar(255)
- Field (url) — varchar(255)
- Field (created_at) — datetime
Untitled (chat_message)
- Key (id) — int — 기본 키 — NOT NULL
- Key (chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (sender_id) — int — 외래 키 → User.Key — NOT NULL
- Field (message) — TEXT
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
Untitled (notification)
- Key (id) — int — 기본 키 — NOT NULL
- Key (receiver_id) — int — 외래 키 → User.Key — NOT NULL
- Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (type) — int
- Field (message) — varchar(255)
- Field (read_at) — datetime
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
Untitled (terms_user_agree)
- Key (id) — int — 기본 키 — NOT NULL
- Field (agree) — boolean
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
- Key (terms_id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (terms)
- Key (id) — int — 기본 키 — NOT NULL
- Field (title) — varchar(30)
- Field (content) — TEXT
- Field (is_essential) — boolean
Untitled (user_chat_room_map)
- Key (chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
Untitled (chat_room)
- Key (id) — int — 기본 키 — NOT NULL
- Key (host_id) — int — 외래 키 → User.Key — NOT NULL
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
Untitled (user_reply_like)
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
- Key (reply_id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (user_post_like)
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
- Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (reply)
- Key (id) — int — 기본 키 — NOT NULL
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
- Key (comment_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (content) — TEXT
- Field (image_urls) — TEXT
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
Untitled (comment)
- Key (id) — int — 기본 키 — NOT NULL
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
- Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (content) — TEXT
- Field (image_urls) — TEXT
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
Untitled (community_banned)
- Key (id) — int — 기본 키 — NOT NULL
- Key (community_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
Untitled (follow)
- Key (id) — int — 기본 키 — NOT NULL
- Key (follower_id) — int — 외래 키 → User.Key — NOT NULL
- Key (following_id) — int — 외래 키 → User.Key — NOT NULL
Untitled (post)
- Key (id) — int — 기본 키 — NOT NULL
- Key (user_id) — int — 외래 키 → User.Key — NOT NULL
- Field (title) — varchar(100)
- Field (content) — TEXT
- Field (image_urls) — TEXT
- Field (views) — bigint
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime — asdf
Untitled (community)
- Key (id) — int — 기본 키 — NOT NULL
- Key (chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (video_call_chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(255)
- Field (description) — varchar(255)
- Field (cover_image_url) — varchar(255)
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
User (user)
- Key (id) — int — 기본 키 — NOT NULL
- Field (email) — varchar(100)
- Field2 (password) — varchar(100)
- Field (nickname) — varchar(20)
- Field (profile_image) — varchar(255)
- Field (login_type) — varchar(10)
- Field (description) — varchar(255)
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
- Field