Connectify

Tables (7)

comment

  • id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → post.id
  • user_id — bigint — Foreign key → users.id
  • content — text — NOT NULL
  • created_at — datetime(6)

file_upload

  • id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → post.id
  • file_name — varchar(255)
  • file_path — varchar(255)
  • file_size — bigint
  • uploaded_at — datetime(6)
  • original_file_name — varchar(255)

friendship

  • id — bigint — Primary key — NOT NULL
  • receiver_id — bigint — Foreign key → users.id — NOT NULL
  • sender_id — bigint — Foreign key → users.id — NOT NULL
  • user_id — bigint — Foreign key → users.id
  • created_at — datetime(6)
  • status — varchar(255)
  • is_friend — varchar(255)

messages

  • id — bigint — Primary key — NOT NULL
  • receiver_id — bigint — Foreign key → users.id — NOT NULL
  • sender_id — bigint — Foreign key → users.id — NOT NULL
  • content — varchar(1000) — NOT NULL
  • is_read — bit(1) — NOT NULL
  • sent_at — datetime(6) — NOT NULL

post

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id
  • content — text
  • created_at — datetime(6)
  • is_notice — bit(1) — NOT NULL
  • title — varchar(255)
  • views — int — NOT NULL

reply

  • id — bigint — Primary key — NOT NULL
  • parent_comment_id — bigint — Foreign key → comment.id
  • user_id — bigint — Foreign key → users.id
  • post_id — bigint — Foreign key → post.id
  • author — varchar(255)
  • content — text — NOT NULL
  • created_at — datetime(6) — NOT NULL

users

  • id — bigint — Primary key — NOT NULL
  • email — varchar(255)
  • password — varchar(255)
  • role — varchar(255)
  • username — varchar(255)
  • suspension_end_date — date