UserRightsAndStuff
ID, varchar2 UnixId, bool Abi, bool Thesis, bool StudyGroup, bool Fraternity,
 bool ForeignBasic, bool ForeignPost, varchar2 LastPageVisited.

--------

ViewAbi
ID, varchar2 UnixID, bool Attendees, bool Places, bool ReportGotten, bool OtherGrants,
 bool AppliedPerAttendee.

ViewThesis
ID, varchar2 UnixID, bool ThesisTimeDone, bool ThesisTimeLeft, bool Stations,
 bool WishedWeeks.

ViewStudyGroup
ID, varchar2 UnixID, bool FieldOfScience, bool EstimatedStudentCount, bool ReportGotten,
 boolean HoursTotal, bool TeachingType, bool SalaryTotal.

ViewFraternity
ID, varchar2 UnixID, bool OrgName, bool OrgFieldOfScience, bool RelationToStudies,
 bool Turnout, bool OtherGrants, bool AppliedPerAttendee, bool EstimatedExpense,
 bool AppliedAmount.

ViewForeignBasic
ID, varchar2 UnixID, bool Attendee, bool Nationality, bool CreditUnitsLastYear,
 bool CreditUnitsEstimated, bool EstimatedGraduationTime, bool ThesisState,
 bool ThesisTimeLeft, bool Recommendation1, bool Recommendation2.

ViewForeignPost
ID, varchar2 UnixID, bool Attendee, bool Nationality, bool CreditUnitsLastYear,
 bool TakesPostGraduateDegree, bool DegreeLeft, bool ResearchDone, bool Recommendation1,
 bool Recommendation2.

---------

Scholarship
ID, varchar2 Name, bool ForBasicStudent, bool ForPostStudent, bool CanApplyManyAtOneTime,
 bool CanGetMany, bool HasRecommendations.

ApplyingPeriod
ID, int ScholarshipID, Date BeginDate, Date EndDate, bool HasRecommendationsOn.

---------

ApplicationState
ID, varchar Name.

BiggestApplicationID (singleton)
int BiggestID.

Filler
ID, SecID ApplicationID,
 varchar2 FillerUnixId, varchar2 FillerStudentId, varchar2 FillerName, 
 varchar2 FillerEmail, varchar2 FillerPhoneNo,
  varchar2 FillerStreetAddress, varchar2 FillerPostNo, varchar2 FillerPostOffice,
  varchar2 FillerNationality.

---------

ApplicationAbi
ID, int ScholarshipID, int ApplyingPeriodID, int StateID, bool Signed, Date SignedDate,
varchar2 DeletedBy, Date DeletedDate,
  int HolderAmount, varchar2 FieldsOfStudy, varchar2 ReasonsForAbiAmount,
  varchar2 EventDescription, int OtherGrants,
   varchar2 ApplicantName, varchar2 ApplicantAccountNo.

Abi-info
 ID, SecID ApplicationAbiID, varchar2 Municipality, varchar2 Event, int AbiAmount.

RealizedAbi-info
 ID, SecID ApplicationAbiID, varchar2 Municipality, varchar2 Event, int AbiAmount.

Expenses
 ID, SecID ApplicationAbiID,
 int Transport, varchar2 TransportDescription, int Accommodation, int Eating,
 int Other, varchar2 OtherDescription.

RealizedExpenses
 ID, SecID ApplicationAbiID,
 int Transport, varchar2 TransportDescription, int Accommodation, int Eating,
 int Other, varchar2 OtherDescription.

---------

ApplicationThesis
ID, int ScholarshipID, int ApplyingPeriodID, int StateID, bool Signed, Date SignedDate,
varchar2 DeletedBy, Date DeletedDate,
  varchar2 Subject, Date BeginDate, Date EndDate, varchar2 ReasonsForGrant,
  Date WishedDate, int WishedLength,  varchar2 ReasonsForStations, varchar2 RecommendationId,
   varchar2 Station1, varchar2 Station2, varchar2 Station3, varchar2 Station4,
    varchar2 RecommenderName, bool AppllierGoodForGrant, bool RecommendationSigned.

ReportThesis
ID; SecID ApplicationThesisID,
 Date GrantUsedDate, varchar2 DescriptionOfWork, varchar2 PeriodSignificanceForThesis,
 varchar2 SuggestionsForDevelopment.

---------

ApplicationStudyGroup
ID, int ScholarshipID, int ApplyingPeriodID, int StateID, bool Signed, Date SignedDate,
varchar2 DeletedBy, Date DeletedDate,
  varchar2 ApplicantName, varchar2 ApplicantAccountNo,
   varchar2 Subject,  varchar2 FieldOfScience, varchar2 ReasonsForStudyGroup,
   int AttendeeAmount, varchar2 ReasonsForAmount.

TeachingHours
ID, SecID ApplicationStudyGroupID,
 int Pro, int Dos, int Toh, int Lis, int Mai, int Kan, int Yo, int Muu.

RealizedTeachingHours
ID, SecID ApplicationStudyGroupID,
 int Pro, int Dos, int Toh, int Lis, int Mai, int Kan, int Yo, int Muu.

TeachingSubjects
ID, SecID ApplicationStudyGroupID,
 varchar2 Subject, int Hours.

---------

ApplicationFraternity
ID, int ScholarshipID, int ApplyingPeriodID, int StateID, bool Signed, Date SignedDate,
varchar2 DeletedBy, Date DeletedDate,
  varchar2 ProjectName, varchar2 RelationToStudies, varchar2 Schedule,
  int AttendeeAmount, int OtherGrants

---------

ApplicationForeignBasic
ID, int ScholarshipID, int ApplyingPeriodID, int StateID, bool Signed, Date SignedDate,
varchar2 DeletedBy, Date DeletedDate,
  int PlannedCreditUnits, Date CraduationDate, int ThesisState, varchar2 RecommendationId1,
  varchar2 RecommendationId2,
   varchar2 ThesisName, Date ThesisBeginDate, Date ThesisEndDate.

RecommenderForeignBasic
ID, SecID ApplicationForeignBasicID,
 varchar2 Name,  varchar2 Appointment, varchar2 HowKnowsApplicant, bool HYEmployee, varchar2 UnixId.

ValuationForeignBasic
ID, SecID ApplicationForeignBasicID,
 int HasOtherGrants, int HasSalary, int StudyingSuccess, int StudyingFacility, int Activity,
 int Motivation, int WorkPlanning, int ResearchSignificance.
 
---------

ApplicationForeignPost
ID, int ScholarshipID, int ApplyingID, int StateID, bool Signed, Date SignedDate,
varchar2 DeletedBy, Date DeletedDate,
  bool PostGraduateDegree, varchar2 ResearchSubject, Date ResearchBeginDate,
  Date ResearchEndDate, varchar2 RecommendationId1, varchar2 RecommendationId2,

RecommenderForeignPost
ID, SecID ApplicationForeignPostID,
 varchar2 Name,  varchar2 Appointment, varchar2 HowKnowsApplicant, bool HYEmployee, varchar2 UnixId,
 varchar2 Company, varchar2 PhoneNo, varchar2 Email.

ValuationForeignPost
ID, SecID ApplicationForeignPostID,
 varchar2 Phase, varchar2 WorkSignificance, bool Publications, varchar2 PublicationsSignificance.