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