Database Schema (Original) Outdated This is the original database design from early development. For the current schema, see Database Schema (Current). dsn~plantuml-database-model~1 Childid: numberfirst_name: stringmiddle_names: stringlast_name: stringbirthday: dateChildUserMappingchildid: number «FK»userid: number «FK»Userid: numberemail: stringname: stringaddress: textbirthday: datePassworduserid: number «FK»password: stringPinuserid: number «FK»pin: numberLocationid: numbername: stringaddress: textlocationlead: number //useridLocationDeviceid: numberlocationid: number «FK»deviceident: stringGroupid: numbername: stringlocationid: number «FK»grouplead: number «FK» //useridGroupTeachergroupid: number «FK»userid: number «FK»// must be role employee!GroupChildrengroupid: number «FK»childid: number «FK»Roleid: numbername: stringUserRoleroleid: number «FK»userid: number «FK»CareDayid: numberweekday: stringstart_time: floatend_time: floatlocationid: number «FK»groupid: number «FK»ChildCareDaycaredayid: number «FK»childid: number «FK»ChildStatuschildid: number «FK»status_msg: stringstatus: StatusStatusstatus_type: stringLetterReadletterid: number «Fk»userid: number «FK»ParentalLetterid: numbercreatedBy: number «FK» // user w/ employee roletext: textlocationid: number «FK» //for whole location?groupid: number «FK» // for groupMessageid: numbermessage: textcreatedBy: number «FK» // user w/ employee roleMessageRecipientsmessageid: number «FK»userid: number «FK»read: booleanresponse: text // ?Announcmentid: numbertitle: stringtext: textcreatedBy: number «Fk»publishDate: datetimeremoveDate: datetimeremoveWhenRead: booleanAnnouncmentReadannouncementid: number «FK»userid: number «FK»read: booleanresponse: text // ?Documentid: numberpath: textpublishDate: datetimeremoveDate: datetimecreatedBy: number «FK»BlackboardDocument//see DocumentPermissionsroleid: number «FK»// permission columns: booleanuseridroleid Needs: impl, utest, itest Covers: req~datenbank-modell~1