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