5. Robotframework Historic Tables

Robotframework-Historic consist of following Database & Tables

---

Default Database & Table

Database
	robothistoric

Table
	TB_PROJECT

Columns		
	Project_Id	     INT NOT NULL auto_increment primary key
	Project_Name	     TEXT
	Project_Desc	     TEXT
	Project_Image	     TEXT
	Created_Date	     DATETIME
	Last_Updated	     DATETIME
	Total_Executions     INT
	Recent_Pass_Perc     FLOAT
	Overall_Pass_Perc    FLOAT

Project Database & Table

• When new project is created new database is created and database info is stored in robothistoric.TB_PROJECT table.
• Following tables will be created in newly added database (project)

Database

Database		
	<Project-Name>

Execution

Table
	TB_EXECUTION

Columns		
	Execution_Id	    INT NOT NULL auto_increment primary key
	Execution_Date      DATETIME
	Execution_Desc      TEXT
	Execution_Total     INT
	Execution_Pass      INT
	Execution_Fail      INT
	Execution_Time      FLOAT
	Execution_STotal    INT
	Execution_SPass     INT
	Execution_SFail     INT
        Execution_Skip      INT
        Execution_SSkip     INT

Suite

Table
	TB_SUITE
		
Columns		
	Suite_Id	INT NOT NULL auto_increment primary key
	Execution_Id	INT
	Suite_Name	TEXT
	Suite_Status	CHAR(4)
	Suite_Total	INT
	Suite_Pass	INT
	Suite_Fail	INT
	Suite_Time	FLOAT
        Suite_Skip      INT

Test

Table		
	TB_TEST

Columns
	Test_Id	            INT NOT NULL auto_increment primary key
	Execution_Id	    INT
	Test_Name	    TEXT
	Test_Status	    CHAR(4)
	Test_Time	    FLOAT
	Test_Error	    TEXT
	Test_Comment	    TEXT
        Test_Assigned_To    TEXT
        Test_ETA            TEXT
        Test_Review_By      TEXT
        Test_Issue_Type     TEXT
        Test_Tag            TEXT
        Test_Updated        DATETIME