Project Title: Alumini

Project Title: Alumini

Magic alumini is web based software which enables us any institute / school / college to manage the alumini of the institute ex students. Here students can connect to each other to share their feeds, jobs,Queries. Institude can also use it to conduct events, polls etc. It will have two stake holders –

1. Institute/School/College: who manage and control alumni. Admin can do the following activites –

• Activate /De Activate the Members/Students
• Country / State / City
• Manage Events and Event Registrations
• Manage Polls and Answers
• Define Rules/ Regulations

1. Student/Members : Student / Member can login / registration will do the following activites –

• can register and login in the software.
• View events and register to event.
• view polls and reply to poll
• send and accept connect request.
• View Connections and Friends.

GenderEnum	EventModeEnum
Male=1	Online=1
FeMale=2	Offline=2
Other=3	Mix=3
RequestStatusEnum	FeedTypeEnum
Pending=1	Text=1
Accepted=2	Photo=2
	Video=3
PollStatusEnum
Open=1	FeedStatusEnum
Close=2	Accepted=1
	Rejected=2
EventTypeEnum
Webinar=1	RequeststatusEnum
Meet=2	Accepted=1
FreeSession=3	Rejected=2

Model Name: Company
Sr. No.	Property Name	Data Type	Remark
1	CompanyID	bigint	pk
2	CompanyName	string
3	Address	string
4	EmailID	string
5	MobileNo	string
6	LogoPath	string
7	RegistrationDate	DateTime
8	CityID	FK
9	WebsiteUrl	string
10	ContactNo	string
11	ContactPersonName	string

Class Name:Country
Sr. No.	Property Name	Data Type	Remark
1	CountryID	bigint	FK
2	CountryName	string
Class Name:State
Sr. No.	Property Name	Data Type	Remark
1	StateID	bigint	FK
2	StateName	string
3	CountryID	bigint	FK
Class Name:City
Sr. No.	Property Name	Data Type	Remark
1	CityID	bigint	FK
2	CityName	string
3	StateID	bigint	FK

	Model Name: Event
Sr. No.	Property Name	Data Type	Remark
1	EventID	bigint	FK
2	EventTitle	string
3	EventShortDesc	string
4	EventDateTime	DateTime
5	EventLogo	string
6	EventType	EventTypeEnum
7	RegistrationFromDate	DateTime
8	RegistrationToDate	DateTime
10	MemberLimit	int
11	EventMode	EventModeEnum
12	CreatedByID	bigint	FK to CompanyAdminID

Model Name: CompanyAdmin
Sr. No.	Property Name	Data Type	Remark
1	CompanyAdminID	bigint	pk
2	CompanyID	bigint	FK
3	FirstName	string
4	LastName	string
5	EmailID	string
6	MobileNo	string
7	Address	string
8	CityID	bigint	FK

Model Name	MemberCourseDet
Sr. No.	Property Name	Data Type	Remark
1	MemberCourseDetID	bigint	pk
2	MemberID	bigint	FK
3	CourseName	string
4	AttendedYear	string

Class Name:Poll
Sr. No.	Property Name	Data Type	Remark
1	PollID	bigint	FK
2	PollDate	DateTime
3	PollStatus	PollStatusEnum
4	PollQuestion	string
5	CreatedByID	bigint	FK to CompanyAdminID

Class Name:PollResponse
Sr. No.	Property Name	Data Type	Remark
1	PollResponseID	bigint	FK
2	PollResponseDate	DateTime
3	MemberID	bigint
4	PollID	bigint	fk

Class Name:	EventRegistration
Sr. No.	Property Name	Data Type	Remark
1	EventRegistrationID	bigint	FK
2	MemberID	bigint	FK
3	EventID	bigint	FK
4	RegistrationDate	DateTime
5	IsAccepted	boolean
6	AcceptedByID	bigint	FK to CompanyAdminID

