種子輪:7年  目前:天使輪?? 資金不到位, 資料庫規格複雜, 人力有限, 存在系統問題。

一枝草一點露的VC優勢 : 定義Jeff的編碼轉成EdgeSql (Nodes & Edges), 應用在未來的容器轉換(Docker, ETL, AI), 初期: PHP+MariaDB/MySql, 進入VC: Python + EdgeSql ＋Flask, B輪:導入AI。

除雲方案: 建教合作 (和大專院校資管資工系合作實習方案, 初期定義長者照護的Edges方案)
教育部 - 大專校院校外實習合約書範本-非僱傭關係 下載

Edge-SQL Definition
1. Giving and Giving Back
Entities: Donors, Beneficiaries

CREATE EDGE TABLE Donor_Beneficiary (
FROM Donors REFERENCES Donors(DonorID),
TO Beneficiaries REFERENCES Beneficiaries(BeneficiaryID),
DonationDate DATE,
DonationType VARCHAR(255),
DonationAmount DECIMAL(10, 0)
);

2. Goods and Services
Entities: Providers, Recipients

CREATE EDGE TABLE Provider_Recipient (
FROM Providers REFERENCES Providers(ProviderID),
TO Recipients REFERENCES Recipients(RecipientID),
ServiceDate DATE,
ServiceType VARCHAR(255),
ServiceValue DECIMAL(10, 2)
);

3. Volunteers and Activities
Entities: Volunteers, Activities

CREATE EDGE TABLE Volunteer_Activities (
FROM Volunteers REFERENCES Volunteers(VolunteerID),
TO Activities REFERENCES Activities(ActivityID),
ParticipationDate DATE,
Role VARCHAR(255)
);

4. Members and Events
Entities: Members, Events

CREATE EDGE TABLE Member_Events (
FROM Members REFERENCES Members(MemberID),
TO Events REFERENCES Events(EventID),
AttendanceDate DATE,
Role VARCHAR(255)
);

5. Community Leaders and Initiatives
Entities: Leaders, Initiatives

CREATE EDGE TABLE Leader_Initiatives (
FROM Leaders REFERENCES Leaders(LeaderID),
TO Initiatives REFERENCES Initiatives(InitiativeID),
LaunchDate DATE,
InitiativeType VARCHAR(255)
);

6. Mentors and Mentees
Entities: Mentors, Mentees

CREATE EDGE TABLE Mentor_Mentees (
FROM Mentors REFERENCES Mentors(MentorID),
TO Mentees REFERENCES Mentees(MenteeID),
MentorshipStartDate DATE,
MentorshipEndDate DATE
);

7. Participants and Workshops
Entities: Participants, Workshops

CREATE EDGE TABLE Participant_Workshops (
FROM Participants REFERENCES Participants(ParticipantID),
TO Workshops REFERENCES Workshops(WorkshopID),
ParticipationDate DATE,
Feedback TEXT
);

8. Businesses and Sponsorships
Entities: Businesses, Sponsorships

CREATE EDGE TABLE Business_Sponsorships (
FROM Businesses REFERENCES Businesses(BusinessID),
TO Sponsorships REFERENCES Sponsorships(SponsorshipID),
SponsorshipDate DATE,
SponsorshipAmount DECIMAL(10, 2)
);

9. Partners and Collaborations
Entities: Partners, Projects

CREATE EDGE TABLE Partner_Collaborations (
FROM Partners REFERENCES Partners(PartnerID),
TO Projects REFERENCES Projects(ProjectID),
CollaborationDate DATE,
ContributionType VARCHAR(255)
);

10. Residents and Community Programs
Entities: Residents, Programs

CREATE EDGE TABLE Resident_Programs (
FROM Residents REFERENCES Residents(ResidentID),
TO Programs REFERENCES Programs(ProgramID),
EnrollmentDate DATE,
ProgramRole VARCHAR(255)
);

長者照護存在: 視力,反應,外勞看護等因素, 介面需簡化。