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

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