Info: Team member columns already exist in the proposals table.
Current Proposals Table Structure:
| Field |
Type |
Null |
Key |
Default |
| id |
int(11) |
NO |
PRI |
|
| full_name |
varchar(255) |
NO |
|
|
| programme_of_study |
varchar(255) |
NO |
|
|
| level |
varchar(50) |
NO |
|
|
| contact |
varchar(15) |
NO |
|
|
| email |
varchar(255) |
NO |
|
|
| business_idea_title |
varchar(255) |
NO |
|
|
| brief_description |
text |
NO |
|
|
| target_market |
text |
NO |
|
|
| competitors |
text |
NO |
|
|
| market_trends |
text |
NO |
|
|
| initial_capital |
varchar(50) |
NO |
|
|
| required_resources |
text |
NO |
|
|
| skills_needed |
text |
YES |
|
|
| potential_partnerships |
text |
YES |
|
|
| social_impact |
text |
YES |
|
|
| technological_elements |
text |
YES |
|
|
| member1_name |
varchar(255) |
YES |
|
|
| member1_programme |
varchar(255) |
YES |
|
|
| member1_level |
varchar(50) |
YES |
|
|
| member1_email |
varchar(255) |
YES |
|
|
| member2_name |
varchar(255) |
YES |
|
|
| member2_programme |
varchar(255) |
YES |
|
|
| member2_level |
varchar(50) |
YES |
|
|
| member2_email |
varchar(255) |
YES |
|
|
| created_at |
timestamp |
YES |
|
current_timestamp() |