The Employee Association System is a web-based platform designed to streamline and manage all aspects of employee engagement, collaboration, communication, and resource sharing within an organization. The system provides a comprehensive suite of tools that empower employees, administrators, and managers to stay connected, share knowledge, and foster a collaborative work environment. In this article we shared Employee Association System Database Design.
Employee Association System Database Table Design:
Table Name: branch
| Column | Type | Index | Description |
| branch_id | int(10) | Primary Key | Branch unique ID |
| branchname | varchar(25) | Null | Branch name |
| description | text | Null | Branch detail |
| status | varchar(10) | Null | Branch status |
Table Name: designation
| Column | Type | Data Type | Description |
| designation_id | int(10) | Primary Key | Designation unique ID |
| designation | varchar(25) | Null | Designation |
| description | text | Null | Designation detail |
| status | varchar(10) | Null | Designation status |
Table Name: discussion
| Column | Type | Data Type | Description |
| discussion_id | int(10) | Primary Key | Discussion unique ID |
| employee_id | int(10) | Foreign Key | Employee unique ID |
| discussiontitle | varchar(250) | Null | Discussion title |
| category | varchar(25) | Null | Discussion category |
| discussionimage | varchar(100) | Null | Discussion image |
| uploads | varchar(100) | Null | Discussion uploads |
| description | text | Null | Discussion detail |
| publishdate | datetime | Null | Discussion publish date |
| status | varchar(10) | Null | Discussion status |
Table Name: discussion_reply
| Column | Type | Data Type | Description |
| reply_id | int(10) | Primary Key | Reply unique ID |
| discussion_id | int(10) | Foreign Key | Discussion unique ID |
| employee_id | int(10) | Foreign Key | Employee unique ID |
| description | text | Null | Discussion reply detail |
| uploads | varchar(100) | Null | Discussion reply uploads |
| publishdate | datetime | Null | Discussion reply publish date |
| status | varchar(10) | Null | Discussion reply status |
Table Name: employee
| Column | Type | Data Type | Description |
| employee_id | int(10) | Primary Key | Employee unique ID |
| branch_id | int(10) | Foreign Key | Branch unique ID |
| designation_id | int(10) | Foreign Key | Designation unique ID |
| empname | varchar(25) | Null | Employee Name |
| dob | date | Null | Employee date of birth |
| gender | varchar(10) | Null | Employee gender |
| address | varchar(250) | Null | Employee address |
| country | varchar(25) | Null | Employee country |
| state | varchar(25) | Null | Employee state |
| city | varchar(25) | Null | Employee city |
| pincode | varchar(10) | Null | Employee pincode |
| doj | date | Null | Employee date of joining |
| dor | date | Null | Employee date of retirement |
| login_id | varchar(25) | Null | Employee login ID |
| password | varchar(250) | Null | Employee password |
| empimage | varchar(100) | Null | Employee image |
| note | text | Null | Employee note |
| status | varchar(10) | Null | Employee status |
Table Name: mail
| Column | Type | Data Type | Description |
| mail_id | int(10) | Primary Key | Mail unique ID |
| employee_id1 | int(10) | Foreign Key | Employee1 unique ID |
| employee_id2 | int(10) | Foreign Key | Employee2 unique ID |
| messagetitle | varchar(150) | Null | Mail title |
| messagecontent | text | Null | Mail content |
| attachments | varchar(100) | Null | Mail attachments |
| senddate | datetime | Null | Mail senddate |
| status | varchar(10) | Null | Mail status |
Table Name: news
| Column | Type | Data Type | Description |
| news_id | int(10) | Primary Key | News unique ID |
| employee_id | int(10) | Foreign Key | Employee unique ID |
| newstype | varchar(25) | Null | News type |
| newstitle | varchar(150) | Null | News title |
| newsdate | datetime | Null | News date |
| newsimage | varchar(100) | Null | News image |
| newscontent | text | Null | News content |
| newscategory | varchar(25) | Null | News category |
| status | varchar(10) | Null | News status |
Table Name: subscription
| Column | Type | Data Type | Description |
| subscription_id | int(10) | Primary Key | Subscription unique ID |
| employee_id | int(10) | Foreign Key | Employee unique ID |
| startdate | date | Null | Subscription senddate |
| enddate | date | Null | Subscription enddate |
| subscriptioncharge | float(10,2) | Null | Subscription charge |
| status | varchar(10) | Null | Subscription status |
Table Name: subscription_tariff
| Column | Type | Data Type | Description |
| subscription_tariff_id | int(10) | Primary Key | Subscription tariff unique ID |
| designation_id | int(10) | Foreign Key | Designation unique ID |
| subscriptioncharge | float(10,2) | Null | Subscription charge |
Table Name: training_material
| Column | Type | Data Type | Description |
| training_material_id | int(10) | Primary Key | Training material unique ID |
| employee_id | int(10) | Foreign Key | Employee unique ID |
| Title | varchar(150) | Null | Training material title |
| training_category | varchar(25) | Null | Training material category |
| image_link | varchar(100) | Null | Training material image |
| video_link | varchar(100) | Null | Training material video |
| content | text | Null | Training material content |
| status | varchar(10) | Null | Training material status |
ER Diagram:
Leave a reply