# DB Schemas

### User Registration

- UserID (autogenerated and non editable and unique)
- First Name
- Last Name
- Date of birth
- Email (unique used for signin)
- Phone (unique)
- Education qualification
- Education qualified year
- College
- Branch
- Occupation and company (if employed)
- Current Place
- Area of interest
- Laptop Availability
- Broadband availability
- How do you know swecha? (Choose from given list)
- Role (Default Participant)
- ProfilePicID
- Date Joined
- Last login
- Last Updated

### Events Table
- EventID (autogenerated and non editable)
- Event Name
- Category (Technical, Social...)
- Activity
- Talks
- Workshops
- Hackathons
- Date
- StartTime
- EndTime
- Place
- Venue
- Amount
- created Date
- update Date
- Created BY (userID)
- Updated BY (userID)

### Roles Table

- UserID
- is_attendance_access
- is_event_creation
- is_update_event
- is_delete_event
- is_approve_participant
- is_assign_speakers
- is_assign_volunteers
- is_upload_template
- is_update_template
- is_delete_template
- is_assign_roles

### Events Registered Table
- EventID
- UserID
- ActivityID
- is_registered
- is_attended
- CertID
- is_paid
- PaymentID
- Amount Paid
- Mode of Payment

### Payments table
- UserID
- EventID
- PaymentID
- AmountPaid
- Date of Payment
- Mode of Payment