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