Baserow Explanation

It may be helpful to have Baserow open to follow along. For getting to Baserow: Accessing Baserow

1. Table Overview

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 in Baserow

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

Data used to describe a hinge to the gcode creating software.

Lock

Data used to describe a lock to the gcode creating software.

Latch

Data used to describe a latch to the gcode creating software.

Panic

Data used to describe a panic to the gcode creating software.

Hole_Pattern

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

2. Table Explanations

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

2.1 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.

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.

2.2 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

2.3 Material

Material - What the slab is made out of

Name

Unique identifier for a material.

Feed

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

Plunge_Feed

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

Lock_Feed

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

Lock_Plunge_Feed

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

Thickness

Thickness of material

Cut_Spindle_Speed

Decimal between 0-1 representing a percent factor on the spindle speed. Ex: .75 = 75

2.4 Location

Name

Unique identifier for a location set.

Hinge_Size

Height of hinge to be used with location set

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_Strike

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

2.5 Hinge

Notes:

• X and Y origin is the center of the drawing
• # refers to any given drill or hole column number.  EX: Drill_#_X(Drill _1_X, Drill_2_X, Drill_3_X, Drill_4_X)

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 Hinge table.

Width

Width of hinge (Distance across in Hinge Y-Axis). See image.

Height

Height of hinge (Distance across in Hinge X-Axis). See image.

Corner_Radius

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

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.

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.

2.6 Lock

Notes:

• X and Y origin is the center of the drawing
• # refers to any given drill or hole column.  EX: Drill_#_X(Drill _1_X, Drill_2_X, Drill_3_X, Drill_4_X)

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 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.

Drawing

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

Patterns

Lock hole patterns from Hole_Pattern can be selected.

Hole_X#

X location of hole # inside of lock. See image

Hole_Y#

Y location of hole # inside of lock. See image

Hole_Dia#

If [Hole_Dia#] isn't empty, # hole will be bored with a diameter of [Hole_Dia#]. See image.

Hole_Depth#

Distance hole is cut into door.

Bore_Step_Down

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

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_Retract

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

Drill_Peck

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

Notes

Any notes about a model can be written here.

2.7 Latch

Notes:

• X and Y origin is the center of the drawing
• # refers to any given drill or hole column.  EX: Drill_#_X(Drill _1_X, Drill_2_X, Drill_3_X, Drill_4_X)

Name

Unique identifier for a latch model.

GCode

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

Drawing

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

Face

An option select for which side of the door the latch will be cut on. This should always be "Left" for latches.

Clearance

An easy way to add "slop" to a latch. If [Clearance] is 0, latch will be cut exactly to size specified. If [Clearance] > 0, height and width of latch 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 latch instead of using data found in Latch.

Face_Height

Height of latch face. See image.

Face_Width

Width of latch face. See image.

Face_Corner_Radius

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

Face_Depth

Distance latch face is cut into door. See image.

Bore#_x

X location of bore inside of latch. See image.

Bore#_y

Y location of bore inside of latch. See image.

Bore#_Dia

Diameter of bore inside of latch. See image.

Bore#_Depth

Distance bore plunges into latch.

Bore_Step_Down

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

Pocket_Width

Width of latch pocket. See image. If blank no pocket will be cut. 

Pocket_Height

Height of latch pocket. See image. If blank no pocket will be cut. 

Pocket_Corner_Radius

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

Pocket_Depth

Distance pocket face is cut into door. See image.

Pocket_Step_Down

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

2.8 Panic

Name

Unique identifier for a panic model.

GCode

A gcode file is inserted here to be used in gcode creating process.

Backset

Distance from side of door to center of panic device.

Drawing

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

Face

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

Subroutine

If [Subroutine] is any value other than -1, [Subroutine] will be called as a subroutine in gcode to cut a panic device instead of using GCode found in Panic.

2.9 Hole_Pattern

Notes:

• X and Y origin is the center of the drawing
• # refers to any given drill or hole column.  EX: Drill_#_X(Drill _1_X, Drill_2_X, Drill_3_X, Drill_4_X)

Name

Unique identifier for a hole pattern.

Hole_#X

X location of a hole inside of a pattern. See image.

Hole_#Y

Y location of a hole inside of a pattern. See image.

Hole_#Dia

Diameter of a hole inside of a pattern. See image.

Hole_#Depth

Distance bore plunges into door.

Notes

Any notes about a model can be written here.