Final Filer Software

The free DBMS for cemeteries & crematoriums

Subscribe to newsletter...

The RegSearch Web Application has  a relatively simple database structure that could easily be used with data from any source, including direct manual data entry. The key is to understand the structure or schema. (you can grab the schema  SQL script here)

There are several tables used by the application

  • tblmaindata - contains the main detail of register and burial records
  • tblregisters - the descriptions of the registers that group burial and cremation records, like "My Cemetery's Burial Register". 
  • tblareas - contains records of areas in cemeteries etc, like "Lawn Cemetery" or "Anglican Cemetery"
  • tblportions - descriptions of portion names - portions are sub divisions on AREAS
  • tblerows - descriptions of the rows within portions
  • tblconfig - contains a single configuration record.
  • tblinforequest - used by the program - does not need any data

Additionally there is tbl_regimages, which is used for storing image files that can be displayed alongside the tblmaindata details.

If can import the data, perhaps from a spreadsheet or CSV file, using PHPmyadmin or similar. The order of importing should be to prepare and then import

  • tblregisters
  • tblareas
  • tblportions
  • tblrows
  • tblmain

The structure of each table is

Table structure for table tblregisters

Column

Type

Null

Default

Code

varchar(6)

Yes

0

Name

varchar(48)

No

 

website

text

Yes

NULL

Image_Test

text

Yes

NULL

Table structure for table tblareas

Column

Type

Null

Default

Code

varchar(6)

No

 

Name

varchar(255)

Yes

NULL

hideallocview

tinyint(4)

No

0

Table structure for table tblportions

Column

Type

Null

Default

Code

varchar(6)

No

0

Name

varchar(32)

No

 
       

Table structure for table tblrows

Column

Type

Null

Default

Code

varchar(6)

No

0

Name

varchar(32)

No

 

Table structure for table tblmaindata

Column

Type

Null

Default

ID

int(11)

No

 

Register

varchar(6)

No

Code links to tblregisters

AreaCode

varchar(6)

No

 Code link to tblareas

PortionCode

varchar(6)

No

 Code link to tblportions

RowCode

varchar(6)

No

 Code link to table Rows

IndexNumber

int(10)

No

0

FirstName

varchar(32)

No

 

LastName

varchar(32)

No

 

ServiceDate

date

No

0000-00-00

CommittalDate

datetime

Yes

NULL

Died

date

No

0000-00-00

Grave

int(5)

No

0

SubAlloc

char(2)

Yes

NULL

Aged

varchar(12)

Yes

NULL

Interment

tinyint(3)

No

0

Status

char(1)

Yes

NULL

serviceTime

time

Yes

NULL

url_fnotice

varchar(128)

Yes

NULL

url_obit

varchar(128)

Yes

NULL

url_remembrance

varchar(128)

Yes

NULL

Too daunting?

If you find all this too daunting or confusing I may be able to help, either by assisting with your data import or adapting the RegSearch Control Panel (CP) to your needs. .

 

 

 

 

 

 

Contribute!