Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

The database model structure for online job portal website, Schemes and Mind Maps of Database Programming

The database model structure for online job portal website

Typology: Schemes and Mind Maps

2023/2024

Uploaded on 02/19/2024

demo-demo-6
demo-demo-6 🇮🇳

1 document

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1

Partial preview of the text

Download The database model structure for online job portal website and more Schemes and Mind Maps Database Programming in PDF only on Docsity!

connectionid integer userid integer »—_ userid2 integer »—__ - connectiondate text status text iieger integer »—— receiverid content text timestamp text notificationid integer userid integer »—~ content text isread boolean timestamp text userid firsiname lastname email password usertype profileid integer »—— _-» profileid —— 4 userid companyname industry description contacinumber email website address companylogo headline summary location contacinumber email resume skills education experience certifications projects integer integer streamid streamname ——+ jobseekerid _— locationid integer jobpostid iterviewid applicationdate applicationid status interviewdate coverletter interviewtype videointroduction text interviewfeedback companyid integer ¢—_ streamid integer ~\ companyname text industry text description text contacinumber text email text website text foundedyear text text f locationname text joblocationid integer } jobpostid integer — 7 locationid integer »— —» jobpostid integer ¢— — 4 employerid integer / title text | description text | requirements text location text =a = reviewid integer Gateposted text —1 jobseekerid integer | deadline __ text employerid integer categoryid integer +——~ rating integer | isremote boolean comment dateposted applicationid integer integer text text text / \ imageid companyid imageurl jobtypeid typename _—» categoryid categoryname integer integer integer -—_ —p sl integer skiliname text integer jobposttypeid —« jobpostid Jobtypeid integer integer integer $< $a integer integer text integer