SSAFY-IN

Tables (7)

Matching (Untitled5)

  • matching_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Team.team_id — NOT NULL
  • team_id (Key3) — Foreign key → User.user_id — NOT NULL
  • type (Field3)

Skill (Untitled2)

  • skill_id (Key) — Primary key — NOT NULL
  • name (Field)

Team (Untitled3)

  • team_id (Key) — Primary key — NOT NULL
  • name (Field)
  • subject (Field2)
  • front_need (Field3)
  • back_need (Field4)
  • introduction (Field5)

TeamSkill (Untitled7)

  • skill_id (Key2) — Foreign key → Skill.skill_id — NOT NULL
  • team_id (Key3) — Foreign key → Team.team_id — NOT NULL
  • position_id (Key) — Foreign key → position.position_id — NOT NULL

User (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • position_id (Key2) — Foreign key → position.position_id — NOT NULL
  • name (Field)
  • region (Field2)
  • class (Field3)
  • programming_language (Field5)

UserSkill (Untitled6)

  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • skill_id (Key3) — Foreign key → Skill.skill_id — NOT NULL
  • proficiency (Field2)

position (Untitled4)

  • position_id (Key) — Primary key — NOT NULL
  • name (Field)