Baserow Explanation
{{@672}}
It may be helpful to have Baserow open to follow along. For getting to Baserow: Accessing Baserow
1. Table Overview
Model 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.
Door_Style
Describes orientation of a door.
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.
Strike
Data used to describe a strike to the gcode creating software.
Material
Feed rate data for cutting each type of material.
Jamb
Data used to describe a jamb to the gcode creating software.
2. Table Explanations
In-depth look into the different tables. Describing what each of their columns do.
2.1 Model 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.
Slab
Which slab to use for a model. Lets you pick from created slabs in Slab.
Door_Style
Which Door_Style to use for a model. Lets you pick from created styles in Door_Style.
Location
Which location set to use for a model. Let's you pick from created location sets in Location.
Hinge
Which hinge to use for a model. Let's you pick from created hinges in Hinge.
Strike
Which strike to use for a model. Let's you pick from created strikes in in Strike.
Deadbolt
Which deadbolt to use for a model. Let's you pick from created strikes in Deadbolt.
Material
Which material to use for a model. Let's you pick from created materials in Material.
Jamb
Which jamb to use for a model. Let's you pick from created Jambs in Jamb.
2.2 Slab
Slab - The blank piece of wood from which the door is cut out of
Name
Unique identifier for a slab.
Nominal_Width
"Pretty" representation of the slabs actual width
Nominal_Height
"Pretty" representation of the slabs actual height
Actual_Width
Actual width of slab
Actual_Height
Actual height of slab
Jamb_Height
Actual height of jamb
Jamb_Width
Actual width of jamb
Mull_Height
Actual height of mull
Header_Width
Actual width of header
2.3 Door_Style
Notes:
- Door_Style, Swing, Handedness, Sidelites, Standard, Operating and
VentingVenting are all "cosmetic" values. They are not necessary for the gcode creating software but can be helpful for describing a door for other users.
Name
Unique identifier for a Door_Style.
Door_Type
Option selector for the door type.
Single - Single Door
Double - Double Door
Patio- Patio Door
Swing
Option selector for the door swing.
Inswing - Door swings in
Outswing - Door swings out
Handedness
Option selector for the handedness of the door.
RIght - Door swings in
Left - Door swings out
FL FL - Fixed/Left
LF - Left/Fixed
FR - Fixed/Right
RF - Right/Fixed
FFL - Fixed/Fixed/Left
FLF - Fixed/Left/Fixed
LFF - Left/Fixed/Fixed
FFR - Fixed/Fixed/Right
FRF - Fixed/Right/Fixed
RFF - Right/Fixed/Fixed
Sidelites
Option selector for which sidelites a door has.
Both - Sidelites on both sides of door
Right - Sidelite on right side of door
Left - Sidelite on left side of door
Standard
Option selector for which sidelites are standard.
Both - Both sidelites are standard
Right - Right sidelite is standard
Left - Left sidelite is standard
Operating
Option selector for which sidelites are operating.
Both - Both sidelites are operating
Right - Right sidelite is operating
Left - Left sidelite is operating
Venting
Option selector for which sidelites are venting.
Both - Both sidelites are venting
Right - Right sidelite is venting
Left - Left sidelite is venting
Left_Jamb
Describes what will be on the left jamb.
N - Jamb has nothing cut into it besides dados
H - Jamb has hinges and dados cut into jamb
S - Jamb has strikes and dados cut into jamb
Left_Jamb_Ref
Describes which side is the top of the jamb.
Left - Left side is the top
Right - Right side is top
Mull1
Describes what will be on Mull1.
HR - Hinge on right side of mull.
SR - Strike on right side of mull.
HL - Hinge on left side of mull.
SL - Strike on left side of mull.
VL/HR - Venting strikes on left side of jamb and hinge on right side of mull.
VL/SR - Venting strikes on left side of jamb and strike on right side of mull.
HL/VR VR - Hinge on left side of jamb and venting strikes on right side of mull.
SL/VR VR - Strike on left side of jamb and venting strikes on right side of mull.
Mull1_Ref
Describes which side is the top of the Mull2.
Left - Left side is the top
Right - Right side is top
Mull2
Describes what will be on Mull2.
HR - Hinge on right side of mull.
SR - Strike on right side of mull.
HL - Hinge on left side of mull.
SL - Strike on left side of mull.
VL/HR - Venting strikes on left side of mull and hinge on right side of mull.
VL/SR - Venting strikes on left side of mull and strike on right side of mull.
HL/VR VR - Hinge on left side of mull and venting strikes on right side of mull.
SL/VR VR - Strike on left side of mull and venting strikes on right side of mull
Mull2_Ref
Describes which side is the top of the mull2.
Left - Left side is the top
Right - Right side is top
Right_Jamb
Describes what will be on the right jamb.
N - Jamb has nothing cut into it besides dados
H - Jamb has hinges and dados cut into jamb
S - Jamb has strikes and dados cut into jamb
Right_Jamb_Ref
Describes which side is the top of the jamb.
Left - Left side is the top
Right - Right side is top
ADA
Describes if door uses ADA dados.
Standard - Door does not use ADA dados.
ADA - Door uses ADA dados.
2.4 Location
Name
Unique identifier for a location set.
Top_of_Door_to_Hinge_1
Distance from the top of the door to the top of the first hinge hinge
Top_of_Door_To_Hinge_2
Distance from the top of the door to the top of the second hinge hinge
Top_of_Door_To_Hinge_3
Distance from the top of the door to the top of the third hinge hinge
Top_of_Door_To_Hinge_4
Distance from the top of the door to the top of the fourth hinge hinge
Top_of_Door_To_Strike_Center
Distance from the top of the door to the middle of the strike
Top_of_Door_To_Deadbolt_Center
Distance from the top of the door to the middle of the deadbolt
Top_of_Door_to_Multi_Tongue_1
Distance from the top of the door to the middle of the multi point tongue 1
Top_of_Door_to_Multi_Tongue_2
Distance from the top of the door to the middle of the multi point tongue 2
Top_of_Door_to_Vent_1
Distance from the top of the door to the middle of vent 1
Top_of_Door_to_Vent_2
Distance from the top of the door to the middle of vent 2
Top_of_Door_to_Vent_3
Distance from the top of the door to the middle of vent 3
Jamb_Shift
(Not currently used)
Mull_Left
Distance from the left edge of the mull post to the center of the left mull slot
Mull_Right
Distance from the right edge of the mull post to the center of the right mull slot
Mull_Spread
Extra distance in between the two mull slots
Mull_Vent
Distance from the edge to the center of the mull vent slot
2.5 Hinge
Notes:
- X and Y origin is the center of the drawing
- # refers to any given drill or hole column number.
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].
Hinge_Depth
How far hinge is cut into jamb in the Z direction.
Hinge_Backset
Offset from jamb backstop to edge of hinge.
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 73 - High Speed Peck
81 81 - Straight Drilling
83 83 - Peck Drilling
99 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 Strike
Notes:
- X and Y origin is the center of the drawing
- # refers to any given drill or hole column.
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.
Drawing
An image file can be saved here for an easy visual reference for a lock.
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.
Face_Height
Height of strike (Distance across in Strike Y-Axis). See image.
Face_Width
Width of strike (Distance across in Strike X-Axis). See image.
Face_Corner_Radius
If [Face_Corner_Radius] is 0 then strike corners are 90°. Otherwise, creates rounded corners with a radius of [Face_Corner_Radius].
Face_Depth
How far strike is cut into the jamb in the Z direction.
Face_Overcut
Tells the gcode software to cut an overhang when cutting a strike.
Strike_Backset
Offset from jamb backstop to edge of strike.
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.
Pocket_Width#
Width of pocket (Distance across in pocket X-Axis).
Pocket_Height#
Height of pocket (Distance across in pocket Y-Axis).
Pocket_Corner_Radius#
If [Pocket_Corner_Radius] is 0 then pocket corners are 90°. Otherwise, creates rounded corners with a radius of [Pocket_Corner_Radius].
Pocket_Width_Depth#
How far pocket is cut into the jamb in the Z direction.
Pocket_Step_Down
Distance pocket will descend into door during each full revolution of pocket.
2.7 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.8 Jamb
Name
Unique identifier for a Jamb.
Jamb_Depth_Actual
Depth of jamb.
Mull_Depth_Actual
Depth of mull.
Jamb_Rabbet_Actual
Depth of jamb rabbet.
MULL_Rabbet_Actual
Depth of mull rabbet.