matching ssafy erd

Tables (3)

Team (Untitled2)

  • team_id — Integer — Primary key — NOT NULL
  • team_name — varchar(20)
  • team_domain — varchar(50)
  • position_demand — varchar(50)
  • team_description — varchar(300)
  • team_preference — varchar(100)
  • team_leader

User (Untitled)

  • user_id — Integer — Primary key — NOT NULL
  • team_id — Integer — Foreign key → Team.team_id — NOT NULL
  • room_id — Integer — Foreign key → chatting.room_id — NOT NULL
  • user_name — varchar(10) — NOT NULL
  • user_email — varchar(50)
  • user_profile — varchar(550)
  • project_step — varchar(5)
  • major — boolean
  • last_class — Integer
  • position_demand — varchar(50)
  • project_preference — varchar(100)
  • personal_preference (persoanal_preference) — varchar(100)
  • project_experience — varchar(300)
  • qualification — varchar(45)
  • tech_stack — varchar(100)

chatting (Untitled3)

  • room_id — Primary key — NOT NULL
  • Field