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