Class Name:FeedsVideo
Sr. No.	Property Name	Data Type	Remark
1	PhotoVideoID	bigint	FK
2	FeedsID	bigint	fk
3	VideoUrl	string

Model Name:Member
Sr. No.	Property Name	Data Type	Remark
1	MemberID	bigint	pk
2	FirstName	string
3	LastName	string
4	CompanyID	bigint	FK
5	DateOfBirth	string
6	Gender	GenderEnum
7	ProfilePicture	string

Model Name:	MemberRequest
Sr. No.	Property Name	Data Type	Remark
1	MemberRequestID	bigint	pk
2	MemberID	bigint	fk
3	RequestDate	DateTime
4	RequestStatus	RequestStatusEnum

Class Name:PollOption
Sr. No.	Property Name	Data Type	Remark
1	PollOptionID	bigint	FK
2	Option	string
3	IsCorrect	boolean

Class Name:	PollResponseOption
Sr. No.	Property Name	Data Type	Remark
1	PollResponseOptionID	bigint	FK
2	PollResponseID	bigint	fk
3	PollOptionID	bigint	fk

Class Name:Feeds
Sr. No.	Property Name	Data Type	Remark
1	FeedsID	bigint	FK
2	FeedDate	DateTime
3	FeedTitle	string
4	FeedType	FeedTypeEnum
5	FeedsDescription	string
6	FeedStatus	FeedStatusEnum

Class Name:FeedsPhoto
Sr. No.	Property Name	Data Type	Remark
1	FeedsPhotoID	bigint	FK
2	FeedsID	bigint	fk
3	PhotoPathFile	string

Class Name:	MemberConnectionRequest
Sr. No.	Property Name	Data Type	Remark
1	MemberConnectionRequestID	bigint	FK
2	RequestFromID	bigint
3	RequestToID	bigint
4	RequestDate	DateTime
5	RequestStatus	RequestStatusEnum
6	RequestNote	string

Class Name:MemberConnection
Sr. No.	Property Name	Data Type	Remark
1	MemberConnectionID	bigint	PK
2	MemberID	bigint	fk
3	ConnectedMemberID	bigint	no fk
4	ConnectionRequestID	bigint	FK
5	AcceptDate	DateTime

Model Name: Job

Sr No.	Property Name	Data Type	Remark
1	JobID	Int64	pk
2	JobTitle	string
3	JobDescription	string
4	MinimumEducation	string
5	Experience	string
6	JobRole	string
7	IsOpen	bool
8	Companyname	string	optional
9	ReferenceName	string	optional
8	NoOfVacancies	string	optional
9	AnyOtherInfo	string	optional
10	CompanyID	Int64

Model Name: MemberEducation

Sr. No.	Property Name	Data Type	Remark
1	MemberEducationID	int64	pk
2	MemberID	int64	fk
3	EducationTitle	string
4	PassoutYear	string
5	UniversityOrCollegateName	string
6	GradeOrPercentage	string

Model :MemberExperience

Sr. No.	Property Name	Data Type	Remark
1	MemberExperienceID	int64	PK
2	MemberID	int64	FK
3	ExperienceTitle	string
4	ExperienceDuration	double
5	ExperienceDescription	string
6	CompanyName	string
7	FromDate	DateTime
8	ToDate	DateTime

Model: MemberResume

Sr. No.	Property Name	Data Type	Remark
1	MemberResumeID	int64	PK
2	MemberID	int64	FK
3	ResumeFilePath	string
4	FileType	string
5	LastUpdatedDate	DateTime

Model: MemberSkills

Sr.No.	PropertyName	data Type	Remark
1	MemberSkillID	int64	pk
2	MemberID	int64	fk
3	SkillID	int64	fk
4	Propficiency	PropficientyEnum
5	NoOfYears	int

Model:Skill

Sr. No.	Property Name	Data Type	Remark
1	SkillID	int64	pk
2	SkillName	string

ProficientyEnum => Advance =1, Moderate =2, Biginer-3