devintro
Tables (10)
Untitled (UserAccount)
- Key (user_id) — int — Primary key — NOT NULL — auto increment
- Field (login_id) — varchar(50) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (confirm_password) — varchar(255) — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (currentTokenVersion) — int — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field (delete_at) — timestamp
Untitled (BusinessProfile)
- Key (profile_id) — int — Primary key — NOT NULL — auto increment
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (company) — varchar(100) — NOT NULL
- Field2 (department) — varchar(100) — NOT NULL
- Field3 (position) — varchar(100) — NOT NULL
- Field4 (email) — varchar(100) — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field (deleted_at) — timestamp
Untitled (Post)
- Key (post_id) — int — Primary key — NOT NULL — auto increment
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — varchar(255) — NOT NULL
- Field2 (content) — text — NOT NULL
- Field (post_comments_count) — int
- Field (post_like_count) — int
- Field3 (created_at) — timestamp — NOT NULL
- Field (deleted_at) — timestamp — NOT NULL
Untitled (PostLike)
- Key (post_like_id) — int — Primary key — NOT NULL — auto increment
- Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL — auto increment
- Field (created_at) — timestamp — NOT NULL
Untitled (Notification)
- Key (notification_id) — int — Primary key — NOT NULL — auto increment
- Key (sender_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (receiver_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (comment_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (type) — varchar(50) — NOT NULL
- Field2 (message) — varchar(255) — NOT NULL
- Field3 (is_read) — tinyint(1) — NOT NULL
- Field4 (create_at) — timestamp — NOT NULL
- Field (deleted_at) — timestamp
Untitled (BusinessContact)
- Key (business_contact_id) — int — Primary key — NOT NULL — auto increment
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (contact_user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — timestamp — NOT NULL
- Field2 (deleted_at) — timestamp
Untitled (FriendRequest)
- Key (request_id) — int — Primary key — NOT NULL — auto increment
- Key (sender_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (receiver_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (status) — enum('pending', 'accepted', 'rejected') — NOT NULL
- Field2 (created_at) — timestamp — NOT NULL
- Field (deleted_at) — timestamp
Untitled (Comment)
- Key (comment_id) — int — Primary key — NOT NULL — auto increment
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text — NOT NULL
- Field2 (comment_like_count) — int — NOT NULL
- Field3 (created_at) — timestamp — NOT NULL
- Field4 (deleted_at) — timestamp
Untitled (CommentLike)
- Key (comment_like_id) — int — Primary key — NOT NULL — auto increment
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (comment_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (created_at) — timestamp — NOT NULL
Untitled (RefreshToken)
- Key (refresh_token_id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (token) — varchar(500) — NOT NULL
- Field2 (created_at) — timestamp — NOT NULL
- Field3 (expires_at) — timestamp — NOT NULL
- Field4 (deleted_at) — timestamp