abcschool33
attendence_type
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| type | varchar(50) | Yes | NULL | |||
| key_value | varchar(50) | No | ||||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 6 | A | No |
books
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| book_title | varchar(100) | No | ||||
| book_no | varchar(50) | No | ||||
| isbn_no | varchar(100) | No | ||||
| subject | varchar(100) | Yes | NULL | |||
| rack_no | varchar(100) | No | ||||
| publish | varchar(100) | Yes | NULL | |||
| author | varchar(100) | Yes | NULL | |||
| qty | int(11) | Yes | NULL | |||
| perunitcost | float(10,2) | Yes | NULL | |||
| postdate | date | Yes | NULL | |||
| description | text | Yes | NULL | |||
| available | varchar(10) | Yes | yes | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1136 | A | No |
book_issues
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| book_id | int(11) | Yes | NULL | |||
| duereturn_date | date | Yes | NULL | |||
| return_date | date | Yes | NULL | |||
| issue_date | date | Yes | NULL | |||
| is_returned | int(11) | Yes | 0 | |||
| member_id | int(11) | Yes | NULL | |||
| is_active | varchar(10) | No | no | |||
| created_at | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
categories
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| category | varchar(100) | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7 | A | No |
certificates
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| certificate_name | varchar(100) | No | ||||
| certificate_text | text | No | ||||
| left_header | varchar(100) | No | ||||
| center_header | varchar(100) | No | ||||
| right_header | varchar(100) | No | ||||
| left_footer | varchar(100) | No | ||||
| right_footer | varchar(100) | No | ||||
| center_footer | varchar(100) | No | ||||
| background_image | varchar(100) | No | ||||
| created_at | timestamp | Yes | current_timestamp() | |||
| updated_at | date | Yes | NULL | |||
| created_for | tinyint(1) | No | 1 = staff, 2 = students | |||
| status | tinyint(1) | No | ||||
| header_height | int(11) | No | ||||
| content_height | int(11) | No | ||||
| footer_height | int(11) | No | ||||
| content_width | int(11) | No | ||||
| enable_student_image | tinyint(1) | No | 0=no,1=yes | |||
| enable_image_height | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
chat_messages
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| message | text | Yes | NULL | |||
| chat_user_id | int(11) | No | ||||
| ip | varchar(30) | No | ||||
| time | int(11) | No | ||||
| is_first | int(1) | Yes | 0 | |||
| is_read | int(1) | No | 0 | |||
| chat_connection_id | int(11) | No | ||||
| created_at | timestamp | No | current_timestamp() |
chat_users
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| user_type | varchar(20) | Yes | NULL | |||
| staff_id | int(11) | Yes | NULL | |||
| student_id | int(11) | Yes | NULL | |||
| create_staff_id | int(11) | Yes | NULL | |||
| create_student_id | int(11) | Yes | NULL | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
classes
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| class | varchar(60) | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
class_sections
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| class_id | int(11) | Yes | NULL | |||
| section_id | int(11) | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
class_teacher
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| class_id | int(11) | No | ||||
| staff_id | int(11) | No | ||||
| section_id | int(11) | No | ||||
| session_id | int(11) | No |
complaint
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| complaint_type | varchar(255) | No | ||||
| source | varchar(15) | No | ||||
| name | varchar(100) | No | ||||
| contact | varchar(15) | No | ||||
| varchar(200) | No | |||||
| date | date | No | ||||
| description | text | No | ||||
| action_taken | varchar(200) | No | ||||
| assigned | varchar(50) | No | ||||
| note | text | No | ||||
| image | varchar(100) | No |
complaint_type
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| complaint_type | varchar(100) | No | ||||
| description | mediumtext | No | ||||
| created_at | timestamp | No | current_timestamp() |
contents
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| title | varchar(100) | Yes | NULL | |||
| type | varchar(50) | Yes | NULL | |||
| is_public | varchar(10) | Yes | No | |||
| class_id | int(11) | Yes | NULL | |||
| cls_sec_id | int(10) | No | ||||
| file | varchar(250) | Yes | NULL | |||
| created_by | int(11) | No | ||||
| note | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL | |||
| date | date | No |
content_for
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| role | varchar(50) | Yes | NULL | |||
| content_id | int(11) | Yes | NULL | |||
| user_id | int(11) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() |
custom_fields
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(100) | Yes | NULL | |||
| belong_to | varchar(100) | Yes | NULL | |||
| type | varchar(100) | Yes | NULL | |||
| bs_column | int(10) | Yes | NULL | |||
| validation | int(11) | Yes | 0 | |||
| field_values | text | Yes | NULL | |||
| show_table | varchar(100) | Yes | NULL | |||
| visible_on_table | int(11) | No | ||||
| weight | int(11) | Yes | NULL | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
custom_field_values
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| belong_table_id | int(11) | Yes | NULL | |||
| custom_field_id | int(11) | Yes | NULL | |||
| field_value | longtext | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
department
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| department_name | varchar(200) | No | ||||
| is_active | varchar(100) | No |
disable_reason
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| reason | varchar(255) | No | ||||
| created_at | timestamp | No | current_timestamp() |
dispatch_receive
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| reference_no | varchar(50) | No | ||||
| to_title | varchar(100) | No | ||||
| address | varchar(500) | No | ||||
| note | varchar(500) | No | ||||
| from_title | varchar(200) | No | ||||
| date | varchar(20) | No | ||||
| image | varchar(100) | No | ||||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL | |||
| type | varchar(10) | No |
email_config
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| email_type | varchar(100) | Yes | NULL | |||
| smtp_server | varchar(100) | Yes | NULL | |||
| smtp_port | varchar(100) | Yes | NULL | |||
| smtp_username | varchar(100) | Yes | NULL | |||
| smtp_password | varchar(100) | Yes | NULL | |||
| ssl_tls | varchar(100) | Yes | NULL | |||
| is_active | varchar(10) | No | no | |||
| created_at | timestamp | No | current_timestamp() |
enquiry
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(100) | No | ||||
| contact | varchar(20) | No | ||||
| address | mediumtext | No | ||||
| reference | varchar(20) | No | ||||
| date | date | No | ||||
| description | varchar(500) | No | ||||
| follow_up_date | date | No | ||||
| note | mediumtext | No | ||||
| source | varchar(50) | No | ||||
| varchar(50) | Yes | NULL | ||||
| assigned | varchar(100) | No | ||||
| class | int(11) | No | ||||
| no_of_child | varchar(11) | Yes | NULL | |||
| status | varchar(100) | No |
enquiry_type
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| enquiry_type | varchar(100) | No | ||||
| description | mediumtext | No |
events
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| event_title | varchar(200) | No | ||||
| event_description | varchar(300) | No | ||||
| start_date | datetime | No | ||||
| end_date | datetime | No | ||||
| event_type | varchar(100) | No | ||||
| event_color | varchar(200) | No | ||||
| event_for | varchar(100) | No | ||||
| role_id | int(11) | No | ||||
| is_active | varchar(100) | No |
exams
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(200) | Yes | NULL | |||
| sesion_id | int(11) | No | ||||
| note | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
exam_groups
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(250) | Yes | NULL | |||
| exam_type | varchar(250) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| is_active | int(11) | Yes | 1 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
exam_group_class_batch_exams
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exam | varchar(250) | Yes | NULL | |||
| session_id | int(10) | No | ||||
| date_from | date | Yes | NULL | |||
| date_to | date | Yes | NULL | |||
| description | text | Yes | NULL | |||
| exam_group_id | int(11) | Yes | NULL | |||
| is_publish | int(1) | Yes | 0 | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
exam_group_class_batch_exam_students
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exam_group_class_batch_exam_id | int(11) | No | ||||
| student_id | int(11) | No | ||||
| student_session_id | int(11) | No | ||||
| roll_no | int(6) | No | 0 | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
exam_group_class_batch_exam_subjects
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exam_group_class_batch_exams_id | int(11) | Yes | NULL | |||
| subject_id | int(10) | No | ||||
| date_from | date | No | ||||
| time_from | time | No | ||||
| duration | varchar(50) | No | ||||
| room_no | varchar(100) | Yes | NULL | |||
| max_marks | float(10,2) | Yes | NULL | |||
| min_marks | float(10,2) | Yes | NULL | |||
| credit_hours | float(10,2) | Yes | 0.00 | |||
| date_to | datetime | Yes | NULL | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
exam_group_exam_connections
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exam_group_id | int(11) | Yes | NULL | |||
| exam_group_class_batch_exams_id | int(11) | Yes | NULL | |||
| exam_weightage | float(10,2) | Yes | 0.00 | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
exam_group_exam_results
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exam_group_class_batch_exam_student_id | int(11) | No | ||||
| exam_group_class_batch_exam_subject_id | int(11) | Yes | NULL | |||
| attendence | varchar(10) | Yes | NULL | |||
| get_marks | float(10,2) | Yes | 0.00 | |||
| note | text | Yes | NULL | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL | |||
| exam_group_student_id | int(11) | Yes | NULL |
exam_group_students
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exam_group_id | int(11) | Yes | NULL | |||
| student_id | int(11) | Yes | NULL | |||
| student_session_id | int(10) | Yes | NULL | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
exam_results
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| attendence | varchar(10) | No | ||||
| exam_schedule_id | int(11) | Yes | NULL | |||
| student_id | int(11) | Yes | NULL | |||
| get_marks | float(10,2) | Yes | NULL | |||
| note | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
exam_schedules
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| session_id | int(11) | No | ||||
| exam_id | int(11) | Yes | NULL | |||
| teacher_subject_id | int(11) | Yes | NULL | |||
| date_of_exam | date | Yes | NULL | |||
| start_to | varchar(50) | Yes | NULL | |||
| end_from | varchar(50) | Yes | NULL | |||
| room_no | varchar(50) | Yes | NULL | |||
| full_marks | int(11) | Yes | NULL | |||
| passing_marks | int(11) | Yes | NULL | |||
| note | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
expenses
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exp_head_id | int(11) | Yes | NULL | |||
| name | varchar(50) | Yes | NULL | |||
| invoice_no | varchar(200) | No | ||||
| date | date | Yes | NULL | |||
| amount | float(10,2) | Yes | NULL | |||
| documents | varchar(255) | Yes | NULL | |||
| note | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | yes | |||
| is_deleted | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
expense_head
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exp_category | varchar(50) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | yes | |||
| is_deleted | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
feecategory
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| category | varchar(50) | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
feemasters
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| session_id | int(11) | Yes | NULL | |||
| feetype_id | int(11) | No | ||||
| class_id | int(11) | Yes | NULL | |||
| amount | float(10,2) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
fees_discounts
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| session_id | int(11) | Yes | NULL | |||
| name | varchar(100) | Yes | NULL | |||
| code | varchar(100) | Yes | NULL | |||
| amount | decimal(10,2) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| is_active | varchar(10) | No | no | |||
| created_at | timestamp | No | current_timestamp() |
fees_reminder
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| reminder_type | varchar(10) | Yes | NULL | |||
| day | int(2) | Yes | NULL | |||
| is_active | int(1) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
feetype
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| is_system | int(1) | No | 0 | |||
| feecategory_id | int(11) | Yes | NULL | |||
| type | varchar(50) | Yes | NULL | |||
| code | varchar(100) | No | ||||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL | |||
| description | text | No |
fee_groups
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(200) | Yes | NULL | |||
| is_system | int(1) | No | 0 | |||
| description | text | Yes | NULL | |||
| is_active | varchar(10) | No | no | |||
| created_at | timestamp | No | current_timestamp() |
fee_groups_feetype
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| fee_session_group_id | int(11) | Yes | NULL | |||
| fee_groups_id | int(11) | Yes | NULL | |||
| feetype_id | int(11) | Yes | NULL | |||
| session_id | int(11) | Yes | NULL | |||
| amount | decimal(10,2) | Yes | NULL | |||
| fine_type | varchar(50) | No | none | |||
| due_date | date | Yes | NULL | |||
| fine_percentage | float(10,2) | No | 0.00 | |||
| fine_amount | float(10,2) | No | 0.00 | |||
| is_active | varchar(10) | No | no | |||
| created_at | timestamp | No | current_timestamp() |
fee_receipt_no
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| payment | int(11) | No |
fee_session_groups
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| fee_groups_id | int(11) | Yes | NULL | |||
| session_id | int(11) | Yes | NULL | |||
| is_active | varchar(10) | No | no | |||
| created_at | timestamp | No | current_timestamp() |
follow_up
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| enquiry_id | int(11) | No | ||||
| date | date | No | ||||
| next_date | date | No | ||||
| response | text | No | ||||
| note | text | No | ||||
| followup_by | varchar(200) | No |
front_cms_media_gallery
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| image | varchar(300) | Yes | NULL | |||
| thumb_path | varchar(300) | Yes | NULL | |||
| dir_path | varchar(300) | Yes | NULL | |||
| img_name | varchar(300) | Yes | NULL | |||
| thumb_name | varchar(300) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| file_type | varchar(100) | No | ||||
| file_size | varchar(100) | No | ||||
| vid_url | mediumtext | No | ||||
| vid_title | varchar(250) | No |
front_cms_menus
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| menu | varchar(100) | Yes | NULL | |||
| slug | varchar(200) | Yes | NULL | |||
| description | mediumtext | Yes | NULL | |||
| open_new_tab | int(10) | No | 0 | |||
| ext_url | mediumtext | No | ||||
| ext_url_link | mediumtext | No | ||||
| publish | int(11) | No | 0 | |||
| content_type | varchar(10) | No | manual | |||
| is_active | varchar(10) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() |
front_cms_menu_items
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| menu_id | int(11) | No | ||||
| menu | varchar(100) | Yes | NULL | |||
| page_id | int(11) | No | ||||
| parent_id | int(11) | No | ||||
| ext_url | mediumtext | Yes | NULL | |||
| open_new_tab | int(11) | Yes | 0 | |||
| ext_url_link | mediumtext | Yes | NULL | |||
| slug | varchar(200) | Yes | NULL | |||
| weight | int(11) | Yes | NULL | |||
| publish | int(11) | No | 0 | |||
| description | mediumtext | Yes | NULL | |||
| is_active | varchar(10) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() |
front_cms_pages
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| page_type | varchar(10) | No | manual | |||
| is_homepage | int(1) | Yes | 0 | |||
| title | varchar(250) | Yes | NULL | |||
| url | varchar(250) | Yes | NULL | |||
| type | varchar(50) | Yes | NULL | |||
| slug | varchar(200) | Yes | NULL | |||
| meta_title | mediumtext | Yes | NULL | |||
| meta_description | mediumtext | Yes | NULL | |||
| meta_keyword | mediumtext | Yes | NULL | |||
| feature_image | varchar(200) | No | ||||
| description | longtext | Yes | NULL | |||
| publish_date | date | No | ||||
| publish | int(10) | Yes | 0 | |||
| sidebar | int(10) | Yes | 0 | |||
| is_active | varchar(10) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() |
front_cms_page_contents
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| page_id | int(11) | Yes | NULL | |||
| content_type | varchar(50) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() |
front_cms_programs
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| type | varchar(50) | Yes | NULL | |||
| slug | varchar(255) | Yes | NULL | |||
| url | mediumtext | Yes | NULL | |||
| title | varchar(200) | Yes | NULL | |||
| date | date | Yes | NULL | |||
| event_start | date | Yes | NULL | |||
| event_end | date | Yes | NULL | |||
| event_venue | mediumtext | Yes | NULL | |||
| description | mediumtext | Yes | NULL | |||
| is_active | varchar(10) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| meta_title | mediumtext | No | ||||
| meta_description | mediumtext | No | ||||
| meta_keyword | mediumtext | No | ||||
| feature_image | mediumtext | No | ||||
| publish_date | date | No | ||||
| publish | varchar(10) | Yes | 0 | |||
| sidebar | int(10) | Yes | 0 |
front_cms_program_photos
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| program_id | int(11) | Yes | NULL | |||
| media_gallery_id | int(11) | No | ||||
| created_at | timestamp | No | current_timestamp() |
front_cms_settings
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| theme | varchar(50) | Yes | NULL | |||
| is_active_rtl | int(10) | Yes | 0 | |||
| is_active_front_cms | int(11) | Yes | 0 | |||
| is_active_sidebar | int(1) | Yes | 0 | |||
| logo | varchar(200) | Yes | NULL | |||
| contact_us_email | varchar(100) | Yes | NULL | |||
| complain_form_email | varchar(100) | Yes | NULL | |||
| sidebar_options | mediumtext | No | ||||
| fb_url | varchar(200) | No | ||||
| twitter_url | varchar(200) | No | ||||
| youtube_url | varchar(200) | No | ||||
| google_plus | varchar(200) | No | ||||
| instagram_url | varchar(200) | No | ||||
| pinterest_url | varchar(200) | No | ||||
| linkedin_url | varchar(200) | No | ||||
| google_analytics | mediumtext | Yes | NULL | |||
| footer_text | varchar(500) | Yes | NULL | |||
| fav_icon | varchar(250) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() |
general_calls
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(100) | No | ||||
| contact | varchar(12) | No | ||||
| date | date | No | ||||
| description | varchar(500) | No | ||||
| follow_up_date | date | No | ||||
| call_dureation | varchar(50) | No | ||||
| note | mediumtext | No | ||||
| call_type | varchar(20) | No |
grades
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exam_type | varchar(250) | Yes | NULL | |||
| name | varchar(100) | Yes | NULL | |||
| point | float(10,1) | Yes | NULL | |||
| mark_from | float(10,2) | Yes | NULL | |||
| mark_upto | float(10,2) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
homework
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| class_id | int(11) | No | ||||
| section_id | int(11) | No | ||||
| session_id | int(10) | No | ||||
| homework_date | date | No | ||||
| submit_date | date | No | ||||
| staff_id | int(11) | No | ||||
| subject_group_subject_id | int(11) | Yes | NULL | |||
| subject_id | int(11) | No | ||||
| description | varchar(500) | No | ||||
| create_date | date | No | ||||
| evaluation_date | date | No | ||||
| document | varchar(200) | No | ||||
| created_by | int(11) | No | ||||
| evaluated_by | int(11) | No |
homework_evaluation
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| homework_id | int(11) | No | ||||
| student_id | int(11) | No | ||||
| student_session_id | int(11) | Yes | NULL | |||
| date | date | No | ||||
| status | varchar(100) | No |
hostel
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| hostel_name | varchar(100) | Yes | NULL | |||
| type | varchar(50) | Yes | NULL | |||
| address | text | Yes | NULL | |||
| intake | int(11) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
hostel_rooms
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| hostel_id | int(11) | Yes | NULL | |||
| room_type_id | int(11) | Yes | NULL | |||
| room_no | varchar(200) | Yes | NULL | |||
| no_of_bed | int(11) | Yes | NULL | |||
| cost_per_bed | float(10,2) | Yes | 0.00 | |||
| title | varchar(200) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
id_card
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| title | varchar(100) | No | ||||
| school_name | varchar(100) | No | ||||
| school_address | varchar(500) | No | ||||
| background | varchar(100) | No | ||||
| logo | varchar(100) | No | ||||
| sign_image | varchar(100) | No | ||||
| header_color | varchar(100) | No | ||||
| enable_admission_no | tinyint(1) | No | 0=disable,1=enable | |||
| enable_student_name | tinyint(1) | No | 0=disable,1=enable | |||
| enable_class | tinyint(1) | No | 0=disable,1=enable | |||
| enable_fathers_name | tinyint(1) | No | 0=disable,1=enable | |||
| enable_mothers_name | tinyint(1) | No | 0=disable,1=enable | |||
| enable_address | tinyint(1) | No | 0=disable,1=enable | |||
| enable_phone | tinyint(1) | No | 0=disable,1=enable | |||
| enable_dob | tinyint(1) | No | 0=disable,1=enable | |||
| enable_blood_group | tinyint(1) | No | 0=disable,1=enable | |||
| status | tinyint(1) | No | 0=disable,1=enable |
income
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| inc_head_id | varchar(11) | Yes | NULL | |||
| name | varchar(50) | Yes | NULL | |||
| invoice_no | varchar(200) | No | ||||
| date | date | Yes | NULL | |||
| amount | float | Yes | NULL | |||
| note | text | Yes | NULL | |||
| is_active | varchar(255) | Yes | yes | |||
| is_deleted | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL | |||
| documents | varchar(255) | Yes | NULL |
income_head
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(255) | No | ||||
| income_category | varchar(255) | Yes | NULL | |||
| description | varchar(255) | Yes | NULL | |||
| is_active | varchar(255) | No | yes | |||
| is_deleted | varchar(255) | No | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
item
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| item_category_id | int(11) | Yes | NULL | |||
| name | varchar(255) | No | ||||
| unit | varchar(100) | No | ||||
| item_photo | varchar(225) | Yes | NULL | |||
| description | text | No | ||||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL | |||
| item_store_id | int(11) | Yes | NULL | |||
| item_supplier_id | int(11) | Yes | NULL | |||
| quantity | int(100) | No | ||||
| date | date | No |
item_category
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(255) | No | ||||
| item_category | varchar(255) | No | ||||
| is_active | varchar(255) | No | yes | |||
| description | varchar(255) | No | ||||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
item_issue
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| issue_type | varchar(15) | Yes | NULL | |||
| issue_to | varchar(100) | Yes | NULL | |||
| issue_by | varchar(100) | Yes | NULL | |||
| issue_date | date | Yes | NULL | |||
| return_date | date | Yes | NULL | |||
| item_category_id | int(11) | Yes | NULL | |||
| item_id | int(11) | Yes | NULL | |||
| quantity | int(10) | No | ||||
| note | text | No | ||||
| is_returned | int(2) | No | 1 | |||
| created_at | timestamp | No | current_timestamp() | |||
| is_active | varchar(10) | Yes | no |
item_stock
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| item_id | int(11) | Yes | NULL | |||
| supplier_id | int(11) | Yes | NULL | |||
| symbol | varchar(10) | No | + | |||
| store_id | int(11) | Yes | NULL | |||
| quantity | int(11) | Yes | NULL | |||
| purchase_price | varchar(100) | No | ||||
| date | date | No | ||||
| attachment | varchar(250) | Yes | NULL | |||
| description | text | No | ||||
| is_active | varchar(10) | Yes | yes | |||
| created_at | timestamp | No | current_timestamp() |
item_store
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(255) | No | ||||
| item_store | varchar(255) | No | ||||
| code | varchar(255) | No | ||||
| description | text | No |
item_supplier
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(255) | No | ||||
| item_supplier | varchar(255) | No | ||||
| phone | varchar(255) | No | ||||
| varchar(255) | No | |||||
| address | varchar(255) | No | ||||
| contact_person_name | varchar(255) | No | ||||
| contact_person_phone | varchar(255) | No | ||||
| contact_person_email | varchar(255) | No | ||||
| description | text | No |
languages
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| language | varchar(50) | Yes | NULL | |||
| short_code | varchar(255) | No | ||||
| country_code | varchar(255) | No | ||||
| is_deleted | varchar(10) | No | yes | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
leave_types
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| type | varchar(200) | No | ||||
| is_active | varchar(50) | No |
libarary_members
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| library_card_no | varchar(50) | Yes | NULL | |||
| member_type | varchar(50) | Yes | NULL | |||
| member_id | int(11) | Yes | NULL | |||
| is_active | varchar(10) | No | no | |||
| created_at | timestamp | No | current_timestamp() |
logs
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| message | text | Yes | NULL | |||
| record_id | int(11) | No | ||||
| user_id | int(11) | Yes | NULL | |||
| action | varchar(50) | Yes | NULL | |||
| ip_address | varchar(50) | Yes | NULL | |||
| platform | varchar(50) | Yes | NULL | |||
| agent | varchar(50) | Yes | NULL | |||
| time | timestamp | No | current_timestamp() | |||
| created_at | date | Yes | NULL |
messages
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| title | varchar(200) | Yes | NULL | |||
| message | text | Yes | NULL | |||
| send_mail | varchar(10) | Yes | 0 | |||
| send_sms | varchar(10) | Yes | 0 | |||
| is_group | varchar(10) | Yes | 0 | |||
| is_individual | varchar(10) | Yes | 0 | |||
| is_class | int(10) | No | 0 | |||
| group_list | text | Yes | NULL | |||
| user_list | text | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
migrations
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| version | bigint(20) | No |
multi_class_students
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| student_id | int(11) | Yes | NULL | |||
| student_session_id | int(11) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
notification_roles
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| send_notification_id | int(11) | Yes | NULL | |||
| role_id | int(11) | Yes | NULL | |||
| is_active | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() |
notification_setting
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| type | varchar(100) | Yes | NULL | |||
| is_mail | varchar(10) | Yes | 0 | |||
| is_sms | varchar(10) | Yes | 0 | |||
| is_notification | int(11) | No | 0 | |||
| display_notification | int(11) | No | 0 | |||
| template | longtext | No | ||||
| variables | text | No | ||||
| created_at | timestamp | No | current_timestamp() |
onlineexam
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| exam | text | Yes | NULL | |||
| attempt | int(11) | No | ||||
| exam_from | date | Yes | NULL | |||
| exam_to | date | Yes | NULL | |||
| time_from | time | Yes | NULL | |||
| time_to | time | Yes | NULL | |||
| duration | time | No | ||||
| passing_percentage | float | No | 0 | |||
| description | text | Yes | NULL | |||
| session_id | int(11) | Yes | NULL | |||
| publish_result | int(11) | No | 0 | |||
| is_active | varchar(1) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
onlineexam_attempts
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| onlineexam_student_id | int(11) | No | ||||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
onlineexam_questions
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| question_id | int(11) | Yes | NULL | |||
| onlineexam_id | int(11) | Yes | NULL | |||
| session_id | int(11) | Yes | NULL | |||
| is_active | varchar(1) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
onlineexam_students
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| onlineexam_id | int(11) | Yes | NULL | |||
| student_session_id | int(11) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
onlineexam_student_results
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| onlineexam_student_id | int(11) | No | ||||
| onlineexam_question_id | int(11) | No | ||||
| select_option | varchar(10) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
online_admissions
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| admission_no | varchar(100) | Yes | NULL | |||
| roll_no | varchar(100) | Yes | NULL | |||
| admission_date | date | Yes | NULL | |||
| firstname | varchar(100) | Yes | NULL | |||
| lastname | varchar(100) | Yes | NULL | |||
| rte | varchar(20) | No | No | |||
| image | varchar(100) | Yes | NULL | |||
| mobileno | varchar(100) | Yes | NULL | |||
| varchar(100) | Yes | NULL | ||||
| state | varchar(100) | Yes | NULL | |||
| city | varchar(100) | Yes | NULL | |||
| pincode | varchar(100) | Yes | NULL | |||
| religion | varchar(100) | Yes | NULL | |||
| cast | varchar(50) | No | ||||
| dob | date | Yes | NULL | |||
| gender | varchar(100) | Yes | NULL | |||
| current_address | text | Yes | NULL | |||
| permanent_address | text | Yes | NULL | |||
| category_id | int(11) | Yes | NULL | |||
| class_section_id | int(11) | Yes | NULL | |||
| route_id | int(11) | No | ||||
| school_house_id | int(11) | Yes | NULL | |||
| blood_group | varchar(200) | No | ||||
| vehroute_id | int(11) | No | ||||
| hostel_room_id | int(11) | No | ||||
| adhar_no | varchar(100) | Yes | NULL | |||
| samagra_id | varchar(100) | Yes | NULL | |||
| bank_account_no | varchar(100) | Yes | NULL | |||
| bank_name | varchar(100) | Yes | NULL | |||
| ifsc_code | varchar(100) | Yes | NULL | |||
| guardian_is | varchar(100) | No | ||||
| father_name | varchar(100) | Yes | NULL | |||
| father_phone | varchar(100) | Yes | NULL | |||
| father_occupation | varchar(100) | Yes | NULL | |||
| mother_name | varchar(100) | Yes | NULL | |||
| mother_phone | varchar(100) | Yes | NULL | |||
| mother_occupation | varchar(100) | Yes | NULL | |||
| guardian_name | varchar(100) | Yes | NULL | |||
| guardian_relation | varchar(100) | Yes | NULL | |||
| guardian_phone | varchar(100) | Yes | NULL | |||
| guardian_occupation | varchar(150) | No | ||||
| guardian_address | text | Yes | NULL | |||
| guardian_email | varchar(100) | No | ||||
| father_pic | varchar(200) | No | ||||
| mother_pic | varchar(200) | No | ||||
| guardian_pic | varchar(200) | No | ||||
| is_enroll | int(255) | Yes | 0 | |||
| previous_school | text | Yes | NULL | |||
| height | varchar(100) | No | ||||
| weight | varchar(100) | No | ||||
| note | varchar(200) | No | ||||
| measurement_date | date | Yes | NULL | |||
| app_key | text | Yes | NULL | |||
| document | text | Yes | NULL | |||
| disable_at | date | No | ||||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
payment_settings
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| payment_type | varchar(200) | No | ||||
| api_username | varchar(200) | Yes | NULL | |||
| api_secret_key | varchar(200) | No | ||||
| salt | varchar(200) | No | ||||
| api_publishable_key | varchar(200) | No | ||||
| api_password | varchar(200) | Yes | NULL | |||
| api_signature | varchar(200) | Yes | NULL | |||
| api_email | varchar(200) | Yes | NULL | |||
| paypal_demo | varchar(100) | No | ||||
| account_no | varchar(200) | No | ||||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
payslip_allowance
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| payslip_id | int(11) | No | ||||
| allowance_type | varchar(200) | No | ||||
| amount | int(11) | No | ||||
| staff_id | int(11) | No | ||||
| cal_type | varchar(100) | No |
permission_category
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| perm_group_id | int(11) | Yes | NULL | |||
| name | varchar(100) | Yes | NULL | |||
| short_code | varchar(100) | Yes | NULL | |||
| enable_view | int(11) | Yes | 0 | |||
| enable_add | int(11) | Yes | 0 | |||
| enable_edit | int(11) | Yes | 0 | |||
| enable_delete | int(11) | Yes | 0 | |||
| created_at | timestamp | No | current_timestamp() |
permission_group
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(100) | Yes | NULL | |||
| short_code | varchar(100) | No | ||||
| is_active | int(11) | Yes | 0 | |||
| system | int(11) | No | ||||
| created_at | timestamp | No | current_timestamp() |
permission_parent
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| group_id | int(11) | No | ||||
| name | varchar(100) | Yes | NULL | |||
| short_code | varchar(100) | No | ||||
| is_active | int(11) | Yes | 0 | |||
| system | int(11) | No | ||||
| created_at | timestamp | No | current_timestamp() |
permission_student
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(100) | Yes | NULL | |||
| short_code | varchar(100) | No | ||||
| is_active | int(11) | Yes | 0 | |||
| system | int(11) | No | ||||
| group_id | int(11) | No | ||||
| created_at | timestamp | No | current_timestamp() |
print_headerfooter
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| print_type | varchar(255) | No | ||||
| header_image | varchar(255) | No | ||||
| footer_content | text | No | ||||
| created_by | int(11) | No | ||||
| entry_date | timestamp | No | current_timestamp() |
questions
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| subject_id | int(11) | Yes | NULL | |||
| question | text | Yes | NULL | |||
| opt_a | text | Yes | NULL | |||
| opt_b | text | Yes | NULL | |||
| opt_c | text | Yes | NULL | |||
| opt_d | text | Yes | NULL | |||
| opt_e | text | Yes | NULL | |||
| correct | text | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
question_answers
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| question_id | int(11) | No | ||||
| option_id | int(11) | No | ||||
| created_at | timestamp | No | current_timestamp() |
question_options
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| question_id | int(11) | No | ||||
| option | text | No | ||||
| created_at | timestamp | No | current_timestamp() |
read_notification
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| student_id | int(11) | Yes | NULL | |||
| parent_id | int(10) | Yes | NULL | |||
| staff_id | int(11) | Yes | NULL | |||
| notification_id | int(11) | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
reference
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| reference | varchar(100) | No | ||||
| description | mediumtext | No |
roles
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(100) | Yes | NULL | |||
| slug | varchar(150) | Yes | NULL | |||
| is_active | int(11) | Yes | 0 | |||
| is_system | int(1) | No | 0 | |||
| is_superadmin | int(11) | No | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
roles_permissions
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| role_id | int(11) | Yes | NULL | |||
| perm_cat_id | int(11) | Yes | NULL | |||
| can_view | int(11) | Yes | NULL | |||
| can_add | int(11) | Yes | NULL | |||
| can_edit | int(11) | Yes | NULL | |||
| can_delete | int(11) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() |
room_types
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| room_type | varchar(200) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
school_houses
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| house_name | varchar(200) | No | ||||
| description | varchar(400) | No | ||||
| is_active | varchar(50) | No |
sch_settings
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| name | varchar(100) | Yes | NULL | |||
| biometric | int(11) | Yes | 0 | |||
| biometric_device | text | Yes | NULL | |||
| varchar(100) | Yes | NULL | ||||
| phone | varchar(50) | Yes | NULL | |||
| address | text | Yes | NULL | |||
| lang_id | int(11) | Yes | NULL | |||
| languages | varchar(500) | No | ||||
| dise_code | varchar(50) | Yes | NULL | |||
| date_format | varchar(50) | No | ||||
| time_format | varchar(255) | No | ||||
| currency | varchar(50) | No | ||||
| currency_symbol | varchar(50) | No | ||||
| is_rtl | varchar(10) | Yes | disabled | |||
| is_duplicate_fees_invoice | int(1) | Yes | 0 | |||
| timezone | varchar(30) | Yes | UTC | |||
| session_id | int(11) | Yes | NULL | |||
| cron_secret_key | varchar(100) | No | ||||
| currency_place | varchar(50) | No | before_number | |||
| class_teacher | varchar(100) | No | ||||
| start_month | varchar(40) | No | ||||
| attendence_type | int(10) | No | 0 | |||
| image | varchar(100) | Yes | NULL | |||
| admin_logo | varchar(255) | No | ||||
| admin_small_logo | varchar(255) | No | ||||
| theme | varchar(200) | No | default.jpg | |||
| fee_due_days | int(3) | Yes | 0 | |||
| adm_auto_insert | int(1) | No | 1 | |||
| adm_prefix | varchar(50) | No | ssadm19/20 | |||
| adm_start_from | varchar(11) | No | ||||
| adm_no_digit | int(10) | No | 6 | |||
| adm_update_status | int(11) | No | 0 | |||
| staffid_auto_insert | int(11) | No | 1 | |||
| staffid_prefix | varchar(100) | No | staffss/19/20 | |||
| staffid_start_from | varchar(50) | No | ||||
| staffid_no_digit | int(11) | No | 6 | |||
| staffid_update_status | int(11) | No | 0 | |||
| is_active | varchar(255) | Yes | no | |||
| online_admission | int(1) | Yes | 0 | |||
| is_blood_group | int(10) | No | 1 | |||
| is_student_house | int(10) | No | 1 | |||
| roll_no | int(11) | No | 1 | |||
| category | int(11) | No | ||||
| religion | int(11) | No | 1 | |||
| cast | int(11) | No | 1 | |||
| mobile_no | int(11) | No | 1 | |||
| student_email | int(11) | No | 1 | |||
| admission_date | int(11) | No | 1 | |||
| lastname | int(11) | No | ||||
| student_photo | int(11) | No | 1 | |||
| student_height | int(11) | No | 1 | |||
| student_weight | int(11) | No | 1 | |||
| measurement_date | int(11) | No | 1 | |||
| father_name | int(11) | No | 1 | |||
| father_phone | int(11) | No | 1 | |||
| father_occupation | int(11) | No | 1 | |||
| father_pic | int(11) | No | 1 | |||
| mother_name | int(11) | No | 1 | |||
| mother_phone | int(11) | No | 1 | |||
| mother_occupation | int(11) | No | 1 | |||
| mother_pic | int(11) | No | 1 | |||
| guardian_relation | int(11) | No | 1 | |||
| guardian_email | int(11) | No | 1 | |||
| guardian_pic | int(11) | No | 1 | |||
| guardian_address | int(11) | No | 1 | |||
| current_address | int(11) | No | 1 | |||
| permanent_address | int(11) | No | 1 | |||
| route_list | int(11) | No | 1 | |||
| hostel_id | int(11) | No | 1 | |||
| bank_account_no | int(11) | No | 1 | |||
| national_identification_no | int(11) | No | 1 | |||
| local_identification_no | int(11) | No | 1 | |||
| rte | int(11) | No | 1 | |||
| previous_school_details | int(11) | No | 1 | |||
| student_note | int(11) | No | 1 | |||
| upload_documents | int(11) | No | 1 | |||
| staff_designation | int(11) | No | 1 | |||
| staff_department | int(11) | No | 1 | |||
| staff_last_name | int(11) | No | 1 | |||
| staff_father_name | int(11) | No | 1 | |||
| staff_mother_name | int(11) | No | 1 | |||
| staff_date_of_joining | int(11) | No | 1 | |||
| staff_phone | int(11) | No | 1 | |||
| staff_emergency_contact | int(11) | No | 1 | |||
| staff_marital_status | int(11) | No | 1 | |||
| staff_photo | int(11) | No | 1 | |||
| staff_current_address | int(11) | No | 1 | |||
| staff_permanent_address | int(11) | No | 1 | |||
| staff_qualification | int(11) | No | 1 | |||
| staff_work_experience | int(11) | No | 1 | |||
| staff_note | int(11) | No | 1 | |||
| staff_epf_no | int(11) | No | 1 | |||
| staff_basic_salary | int(11) | No | 1 | |||
| staff_contract_type | int(11) | No | 1 | |||
| staff_work_shift | int(11) | No | 1 | |||
| staff_work_location | int(11) | No | 1 | |||
| staff_leaves | int(11) | No | 1 | |||
| staff_account_details | int(11) | No | 1 | |||
| staff_social_media | int(11) | No | 1 | |||
| staff_upload_documents | int(11) | No | 1 | |||
| mobile_api_url | tinytext | No | ||||
| app_primary_color_code | varchar(20) | Yes | NULL | |||
| app_secondary_color_code | varchar(20) | Yes | NULL | |||
| app_logo | varchar(250) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
sections
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| section | varchar(60) | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |
send_notification
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| title | varchar(50) | Yes | NULL | |||
| publish_date | date | Yes | NULL | |||
| date | date | Yes | NULL | |||
| message | text | Yes | NULL | |||
| visible_student | varchar(10) | No | no | |||
| visible_staff | varchar(10) | No | no | |||
| visible_parent | varchar(10) | No | no | |||
| created_by | varchar(60) | Yes | NULL | |||
| created_id | int(11) | Yes | NULL | |||
| is_active | varchar(255) | Yes | no | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | date | Yes | NULL |