Baserow Explanation

Table Overview

Quick explanation of the contents of the tables

Model

This is where user created door models live. They are viewed/edited/created here. This tables uses the data found in the other tables for a simple model creating process. An explanation for how to make a model can be found here: Creating A Model

Slab

Describes door slabs using height and width.

Material

Feed rate data for cutting each type of material.

Location

Data on where to place hinges/strikes, how many hinges and hinge thickness.

Hinge

Hinge data used to describe a hinge to gcode creating software.

Lock

Lock data used to describe a lock to gcode creating software.

Latch

Latch data used to describe a latch to gcode creating software.

Panic

Panic data used to describe a panic to gcode creating software.

Hole_Pattern

Repeated hole patterns found in locks to be used in Lock.

Table Explanations

In-depth look into the different tables. Describing what each of their columns do.

Model

Name

Unique identifier for a door model.

Barcode_Name

Optional name for a door model that can be turned into a barcode. This name should follow standard barcode. conventions.

Description

Short description describing the door model.

Swing

Option selector for each type of door swing. The only part that matters for machine operation is that all right hand doors are referenced from the bottom instead of the top.

LH - Left Hand

RH - Right Hand

RHR - Right Hand Reverse

LHR - Left Hand Reverse

LHI - Left Hand Inactive

RHA - Right Hand Active

RHRA - Right Hand Reverse Active

ERHRI - Egress Right Hand Reverse Inactive

ELHRA - Egress Left Hand Reverse Active

Slab

Which slab to use for a model. Lets you pick from created slabs in Slab.

Panic

Which panic to use for a model. Let's you pick from created panics in Panic.

Panic_CL

How far the panic device center line will be from the top of the door. Only needed if a panic device is selected.

Location_Set

Which location set to use for a model. Let's you pick from created location sets in Location_Set.

Hinge

Which hinge to use for a model. Let's you pick from created hinges in Hinge.

Lock

Which lock to use for a model. Let's you pick from created locks in Lock.

Material

Which material to use for a model. Let's you pick from created materials in Material.

Notes

Any notes about a model can be written here.

Slab

Slab - The blank piece of wood from which the door is cut out of

Name

Unique identifier for a slab.

Width_Nominal

"Pretty" representation of the slabs actual width

Height_Nominal

"Pretty" representation of the slabs actual height

Width_Actual

Actual width of slab

Height_Actual

Actual height of slab

Material

Name

Unique identifier for a material.

Feed

Decimal between 0-1 representing a percent factor on the feed rate when cutting.

Plunge_Feed

Decimal between 0-1 representing a percent factor on the feed rate when plunging.

Lock_Feed

Decimal between 0-1 representing a percent factor on the feed rate when cutting the lock.

Lock_Plunge_Feed

Decimal between 0-1 representing a percent factor on the feed rate when plunging the lock.

Thickness

Thickness of material

Cut_Spindle_Speed

Decimal between 0-1 representing a percent factor on the spindle speed.

Location

Name

Unique identifier for a location set.

Hinge_Size

Height of hinge to be used with location set(UNUSED)

Hinge_Backset

Distance of hinge from edge of door

Hinge_Thickness

Distance hinge is cut into door

Top_of_Door_to_Hinge_1

Distance from the top of the door to the top of the first hinge

Top_of_Door_To_Hinge_2

Distance from the top of the door to the top of the second hinge

Top_of_Door_To_Hinge_3

Distance from the top of the door to the top of the third hinge

Top_of_Door_To_Hinge_4

Distance from the top of the door to the top of the fourth hinge

Top_of_Door_To_Hinge_Strike

Distance from the top of the door to the middle of the strike

Hinge

Name

Unique identifier for a hinge model

GCode

If a gcode file is inserted here, that gcode will be used to cut the hinge instead of using the hinge data found in the Hinge table.

Width

Width of hinge

Height

Height of hinge

Corner_Radius

If [Corner_Radius] is 0 then corners are 90°. Otherwise, creates corners with a radius of entered size

Drawing

An image file can be saved here for an easy visual reference for a hinge.

Face

An options select for which side of the door the hinge will be cut on. This should always be "Right" for hinges.

Clearance

An easy way to add "slop" to a hinge. If [Clearance] is 0, hinge will be cut exactly to size specified. If [Clearance] > 0, height and width of hinge will be larger by [Clearance].

Subroutine

If [Subroutine] is any value other than -1, [Subroutine] will be called as a subroutine in gcode to cut hinge instead of using data found in Hinge.

Drill_Type

Option selector for which type of drill command to use. Should always be "99" unless it is known a different drill type should be used.

73 - High Speed Peck

81 - Straight Drilling

83 - Peck Drilling

99 - Retract Drilling

Drill_#_X

X location of # drill inside of hinge. See image

Drill_#_Y

Y location of # drill inside of hinge. See image

Drill_Depth

Distance drill will plunge into door

Drill_Retract

Distance drill will retract out of material. 0 would be flush with side of door.

Drill_Peck

Distance drill will "Peck" into material if using peck drilling.

Drill_Dia

When Drill_Dia is blank all drills for hinge will be drilled. Otherwise, all drills for a hinge will be bored out with a diameter of [Drill_Dia].

Bore_X#

X location of bore # inside of hinge. See image

Bore_Y#

Y location of bore # inside of hinge. See image

Bore_Depth#

Depth of bore # inside of hinge. See image

Bore_Dia#

Diameter of bore # inside of hinge. See image

Bore_Step_Down

Distance bore will descend into door during each full revolution of bore.

Lock

Name

Unique identifier for a lock model.

GCode

If a gcode file is inserted here, that gcode will be used to cut the lock instead of using the lock data found in the Lock table.

Lock_Center

Distance from edge of door to center of lock. See image.

Mill_Both_Sides

Keeps track if it is required that a machine be required to be able to mill on both sides of a door to cut a lock.

Latch

Which latch to use for a lock. Let's you pick from created latches in Latch.

Latch_GCode

See GCode in Latch.

Latch_Sub

See Subroutine in Latch.

Face

An options select for which side of the door the lock will be cut on. This should always be "Front" for locks.

Clearance

An easy way to add "slop" to a lock. If [Clearance] is 0, lock will be cut exactly to size specified. If [Clearance] > 0, height and width of lock will be larger by [Clearance].

Subroutine

If [Subroutine] is any value other than -1, [Subroutine] will be called as a subroutine in gcode to cut lock instead of using data found in Lock.