project_extension


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
FOH_Wood_Base_Meas VARCHAR 10 √ null
jira_intake INT 10 √ null
pier_creation DATE 10 √ null
tech_package_paid BIT 1 √ null
term_lease DECIMAL 15,2 √ null
lea_term_def_fin DECIMAL 15,2 √ null
rent_red DECIMAL 15,2 √ null
upg_maint DECIMAL 15,2 √ null
cash_free_rent DECIMAL 15,2 √ null
lea_subs DECIMAL 15,2 √ null
mun_fines DECIMAL 15,2 √ null
fac_costs DECIMAL 15,2 √ null
est_com DECIMAL 15,2 √ null
asi_number VARCHAR 50 √ null
fact_id INT 10 √ null
agent_code VARCHAR 8 √ null
Leadership_Laptop VARCHAR 50 √ null
covid19_risk_notes VARCHAR 500 √ null
COVID19_Risk VARCHAR 10 √ null
vendor_arrival INT 10 √ null
P2_CR VARCHAR 50 √ null
sprint_decom BIT 1 √ null
dish_acceptance INT 10 √ null
P2_WRF VARCHAR 50 √ null
sprint_fixture VARCHAR 20 √ null
sign_upgrade_needed BIT 1 √ null
remodel_required BIT 1 √ null
renewal_decision INT 10 √ null
max_term INT 10 √ null
cr_number VARCHAR 50 √ null
box_count INT 10 √ null
integration BIT 1 √ null
ret_ref_sav DECIMAL 15,2 √ null
single_intake_ticket VARCHAR 10 √ null
wrf_ticket VARCHAR 10 √ null
wrf_date DATE 10 √ null
sit_date DATE 10 √ null
jira_date DATE 10 √ null
sign_removal_call DATETIME 19 √ null
sku_five VARCHAR 4 √ null
dish_insp_req BIT 1 √ null
dm_insp_opt VARCHAR 5 √ null
Dish_insp_appt DATETIME 19 √ null
priority INT 10 √ null
orig_clo_acc_bud DECIMAL 15,2 √ null
orig_lea_lia DECIMAL 15,2 √ null
orig_maint_clo_bud DECIMAL 15,2 √ null
term_fee DECIMAL 15,2 √ null
Unfor_cond_notes VARCHAR 1500 √ null
resp_part VARCHAR 50 √ null
network_exception BIT 1 √ null
network_exception_note VARCHAR 500 √ null
VARCHAR 255 √ null
ll_acc_req VARCHAR 5 √ null
TEXT 65535 √ null
ban_stm_notes TEXT 65535 √ null
ban_stm_damage BIT 1 √ b'0'
market_ospf VARCHAR 50 √ null
curr_media_an_perc_inc INT 10 √ null
renew_media_ann_perc_inc VARCHAR 10 √ null
optimization_closure1 VARCHAR 50 √ null
optimization_closure2 VARCHAR 50 √ null
optimization_closure3 VARCHAR 50 √ null
optimization_closure4 VARCHAR 50 √ null
optimization_closure5 VARCHAR 50 √ null
mt_rep_note TEXT 65535 √ null
plan_decom_notes TEXT 65535 √ null
plan_decom TEXT 65535 √ null
team_nw_notification BIT 1 √ b'0'
wfr_rt VARCHAR 50 √ null
loi_stat VARCHAR 15 √ null
srem_note TEXT 65535 √ null
serv_repair INT 10 √ null
cor_placed BIT 1 √ null
email_received BIT 1 √ null
granite_notified BIT 1 √ null
confirm_equip_delivered BIT 1 √ null
ip_information BIT 1 √ null
dafault_gateway BIT 1 √ null
cr_information_entered BIT 1 √ null
tia_inc_pef BIT 1 √ null
new_construction BIT 1 √ null
mop_email_eipt DATE 10 √ null
mop_received_printer DATE 10 √ null
mop_sequoyah DATE 10 √ null
jci_ip_information DATE 10 √ null
dhcp_information DATE 10 √ null
gr_pos DATE 10 √ null
CCX_ticket VARCHAR 35 √ null
signage_variance BIT 1 √ b'0'
YS_Ticket_Number VARCHAR 50 √ null
YS_Tracking_Numbers VARCHAR 160 √ null
Remodel_Due_Date_DC VARCHAR 50 √ null
Refresh_Due_Date_DC VARCHAR 50 √ null
decom_id VARCHAR 30 √ null
chg_req_num_fields VARCHAR 30 √ null
eng_equip_disposition VARCHAR 5 √ null
date_lck_sch INT 10 √ null
Termination_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
trailer_support INT 10 √ null
Rent_Inc_Cur_Rent DECIMAL 15,2 √ null
Rent_save_Cur_Rent_TOL DECIMAL 15,2 √ null
Rent_Cost_Avoid_opt_TOL DECIMAL 15,2 √ null
Cost_avoid_Short_TOL DECIMAL 15,2 √ null
lock_change_note TEXT 65535 √ null
Apple_Ship_To VARCHAR 50 √ null
Apple_Ship_to_Name VARCHAR 50 √ null
go_dark_right INT 10 √ null
pdf_moby VARCHAR 50 √ null
alt1 INT 10 √ 3
alt2 INT 10 √ 3
alt3 INT 10 √ 3
alt5 INT 10 √ 3
alt4 INT 10 √ 3
alt6 INT 10 √ 3
alt7 INT 10 √ 3
alt8 INT 10 √ 3
alt9 INT 10 √ 3
alt10 INT 10 √ 3
alt11 INT 10 √ 3
alt12 INT 10 √ 3
alt13 INT 10 √ 3
alt14 INT 10 √ 3
rt_circ_vend_asgnd VARCHAR 4 √ null
cir_risk VARCHAR 50 √ null
circ_rsk_note TEXT 65535 √ null
sec_needed VARCHAR 4 √ null
ll_roe_avail VARCHAR 50 √ null
suite_space_ver BIT 1 √ null
isp_survey_date DATE 10 √ null
isp_results_date DATE 10 √ null
decom_surrender_notes TEXT 65535 √ null
dev_wiz_ip VARCHAR 50 √ null
dev_wiz_sn VARCHAR 50 √ null
Sq_ft_boh INT 10 √ null
dsn_st_req DATE 10 √ null
pr_bl_no TEXT 65535 √ null
per_st_no TEXT 65535 √ null
pj_bl INT 10 √ null
npa_nxx VARCHAR 35 √ null
ref_ret_req_complete DATE 10 √ null
Tmo_corp_new_relo BIT 1 √ null
St_of_permit VARCHAR 50 √ null
Bld_per_req INT 10 √ null
Mech_per_req INT 10 √ null
Ele_permit_req INT 10 √ null
Energy_permit_req INT 10 √ null
Fire_sup_permit_req INT 10 √ null
Permit_rev_time VARCHAR 50 √ null
Pmt_rev_time VARCHAR 50 √ null
Pmt_sub_meth VARCHAR 50 √ null
LL_app_req INT 10 √ null
Wet_stamp_req INT 10 √ null
GC_info_req BIT 1 √ null
Situ_survey_ven_name VARCHAR 50 √ null
Situ_survey_ven_contact VARCHAR 50 √ null
Tmo_corp_remodel BIT 1 √ null
Tmo_corp_reb BIT 1 √ null
Tmo_tpr_new BIT 1 √ null
Tmo_tpr_rem BIT 1 √ null
Mbtm_corp_new_relo BIT 1 √ null
Mbtm_corp_rem BIT 1 √ null
Mbtm_dealer_ppr_rem BIT 1 √ null
Mbtm_dealer_exc_new_relo BIT 1 √ null
Mbtm_dealer_exc_rem BIT 1 √ null
Sket_mod INT 10 √ null
Test_fit INT 10 √ null
Design_intent_set INT 10 √ null
Non_per_cons_doc_set INT 10 √ null
Per_con_doc_set INT 10 √ null
Mep_sta_set INT 10 √ null
Building_info TEXT 65535 √ null
Plumbing_info TEXT 65535 √ null
Electric_info TEXT 65535 √ null
Engery_data TEXT 65535 √ null
Accessiblity_info TEXT 65535 √ null
Fire_info TEXT 65535 √ null
Ligh_up_req INT 10 √ null
Panel_up_req INT 10 √ null
Restrooom_ada INT 10 √ null
Boh_ada INT 10 √ null
LL_req_des INT 10 √ null
Mall_req_dsn INT 10 √ null
Mall_eff_dsn_notes TEXT 65535 √ null
Per_jur VARCHAR 50 √ null
name_of_contact VARCHAR 50 √ null
phone_number VARCHAR 50 √ null
Bld_dept_add VARCHAR 50 √ null
St_add VARCHAR 50 √ null
Mech_info TEXT 65535 √ null
MBTM_dealer_ppr_new_relo BIT 1 √ null
City_of_permit VARCHAR 50 √ null
Per_com_rec DATE 10 √ null
Per_re_sub_com DATE 10 √ null
Per_app DATE 10 √ null
Des_call_sch DATE 10 √ null
Des_kick_off DATE 10 √ null
Ske_up_mod_start DATE 10 √ null
test_fit_st DATE 10 √ null
Con_draw_start DATE 10 √ null
Dsn_proj_type VARCHAR 50 √ null
Sq_ft_retail INT 10 √ null
Sq_ft_total INT 10 √ null
W2E_Call DATETIME 19 √ null
Exist_bld_have_fire_alarm INT 10 √ null
Exist_bld_have_spr_sys INT 10 √ null
LL_eff_dsn_notes TEXT 65535 √ null
Plumb_per_req INT 10 √ null
Dsn_draw_val_DM DATE 10 √ null
Store_dsn_exe_form_val_dm DATE 10 √ null
Design_intent_set_start DATE 10 √ null
Dsn_Intent_set_sub DATE 10 √ null
Dsn_intent_set_app_dsn DATE 10 √ null
Does_gc_need_st_lic_to_pfm_work INT 10 √ null
Low_vol_pmt_req INT 10 √ null
Trailer_dep_app BIT 1 √ null
Per_cont_email VARCHAR 50 √ null
Add_Permit_req_note TEXT 65535 √ null
Permit_num VARCHAR 50 √ null
GC_or_sub_info_req_for_rev INT 10 √ null
GC_or_sub_info_req_for_permit INT 10 √ null
Sq_ft_acc INT 10 √ null
Con_draw_sub BIT 1 √ null
Ske_up_mod_com DATE 10 √ null
Sur_complete_anticipated DATE 10 √ null
Mkt_type_at_app VARCHAR 50 √ null
dt_ivr1700 DATE 10 √ null
Router_Ct_to_circ DATE 10 √ null
Dsn_intent_set_com_anti DATE 10 √ null
Can_test_fit_st BIT 1 √ null
Con_draw_com_ant DATE 10 √ null
Site_survey_pfd DATE 10 √ null
Site_survey_com_SDE DATE 10 √ null
Per_req VARCHAR 50 √ null
Test_fit_com_Ant DATE 10 √ null
cnnct_w_rtl BIT 1 √ null
W2E_Call_2 DATETIME 19 √ null
relo_type_req VARCHAR 50 √ null
actionable_realestate VARCHAR 50 √ null
relo_dest_siteid VARCHAR 50 √ null
relo_loi_status VARCHAR 50 √ null
relo_project_status VARCHAR 50 √ null
pro_open_date DATE 10 √ null
fnl_insp DATE 10 √ null
Con_permit_sub_anti DATE 10 √ null
Con_per_app_anti DATE 10 √ null
tia_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
fin_scenario_num VARCHAR 50 √ null
requestor VARCHAR 50 √ null
requestor_date DATE 10 √ null
Land_rack_clean_up_req BIT 1 √ null
Des_kick_not DATE 10 √ null
gap_relo BIT 1 √ null
temp_dibond_sign_installed DATE 10 √ null
pwu_permit BIT 1 √ b'0'
pb_responsibility VARCHAR 50 √ null
survey_performed_anticipated DATE 10 √ null
drawing_started DATE 10 √ null
drawing_started_acticipated DATE 10 √ null
Con_per_sub_sde DATE 10 √ null
cds_reviewed_design DATE 10 √ null
const_drawing_started_anti DATE 10 √ null
fixture_removal_needed BIT 1 √ null
test_fit_sub_ant DATE 10 √ null
sur_cei INT 10 √ null
sur_hvac INT 10 √ null
sign_perm_exp_dtd DATE 10 √ null
lv_vn_notes TEXT 65535 √ null
rem_1_sent INT 10 √ null
rem_2_sent INT 10 √ null
rem_3_sent INT 10 √ null
wft_ticket_com VARCHAR 150 √ null
wfr_date_clo DATE 10 √ null
repair_ticket TEXT 65535 √ null
Prj_init VARCHAR 50 √ null
comp3 VARCHAR 50 √ null
comp3_city VARCHAR 50 √ null
comp3_state VARCHAR 2 √ null
comp3_zip VARCHAR 10 √ null
Comp3_sqft VARCHAR 6 √ null
Comp3_rentpsf DECIMAL 15,2 √ null
Comp3_comparision VARCHAR 10 √ null
Comp_Vac3 VARCHAR 50 √ null
Compvac3_city VARCHAR 30 √ null
Compvac3_state VARCHAR 2 √ null
Compvac3_zip VARCHAR 10 √ null
Comp_Vac3_sqft VARCHAR 6 √ null
Comp_Vac3_rentpsf DECIMAL 15,2 √ null
Comp_Vac3_comparison VARCHAR 10 √ null
application_id INT 10 √ null
assignment INT 10 √ null
broadband_right INT 10 √ null
early_termination INT 10 √ null
roof_right INT 10 √ null
renewal_opt INT 10 √ null
sec_req VARCHAR 50 √ null
go_dark_have INT 10 √ null
go_dark_need INT 10 √ null
go_dark_obtained INT 10 √ null
roof_right_have INT 10 √ null
roof_right_need INT 10 √ null
roof_right_obtained INT 10 √ null
self_help_have INT 10 √ null
self_help_obtained INT 10 √ null
trade_name_have INT 10 √ null
trade_name_need INT 10 √ null
trade_name_obtained INT 10 √ null
permitted_use_have INT 10 √ null
permitted_use_need INT 10 √ null
permitted_use_obtained INT 10 √ null
renewal_opt_have INT 10 √ null
renewal_opt_need INT 10 √ null
renewal_opt_obtained INT 10 √ null
broadband_have INT 10 √ null
broadband_need INT 10 √ null
assignment_have INT 10 √ null
assignment_need INT 10 √ null
assignment_obtained INT 10 √ null
self_help_need INT 10 √ null
broadband_obtained INT 10 √ null
RDC_H_S BIT 1 b'0'
site_audit_performed BIT 1 √ null
audit_passed BIT 1 √ null
raod_notes LONGTEXT 2147483647 √ null
go_dark_le INT 10 √ null
pef_version INT 10 √ null
strategy_comment TEXT 65535 √ null
pef_tax_percent INT 10 √ null
pef_proj_descr TEXT 65535 √ null
pef_doc_assumptions TEXT 65535 √ null
pef_ll_work TEXT 65535 √ null
trade_area INT 10 √ null
store_position INT 10 √ null
comparable_rent INT 10 √ null
center_vacancy INT 10 √ null
landlord_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
target_term INT 10 √ null
target_base_rent DECIMAL 9,6 √ null
target_gross_rent DECIMAL 15,2 √ null
target_gross_rent_liability DECIMAL 15,2 √ null
target_tia_psf DECIMAL 15,2 √ null
renewal_opt_mth INT 10 √ null
renewal_base_rent DECIMAL 15,2 √ null
renewal_mth_gross_rent DECIMAL 15,2 √ null
renewal_annual_gross_rent DECIMAL 15,2 √ null
gross_rent_liability DECIMAL 15,2 √ null
renewal_opt_date DATE 10 √ null
current_term_mth INT 10 √ null
current_avg_base_rent DECIMAL 15,2 √ null
current_base_rent DECIMAL 15,2 √ null
current_gross_rent DECIMAL 15,2 √ null
current_exp_date DATE 10 √ null
early_term_right_have BIT 1 √ null
early_term_right_need BIT 1 √ null
co_tenancy_have BIT 1 √ null
co_tenancy_need BIT 1 √ null
exclusivity_have BIT 1 √ null
exclusivity_need BIT 1 √ null
ll_default_have BIT 1 √ null
ll_default_need BIT 1 √ null
relo_premises_have BIT 1 √ null
relo_premises_need BIT 1 √ null
tenant_breach_have BIT 1 √ null
tenant_breach_need BIT 1 √ null
signage_have BIT 1 √ null
signage_need BIT 1 √ null
monument_sign_have BIT 1 √ null
monument_sign_need BIT 1 √ null
trailer_have INT 10 √ null
trailer_need INT 10 √ null
comp_address VARCHAR 50 √ null
comp_tenant VARCHAR 50 √ null
comp_proximity DECIMAL 9,6 √ null
comp_trans_date DATE 10 √ null
comp_rent_psf DECIMAL 15,2 √ null
comp_sq_ft INT 10 √ null
comp2_address VARCHAR 50 √ null
comp2_tenant VARCHAR 50 √ null
comp2_proximity DECIMAL 9,6 √ null
comp2_trans_date DATE 10 √ null
comp2_rent_psf DECIMAL 15,2 √ null
comp2_sq_ft INT 10 √ null
comp3_address VARCHAR 50 √ null
comp3_tenant VARCHAR 50 √ null
comp3_proximity DECIMAL 9,6 √ null
comp3_trans_date DATE 10 √ null
comp3_rent_psf DECIMAL 15,2 √ null
comp3_sq_ft INT 10 √ null
comp_datasource INT 10 √ null
qc_rev_req BIT 1 √ b'0'
comp2_datasource INT 10 √ null
comp3_datasource INT 10 √ null
assignment_have_mva BIT 1 √ null
assignment_need_mva BIT 1 √ null
broadband_have_mva BIT 1 √ null
broadband_need_mva BIT 1 √ null
trade_name_have_mva BIT 1 √ null
trade_name_need_mva BIT 1 √ null
roof_right_have_mva BIT 1 √ null
roof_right_need_mva BIT 1 √ null
go_dark_have_mva BIT 1 √ null
go_dark_need_mva BIT 1 √ null
permitted_use_have_mva BIT 1 √ null
permitted_use_need_mva BIT 1 √ null
self_help_have_mva BIT 1 √ null
self_help_need_mva BIT 1 √ null
renewal_opt_have_mva BIT 1 √ null
renewal_opt_need_mva BIT 1 √ null
sec_risk_rank VARCHAR 50 √ null
cd_BI_r BIT 1 b'1'
cd_BP_r BIT 1 b'1'
cd_CO_r BIT 1 b'1'
cd_DCU_r BIT 1 b'1'
cd_DSF_r BIT 1 √ null
cd_EI_r BIT 1 b'1'
cd_EP_r BIT 1 b'1'
cd_ER_r BIT 1 √ null
cd_FAP_r BIT 1 √ null
cd_FI_r BIT 1 √ null
cd_FSP_r BIT 1 √ null
cd_HA_r BIT 1 b'1'
cd_LR_r BIT 1 b'1'
cd_MI_r BIT 1 b'1'
cd_MP_r BIT 1 b'1'
cd_NSD_r BIT 1 √ null
cd_PZI_r BIT 1 √ null
cd_PZP_r BIT 1 √ null
cd_PI_r BIT 1 b'1'
cd_PP_r BIT 1 b'1'
cd_PMW_r BIT 1 b'1'
cd_PWUP_r BIT 1 √ null
cd_PL_r BIT 1 b'1'
cd_RLD_r BIT 1 b'1'
cd_RTD_r BIT 1 √ null
cd_SLV_r BIT 1 b'1'
cd_SD_r BIT 1 b'1'
cd_SP_r BIT 1 b'1'
cd_SCI_r BIT 1 b'1'
cd_WL_r BIT 1 b'1'
cd_SPos_r BIT 1 √ null
rfi_d_d DATE 10 √ null
rfi_r VARCHAR 50 √ null
rfi_sn TEXT 65535 √ null
rfi_num VARCHAR 50 √ null
lease_term_mth INT 10 √ null
cc_whs INT 10 √ null
renewal_option_date_log DATE 10 √ null
ll_reim_event_date DATE 10 √ null
reimbursement_clause TEXT 65535 √ null
reimbursement_amt DECIMAL 15,2 √ null
invoice_attached BIT 1 √ null
tmo_payment_received_by INT 10 √ null
rent_abatement BIT 1 √ null
reimburse_date DATE 10 √ null
work_scope VARCHAR 150 √ null
fix_track_num VARCHAR 30 √ null
fix_carrier VARCHAR 30 √ null
truck_van_support BIT 1 √ null
truck_van_deployment BIT 1 √ null
tb_tik VARCHAR 50 √ null
tb_cre DATE 10 √ null
tb_ot VARCHAR 50 √ null
tb_oc VARCHAR 50 √ null
tb_ytdu VARCHAR 50 √ null
tb_dold VARCHAR 50 √ null
assignment_rights_srs INT 10 √ null
permit_use_clause_srs INT 10 √ null
first_refusal_right_srs INT 10 √ null
has_pylon_srs INT 10 √ null
esign_language_srs INT 10 √ null
facilities_reason VARCHAR 50 √ null
ach_epayment_srs INT 10 √ null
trailer_obtain INT 10 √ null
force_m_have INT 10 √ null
force_m_need INT 10 √ null
force_m_obtain INT 10 √ null
hvac_have INT 10 √ null
hvac_need INT 10 √ null
removal_have INT 10 √ null
removal_need INT 10 √ null
removal_obtain INT 10 √ null
hvac_obtain INT 10 √ null
EPIK INT 10 2
cr_no VARCHAR 50 √ null
equip_track VARCHAR 50 √ null
closing_poc_name VARCHAR 50 √ null
close_poc_cell VARCHAR 50 √ null
vend_tech_name VARCHAR 50 √ null
vend_tech_cell VARCHAR 50 √ null
open_poc_name VARCHAR 50 √ null
open_poc_cell VARCHAR 50 √ null
hvac_count INT 10 √ null
equip_track_con VARCHAR 50 √ null
sign_perm_time VARCHAR 50 √ null
sign_perm_note VARCHAR 50 √ null
option_letter_sig VARCHAR 80 √ null
permit_progress_notes TEXT 65535 √ null
sign_east_orientation INT 10 √ null
traffic_counter_status_id INT 10 √ null
top_right_trim_vertical_d2425 DECIMAL 9,6 √ null
top_left_trim_horizontal_d24d25 DECIMAL 9,6 √ null
top_center_trim_horizontal_d24d25 DECIMAL 9,6 √ null
top_right_trim_horizontal_d24d25 DECIMAL 9,6 √ null
bottom_left_trim_horizontal_d24d25 DECIMAL 9,6 √ null
bottom_center_trim_horizontal_d24d25 DECIMAL 9,6 √ null
bottom_right_trim_horizontal_d24d25 DECIMAL 9,6 √ null
top_left_trim_vertical_d24d25 DECIMAL 9,6 √ null
bottom_left_trim_vertical_d24d25 DECIMAL 9,6 √ null
top_left_plumb_d24_d25 DECIMAL 9,6 √ null
top_left_24_plumb_d24_d25 DECIMAL 9,6 √ null
top_center_48_plumb_d24_d25 DECIMAL 9,6 √ null
top_right_24_plumb_d24_d25 DECIMAL 9,6 √ null
top_right_plumb_d24_d25 DECIMAL 9,6 √ null
bottom_left_plumb_d24_d25 DECIMAL 9,6 √ null
bottom_left_24_plumb_d24_d25 DECIMAL 9,6 √ null
bottom_center_48_plumb_d24_d25 DECIMAL 9,6 √ null
bottom_right_24_plumb_d24_d25 DECIMAL 9,6 √ null
bottom_right_plumb_d24_d25 DECIMAL 9,6 √ null
top_left_trim_horizontal_d40 DECIMAL 9,6 √ null
top_center_trim_horizontal_d40 DECIMAL 9,6 √ null
top_right_trim_horizontal_d40 DECIMAL 9,6 √ null
bottom_left_trim_horizontal_d40 DECIMAL 9,6 √ null
bottom_center_horizontal_d40 DECIMAL 9,6 √ null
bottom_right_horizontal_d40 DECIMAL 9,6 √ null
left_trim_vertical_d40 DECIMAL 9,6 √ null
right_trim_vertical_d40 DECIMAL 9,6 √ null
left_vertical_plumb_d40 DECIMAL 9,6 √ null
center_vertical_plumb_d40 DECIMAL 9,6 √ null
right_vertical_plumb_d40 DECIMAL 9,6 √ null
top_left_trim_horizontal_d41 DECIMAL 9,6 √ null
top_center_trim_horizontal_d41 DECIMAL 9,6 √ null
top_right_trim_horizontal_d41 DECIMAL 9,6 √ null
bottom_left_trim_horizontal_d41 DECIMAL 9,6 √ null
bottom_center_horizontal_d41 DECIMAL 9,6 √ null
bottom_right_horizontal_d41 DECIMAL 9,6 √ null
left_trim_vertical_d41 DECIMAL 9,6 √ null
right_trim_vertical_d41 DECIMAL 9,6 √ null
left_vertical_plumb_d41 DECIMAL 9,6 √ null
center_vertical_plumb_d41 DECIMAL 9,6 √ null
right_vertical_plumb_d41 DECIMAL 9,6 √ null
top_left_trim_horizontal_d42 DECIMAL 9,6 √ null
top_center_trim_horizontal_d42 DECIMAL 9,6 √ null
top_right_trim_horizontal_d42 DECIMAL 9,6 √ null
bottom_left_trim_horizontal_d42 DECIMAL 9,6 √ null
bottom_center_horizontal_d42 DECIMAL 9,6 √ null
bottom_right_horizontal_d42 DECIMAL 9,6 √ null
left_trim_vertical_d42 DECIMAL 9,6 √ null
right_trim_vertical_d42 DECIMAL 9,6 √ null
left_vertical_plumb_d42 DECIMAL 9,6 √ null
center_vertical_plumb_d42 DECIMAL 9,6 √ null
right_vertical_plumb_d42 DECIMAL 9,6 √ null
top_left_trim_horizontal_d60_61_68_69 DECIMAL 9,6 √ null
top_right_trim_horizontal_d60_61_68_69 DECIMAL 9,6 √ null
bottom_left_trim_horizontal_d60_61_68_69 DECIMAL 9,6 √ null
bottom_right_horizontal_d60_61_68_69 DECIMAL 9,6 √ null
left_vertical_plumb_d60_61_68_69 DECIMAL 9,6 √ null
corner_left_vertical_plumb_d60_61_68_69 DECIMAL 9,6 √ null
right_vertical_plumb_d60_61_68_69 DECIMAL 9,6 √ null
corner_right_vertical_plumb_d60_61_68_69 DECIMAL 9,6 √ null
thin_clients TEXT 65535 √ null
mbtm_device_ship_address TEXT 65535 √ null
vsa_devices TEXT 65535 √ null
early_pot_term_dtd DATE 10 √ null
post_26_lease_liability DECIMAL 15,2 √ null
proj_description TEXT 65535 √ null
warranty_term VARCHAR 50 √ null
art_in_revision DATE 10 √ null
art_revision_uploaded DATE 10 √ null
mbf_installed BIT 1 √ null
mbf_serial_num VARCHAR 11 √ null
mbf_content_displayed BIT 1 √ null
mbf_issue_description TEXT 65535 √ null
mvds1_installed BIT 1 √ null
mvds1_serial_num VARCHAR 11 √ null
mvds1_content_displayed BIT 1 √ null
mvds1_issue_description TEXT 65535 √ null
mvds2_installed BIT 1 √ null
mvds2_serial_num VARCHAR 11 √ null
mvds2_content_displayed BIT 1 √ null
mvds2_issue_description TEXT 65535 √ null
truck_prio INT 10 √ null
ll_truck_stat INT 10 √ null
truck_license_agmt BIT 1 √ null
truck_license_cost TEXT 65535 √ null
truck_power_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
truck_power_details VARCHAR 80 √ null
truck_rr_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
truck_rr_details VARCHAR 300 √ null
truck_tent_tables BIT 1 √ null
truck_tent_table_details VARCHAR 50 √ null
truck_permit_details VARCHAR 50 √ null
truck_permit_decision INT 10 √ null
truck_bl_stat INT 10 √ null
truck_sap VARCHAR 4 √ null
truck_team_notes TEXT 65535 √ null
truck_resp INT 10 √ null
sch_ovr_appr BIT 1 √ null
truck_plan_rev_notes VARCHAR 500 √ null
truck_inspect_req BIT 1 √ null
truck_inspect_notes VARCHAR 80 √ null
truck_city_reqmts VARCHAR 80 √ null
ll_truck_reqmts VARCHAR 300 √ null
truck_inv_secured INT 10 √ null
truck_inv_location VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation