Table of contents
Media_with_Macros

• Tables
  • Adress
  • Author
  • Author_Add
  • Category
  • Class
  • Filter
  • Gender
  • Grade
  • Loan
  • Media
  • Mediastyle
  • Postcode
  • Preferences
  • Publisher
  • Reader
  • Recall
  • rel_Media_Author
  • rel_Reader_Schoolclass
  • Schoolclass
  • Search
  • Street
  • Subtitle
  • Town
  • View_EAN13_Labels
  • View_EAN13_Substring
  • View_Label_Media
  • View_Media_Charts
  • View_Media_complete
  • View_Media_Search_Result
  • View_MediaID_Title_Author
  • View_Recall_current
  • View_Reminder
  • View_Report_Recall
• Queries
  • Barcode_EAN13_ttf_Report
  • Current_Date
  • ISBN_Test
  • Listbox_Title_MediaID_not_loan
  • Loan_not_locked
  • Media_Chart
  • Media_Input_Search_Result
  • Media_Loan_Balance_Time
  • Media_Loan_Balance_Time_Recall
  • Media_Recall_Reader
  • Reader_Input_Filter
  • Recall_Recallnumber
• Forms
  • Loan
  • Loan_Barcode
  • Maintenance
  • Media
  • Reader_Admission
  • Recall
• Dialogs
  • Dialog_TableAdjustment
• Modules
  • AA_Variables
  • Backup
  • Comboboxes
  • Maintenance
  • Navigation
  • Print
  • Refreshing
• Missing items
• Index

List of fields by table

Table name	Field name	Field type	Precision	Primary key	Index #01	Index #02	Index #03	Index #04	Description	% not Null	Average	Most positive	Oldest date	Newest date	Longest string
Adress	Country	VARCHAR								100					2
	ID	INTEGER		✔		ASC				100		3
	No	VARCHAR								100					4
	Postcode_ID	INTEGER			ASC					100		6
	Street_ID	INTEGER					ASC			100		3
Author	FirstName	VARCHAR								100					9
	ID	INTEGER		✔						100		9
	LastName	VARCHAR								100					10
Author_Add	Author_Add	VARCHAR								100					12
	ID	INTEGER		✔						100		3
Category	Category	VARCHAR								100					12
	Description	VARCHAR								0
	ID	INTEGER		✔						100		2
Class	Class	VARCHAR								100					1
	ID	TINYINT		✔						100		8
Filter	Date	DATE								100			17/11/2012	17/11/2012
	Filter	VARCHAR								0
	ID	TINYINT		✔						100
	Integer	INTEGER								100		5
Gender	Gender	VARCHAR								100					6
	ID	TINYINT		✔						100		2
	Salutation	VARCHAR								100					4
	Title	VARCHAR								100					8
Grade	Grade	TINYINT								100		13
	ID	TINYINT		✔						100		13
Loan	Extension	TINYINT								19		2
	ID	INTEGER		✔						100		27
	Loan_Date	DATE								100			15/10/2011	17/11/2012
	Media_ID	INTEGER				ASC				100		8
	Media_ID_BC	INTEGER								0
	Reader_ID	INTEGER			ASC					100		9
	Return_Date	DATE								71			04/11/2011	17/11/2012
Media	Category_ID	INTEGER						ASC		44		2
	Comment	VARCHAR								0
	Edition	VARCHAR								33					25
	ID	INTEGER		✔						100		8
	ISBN	NUMERIC								44	2448247844453	9783937514505
	Mediastyle_ID	INTEGER					ASC			100		1
	Picture	VARBINARY								11
	Price	NUMERIC	2							78	18,03	39,9
	Pub_Year	SMALLINT								100		2009
	Publisher_ID	INTEGER				ASC				0
	Title	VARCHAR								100					35
	Town_ID	INTEGER			ASC					0
Mediastyle	ID	INTEGER		✔						100		2
	Loantime	TINYINT								100		14
	Mediastyle	VARCHAR								100					4
Postcode	ID	INTEGER		✔						100		6
	Postcode	VARCHAR								100					5
	Town_ID	INTEGER			ASC					100		2
Preferences	ExtensionDays	TINYINT								100		7
	ID	BOOLEAN		✔						100
	MinRecallDays	TINYINT								100		7
	OverdraftCharge	NUMERIC	2							100	0,25	0,25
	OverdraftDays	TINYINT								100		7
Publisher	ID	INTEGER		✔
	Publisher	VARCHAR
Reader	FirstName	VARCHAR								100					8
	Gender_ID	TINYINT			ASC					100		2
	ID	INTEGER		✔						100		9
	LastName	VARCHAR								100					14
	Lock	BOOLEAN								100
Recall	Date	DATE								100			20/11/2011	24/11/2012
	ID	INTEGER		✔						100		22
	Loan_ID	INTEGER			ASC					100		26
rel_Media_Author	Author_Add_ID	INTEGER					ASC			22		2
	Author_ID	INTEGER		✔		ASC				100		9
	Author_Sort	TINYINT							Sorting of Authors	100		3
	Media_ID	INTEGER		✔	ASC					100		8
rel_Reader_Schoolclass	ID	INTEGER		✔		ASC
	Schoolclass_ID	TINYINT			ASC
Schoolclass	Class_ID	TINYINT			ASC					100		1
	Grade_ID	TINYINT				ASC				100		13
	ID	TINYINT		✔						100		9
Search	ID	SMALLINT		✔						100
	SearchItem	VARCHAR								0
Street	ID	INTEGER		✔						100		3
	Street	VARCHAR								100					19
Subtitle	ID	INTEGER		✔						100		7
	Length	TIME								38			03:00:00	04:49:00
	Media_ID	INTEGER			ASC					100		8
	No	TINYINT								100		5
	Subtitle	VARCHAR								100					28
Town	ID	INTEGER		✔						100		3
	Town	VARCHAR								100					10
View_EAN13_Labels	Column_1	VARCHAR								100					13
	Column_2	VARCHAR								100					13
	Column_3	VARCHAR								100					13
View_EAN13_Substring	1_1	VARCHAR								100					1
	1_10	VARCHAR								100					1
	1_11	VARCHAR								100					1
	1_12	VARCHAR								100					1
	1_13	VARCHAR								100					1
	1_2	VARCHAR								100					1
	1_3	VARCHAR								100					1
	1_4	VARCHAR								100					1
	1_5	VARCHAR								100					1
	1_6	VARCHAR								100					1
	1_7	VARCHAR								100					1
	1_8	VARCHAR								100					1
	1_9	VARCHAR								100					1
	2_1	VARCHAR								100					1
	2_10	VARCHAR								100					1
	2_11	VARCHAR								100					1
	2_12	VARCHAR								100					1
	2_13	VARCHAR								100					1
	2_2	VARCHAR								100					1
	2_3	VARCHAR								100					1
	2_4	VARCHAR								100					1
	2_5	VARCHAR								100					1
	2_6	VARCHAR								100					1
	2_7	VARCHAR								100					1
	2_8	VARCHAR								100					1
	2_9	VARCHAR								100					1
	3_1	VARCHAR								100					1
	3_10	VARCHAR								100					1
	3_11	VARCHAR								100					1
	3_12	VARCHAR								100					1
	3_13	VARCHAR								100					1
	3_2	VARCHAR								100					1
	3_3	VARCHAR								100					1
	3_4	VARCHAR								100					1
	3_5	VARCHAR								100					1
	3_6	VARCHAR								100					1
	3_7	VARCHAR								100					1
	3_8	VARCHAR								100					1
	3_9	VARCHAR								100					1
View_Label_Media	Barcode_EAN13_ID	VARCHAR								100					2
	Count_3	INTEGER								100		2
	ID	INTEGER								100		8
	No	INTEGER								100		9
View_Media_Charts	Count	INTEGER								100		4
	Media_ID	DOUBLE								100	4	8
	Medium	VARCHAR								100					60
View_Media_complete	Author	VARCHAR								88					18
	Author_Add	VARCHAR								12					12
	Author_Sort	TINYINT								88		3
	Category	VARCHAR								59					12
	Comment	VARCHAR								0
	Description	VARCHAR								0
	Edition	VARCHAR								29					25
	ID	INTEGER								100		8
	Length	TIME								18			03:00:00	04:49:00
	Loantime	TINYINT								100		14
	Mediastyle	VARCHAR								100					4
	No	TINYINT								47		5
	Price	NUMERIC	2							76	18,29	39,9
	Pub_Year	SMALLINT								100		2009
	Publisher	VARCHAR								0
	Subtitle	VARCHAR								47					28
	Title	VARCHAR								100					35
	Town	VARCHAR								0
View_Media_Search_Result	ID	INTEGER								100		8
	Title	VARCHAR								100					35
View_MediaID_Title_Author	ID	INTEGER								100		8
	ID_Title_Author	VARCHAR								100					60
View_Recall_current	Loan_ID	INTEGER								100		26
	Recall_Count	INTEGER								100		1
	Recall_Date	DATE								100			24/11/2012	24/11/2012
View_Reminder	ID	INTEGER								100		27
	Reader_ID	INTEGER								100		9
	Today	DATE								100			21/08/2018	21/08/2018
View_Report_Recall	Adress	VARCHAR								100					56
	Charge	DOUBLE								100	82,25	82,5
	extended_for	BIGINT								100
	Extension	TINYINT								25		1
	LetterTitle	VARCHAR								100					16
	Loan_Date	DATE								100			04/04/2012	29/04/2012
	LoanDays	BIGINT								100
	Medium	VARCHAR								100					58
	Reader_ID	INTEGER								100		9
	Reader_Name	VARCHAR								100					15
	Recall_Count	INTEGER								100		1
	Recall_Date	DATE								100			24/11/2012	24/11/2012
	RemainTime	DOUBLE								100	2307	2316