TeamIT
Tables (8)
applications
- id — INT
- user_id — INT
- project_id — INT
- message — TEXT
- status — ENUM('PENDING', 'ACCEPTED', 'REJECTED')
- created_at — DATETIME
- updated_at — DATETIME
comments
- id — INT
- user_id — INT
- project_id — INT
- content — TEXT — NOT NULL
- created_at — DATETIME
file_uploads
- id — INT
- user_id — INT
- file_url — TEXT — NOT NULL
- file_type — ENUM('IMAGE', 'PDF', 'ZIP')
- description — TEXT
- uploaded_at — DATETIME
notifications
- id — INT
- user_id — INT
- content — TEXT — NOT NULL
- url — TEXT
- is_read — BOOLEAN
- created_at — DATETIME
projects
- id — INT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- tech_stack — TEXT
- status — ENUM('OPEN', 'CLOSED')
- leader_id — INT
- start_date — DATE
- end_date — DATE
- max_member_count — INT
- created_at — DATETIME
- updated_at — DATETIME
team_members
- id — INT
- team_id — INT
- user_id — INT
- role_in_team — VARCHAR(50)
- joined_at — DATETIME
- is_active — BOOLEAN
teams
- id — INT
- name — VARCHAR(255)
- project_id — INT
- created_at — DATETIME
- updated_at — DATETIME
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- password_hash — TEXT — NOT NULL
- role — ENUM('DEVELOPER', 'DESIGNER', 'PM') — NOT NULL
- social_provider — VARCHAR(50)
- profile_image_url — TEXT
- created_at — DATETIME
- updated_at — DATETIME