web_prog
Tables (8)
chat_messages
- message_id — BIGINT — Primary key
- room_id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- message_text — TEXT
- sent_at — DATETIME
chat_rooms
- room_id — BIGINT — Primary key
- group_id — BIGINT — NOT NULL
- room_name — VARCHAR(100)
- created_at — DATETIME
comments
- comment_id — BIGINT — Primary key
- post_type — ENUM('post','gpost') — NOT NULL
- post_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- content — MEDIUMTEXT
- created_at — DATETIME
- INDEX — idx_comments_post
group_members
- user_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — NOT NULL
- joined_at — DATETIME
- role — ENUM('leader','member')
group_posts
- gpost_id — BIGINT — Primary key
- group_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- title — VARCHAR(150) — NOT NULL
- content — MEDIUMTEXT
- created_at — DATETIME
groups
- group_id — BIGINT — Primary key
- group_name — VARCHAR(100) — NOT NULL
- description — TEXT
- category — VARCHAR(50)
- is_online — BOOLEAN
- created_by — BIGINT — NOT NULL
- created_at — DATETIME
posts
- post_id — BIGINT — Primary key
- title — VARCHAR(150) — NOT NULL
- content — MEDIUMTEXT
- category — VARCHAR(50)
- author_id — BIGINT — NOT NULL
- group_id — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
users
- user_id — BIGINT — Primary key
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — CHAR(60) — NOT NULL
- profile_image — VARCHAR(255)
- bio — TEXT
- joined_at — DATETIME