ASSA
Tables (19)
Copy Of Untitled (friends)
- Key (id) — bigint — Primary key — NOT NULL
- Key (requester_id) — bigint — Foreign key → User.Key — NOT NULL
- Key (receiver_id) — bigint — Foreign key → User.Key — NOT NULL
- Field (accept) — string
Copy Of Untitled2 (blockedusers)
- Key (id) — bigint — Primary key — NOT NULL
- Key (from_id) — bigint — Foreign key → User.Key — NOT NULL
- Key (to_id) — bigint — Foreign key → User.Key — NOT NULL
Untitled (user_reply_like)
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Key (reply_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (images)
- Key (id) — int — Primary key — NOT NULL
- Key (chat_room_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (uploader_id) — int — Foreign key → User.Key — NOT NULL
- Field (name) — varchar(255)
- Field (url) — varchar(255)
- Field (created_at) — datetime
Untitled (chat_message)
- Key (id) — int — Primary key — NOT NULL
- Key (chat_room_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (sender_id) — int — Foreign key → User.Key — NOT NULL
- Field (message) — TEXT
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
Untitled (notification)
- Key (id) — int — Primary key — NOT NULL
- Key (receiver_id) — int — Foreign key → User.Key — NOT NULL
- Key (post_id) — int — Foreign key → 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 — Primary key — NOT NULL
- Field (agree) — boolean
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Key (terms_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (terms)
- Key (id) — int — Primary key — NOT NULL
- Field (title) — varchar(30)
- Field (content) — TEXT
- Field (is_essential) — boolean
Untitled (user_chat_room_map)
- Key (chat_room_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Field (isHost) — boolean
Untitled (chat_room)
- Key (id) — int — Primary key — NOT NULL
- Field2 (room_name) — varchar(255)
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
Untitled (user_comment_like)
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Key (comment_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (user_post_like)
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (reply)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Key (comment_id) — int — Foreign key → 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 — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (content) — TEXT
- Field (image_urls) — TEXT
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
Untitled (openchat_banned)
- Key (id) — int — Primary key — NOT NULL
- Key (openchat_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
Untitled (follows)
- Key (id) — int — Primary key — NOT NULL
- Key (follower_id) — int — Foreign key → User.Key — NOT NULL
- Key (following_id) — int — Foreign key → User.Key — NOT NULL
Untitled (post)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Field (title) — varchar(100)
- Field (content) — TEXT
- Field (image_urls) — TEXT
- Field (view_count) — bigint
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (deleted_at) — datetime — asdf
Untitled (openchat)
- Key (id) — int — Primary key — NOT NULL
- Key (chat_room_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (video_call_chat_room_id) — int — Foreign key → 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 — Primary key — 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