project


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
dealer_request.project_id fk_project_id R
iterative_note.project_id FK_qdblridchgeunqrt31hihha4e R
ivueit_survey_request.project_id FK_survey_request_project_id R
legal.project_id FK62162B9FE2B983 R
manual_task.project_id fk_manual_task_project_idx R
project_company.project_id FKA9FB0557FE2B983 R
project_company_contact.project_id FKFDAE8938FE2B983 R
project_contact.project_id FKAA0AECFAFE2B983 R
project_data.id FK_project_data_project C
project_field_pending_change_request.project_id FK_project_field_pending_change_project R
project_fixtures.project_id FKA2AA99F0FE2B983 R
project_folder.project_id FK235FD054FE2B983 R
project_log.project_id FKC7FFE91EFE2B983 R
project_message.project_id FKAA3EC8E1FE2B983 R
project_milestone.project_id FK2C0913CAFE2B983 R
project_note.project_id FK37FE2558FE2B983 R
project_plg.project_id FK_plg_project_project R
project_support.project_id FK2C648A9FE2B983 R
punch_list_item.project_id FKDB8A3043FE2B983 R
site.last_modified_project_id FK_2wtpkmhjialxvhfvg3hbcb5da R
site_file.project_id FK_i26ess8cryx0ii6dyvju3dj8q R
sitepack.project_id FK284B45E0FE2B983 R
sitepack_security.project_id FKC5CCFEBFFE2B983 R
srs_report.project_id FK_qg9vau940gidw6u0fpa7qywgj R
survey_response.project_id FK_21y6p4me43e8qeguo8o7fljv9 R
vendor_task.project_id FK_oxh2fxj4n3cyx3a0wwaes86o7 R
workflow.project_id FK21BD7BFFE2B983 R
site_id INT 10 null
open_date_weekly_report_cr.site_id FKC7FFE91EFE2B9836 R
site.id FK_dtydefwc4byv5kfrx2hbh4bgc R
iteration INT 10 √ null
status_id BIGINT 19 1
project_status.id FK_cmq2womflwqgdijyxklbasgdi R
channel_code CHAR 4 √ null
space_status_id INT 10 √ null
sqft INT 10 √ null
complete_date DATE 10 null
risk_status INT 10 √ 0
selling_point_name VARCHAR 60 √ null
contract_holder_id INT 10 √ null
site_contract_holder.contract_holder_id FK_dmlw998kad1w51wd5g74p7rtn R
scorecard_result VARCHAR 10 √ null
selling_point_id VARCHAR 15 √ null
design_code CHAR 2 √ null
site_design_backup.design_code Implied Constraint R
retail_sqft INT 10 √ null
price_per_foot DECIMAL 15,2 √ null
turnover_condition_id INT 10 √ null
sign_criteria_available INT 10 √ null
visibility VARCHAR 255 √ null
visibility_ranking CHAR 1 √ null
access VARCHAR 255 √ null
access_ranking CHAR 1 √ null
signage VARCHAR 255 √ null
signage_ranking CHAR 1 √ null
parking VARCHAR 255 √ null
parking_ranking CHAR 1 √ null
traffic VARCHAR 255 √ null
traffic_ranking CHAR 1 √ null
overall_re_ranking CHAR 1 √ null
demographics_ranking CHAR 1 √ null
landlord VARCHAR 100 √ null
anchor_tenants VARCHAR 255 √ null
other_co_tenants VARCHAR 255 √ null
dead_date DATE 10 √ null
dead_reason_id INT 10 √ null
project_dead_reason.id FK_q2d1ayt3yj5idlmn5oddy4lvo R
dead_notes VARCHAR 200 √ null
fixture_prm_id VARCHAR 15 √ null
flex_pay INT 10 √ 0
folder_filed INT 10 √ 0
hamilton_mti_tracking_num VARCHAR 100 √ null
hotspot_location INT 10 √ 0
initial_inventory_tracking_info VARCHAR 255 √ null
kiosk_showroom INT 10 √ 0
kiosk_type VARCHAR 100 √ null
lepa_mdf_per_location INT 10 √ null
loaner_program INT 10 √ 0
main_language_id INT 10 √ null
mdf_allocation_fixtures DECIMAL 15,2 √ null
mdf_allocation_signage DECIMAL 15,2 √ null
mdf_spent_fixtures DECIMAL 15,2 √ null
mdf_spent_signage DECIMAL 15,2 √ null
mdf_spent_total DECIMAL 15,2 √ null
merchandise_ranking CHAR 1 √ null
num_exterior_building_signs INT 10 √ null
num_live_handsets_requested INT 10 √ null
num_monument_pylon_signs INT 10 √ null
payment_vendor_id INT 10 √ null
phonesync_cellebrite_serial_num VARCHAR 50 √ null
pos_count INT 10 √ null
prepay_only INT 10 √ 0
relo_status_id VARCHAR 25 √ null
relo_type_id INT 10 √ null
program_id INT 10 √ null
rrd_channel_id INT 10 √ null
rrd_tracking_num VARCHAR 255 √ null
rubbermaid_card_order_num INT 10 √ null
sap_security_role INT 10 √ 0
sap_security_ticket_num INT 10 √ null
security_company VARCHAR 50 √ null
sign_auditor VARCHAR 50 √ null
signage_prm_id VARCHAR 15 √ null
sp_exclusivity_id INT 10 √ null
sp_primary_industry_id INT 10 √ null
staples_tracking INT 10 √ null
status_call_num INT 10 √ null
storage_space_type_id INT 10 √ null
store_pinned INT 10 √ 0
store_security_package CHAR 1 √ null
t380_terminal VARCHAR 50 √ null
technology_package_id INT 10 √ null
telecheck_machine INT 10 √ null
till_fund_tracking VARCHAR 50 √ null
total_fixture_quote DECIMAL 15,2 √ null
total_mdf_allocation DECIMAL 15,2 √ null
total_sign_quote DECIMAL 15,2 √ null
vender_brokerage_company VARCHAR 50 √ null
on_hold INT 10 0
sub_dealer_entity_id VARCHAR 15 √ null
sde_name VARCHAR 50 √ null
sde_address VARCHAR 50 √ null
sde_address2 VARCHAR 50 √ null
sde_city VARCHAR 30 √ null
sde_state CHAR 2 √ null
sde_zip VARCHAR 10 √ null
sde_legal_contact VARCHAR 50 √ null
sde_owner_name VARCHAR 50 √ null
sde_phone VARCHAR 15 √ null
sde_fax VARCHAR 15 √ null
sde_market VARCHAR 50 √ null
sde_business_state CHAR 2 √ null
sde_business_type VARCHAR 50 √ null
signage_program_id INT 10 √ null
project_signage_program.id FK_s56iiqwoq2cewd5yxo3lhvxi7 R
milestone_comments VARCHAR 2000 √ null
union_status INT 10 √ 2
flooring_type VARCHAR 15 √ null
TTL_Wall INT 10 √ null
service_desk BIT 1 √ null
in_roam_cvg BIT 1 √ null
lease_term VARCHAR 20 √ null
budget DECIMAL 15,2 √ null
ll_new BIT 1 √ null
exisitng_site_ll VARCHAR 50 √ null
business_license INT 10 √ null
business_license_secured INT 10 √ null
dealio VARCHAR 6 √ null
relo_forced BIT 1 √ null
breakpoint VARCHAR 50 √ null
cam_psf DECIMAL 15,2 √ null
gla INT 10 √ null
go_dark BIT 1 √ null
lease_form BIT 1 √ null
lease_value DECIMAL 15,2 √ null
options VARCHAR 100 √ null
tia DECIMAL 15,2 √ 0.00
termination_right BIT 1 √ null
projected_acts_core INT 10 √ null
projected_acts_pre INT 10 √ null
projected_acts_deposit INT 10 √ null
projected_acts_mbb INT 10 √ null
rent_commence VARCHAR 50 √ null
closest_corp VARCHAR 50 √ null
closest_rps VARCHAR 50 √ null
permit_status_id INT 10 √ null
design_status_id INT 10 √ null
control_key_required BIT 1 √ null
Brandwrap_Status INT 10 √ null
project_type_id BIGINT 19 1
project_type.id FK_k0iaw5c7hylidf45rts7ce7yb R
start_date DATE 10 null
canceled_date DATE 10 √ null
last_modified DATETIME 19 √ null
gc_company INT 10 √ null
program_year INT 10 √ null
project_program_year.id FK_s5c7bvqqr2d4voh4sva3pjhla R
back_up BIT 1 √ b'0'
version BIGINT 19 √ 1
project_label VARCHAR 50 √ null
site_description VARCHAR 255 √ null
risk_status_notes TEXT 65535 √ null
site_recommendation VARCHAR 250 √ null
neighbor_left VARCHAR 250 √ null
former_tenant VARCHAR 250 √ null
scope_id INT 10 √ null
completion_date DATE 10 √ null
compensation DECIMAL 15,2 √ null
closeout_exception BIT 1 √ null
final_notice INT 10 √ null
Commencement_Date DATE 10 √ null
days_on_site VARCHAR 3 √ null
sds_notes VARCHAR 2000 √ null
risk_financial_close VARCHAR 500 √ null
fixture_template_id BIGINT 19 √ null
fixture_templates.id FK_t09r10c9w87pwleplfacys56x R
phone_forward VARCHAR 10 √ null
closure_type_id INT 10 √ null
move_bpk VARCHAR 100 √ null
move_qmi VARCHAR 100 √ null
move_cellebrite VARCHAR 100 √ null
collateral_id INT 10 √ null
treat_as_new BIT 1 √ null
till_fund_due DATE 10 √ null
till_fund_status_id INT 10 √ null
thumb_lock BIT 1 √ null
courier_id INT 10 √ null
demo_sims INT 10 √ null
delivery_restrictions VARCHAR 500 √ null
key_core_inventory BIT 1 √ null
key_core_front BIT 1 √ null
initial_inventory INT 10 √ null
pdm_ticket VARCHAR 50 √ null
email_request_status_id INT 10 √ null
security_role_status INT 10 √ null
ovp VARCHAR 20 √ null
rrd_status_id INT 10 √ null
telecheck_existing INT 10 √ null
monitor_17 INT 10 √ null
bpk_wide INT 10 √ null
cash DECIMAL 15,2 √ null
tills_existing INT 10 √ 0
post_close_call DATETIME 19 √ null
monitor_15 INT 10 √ null
bpk_slim INT 10 √ null
pre_close_call DATETIME 19 √ null
payments BIT 1 √ null
work_restrictions VARCHAR 500 √ null
inventory_level_id INT 10 √ null
rrd_login BIT 1 √ null
other_SAP VARCHAR 4 √ null
open_at_notice DATE 10 √ null
distribution_center VARCHAR 10 √ null
bw_type_id INT 10 √ null
printers INT 10 √ null
closure_comments VARCHAR 100 √ null
it_audit_passed BIT 1 √ null
dark_construction BIT 1 √ b'1'
pl_gc VARCHAR 1000 √ null
pl_fixture VARCHAR 2000 √ null
pl_security VARCHAR 1000 √ null
pl_lowVoltage VARCHAR 1000 √ null
liberty_fixture INT 10 √ null
liberty BIT 1 √ null
pl_device VARCHAR 1000 √ null
samsung BIT 1 √ null
zone INT 10 √ null
Facilities_Upgrade_Type INT 10 √ null
sys_monitor_types.type Implied Constraint R
pl_survey VARCHAR 1000 √ null
asset_schedule_id BIGINT 19 √ null
asset_schedule.id FK_ltw1rmihusannpbphu728rtdb R
previous_CH INT 10 √ null
pl_signage VARCHAR 1000 √ null
flip BIT 1 √ null
prj_program_id INT 10 √ null
project_sd_group.group_id FKED904B19D8855999 R
expense_type_id INT 10 √ null
reclass_required INT 10 √ null
opex_notes VARCHAR 500 √ null
sec_grill_account BIT 1 √ null
int_survey_request INT 10 √ null
pl_lv VARCHAR 1000 √ null
pl_other VARCHAR 1000 √ null
spec_instruc_notes VARCHAR 500 √ null
mdf_cost_center_code INT 10 √ null
lepa_id VARCHAR 15 √ null
site_ready_survey INT 10 √ null
gng_status_id INT 10 √ null
contract_status_id INT 10 √ null
pl_fm VARCHAR 1000 √ null
fixture_notes VARCHAR 500 √ null
signage_notes VARCHAR 500 √ null
risk_operational_close VARCHAR 500 √ null
notes_rt VARCHAR 1500 √ null
homer_ticket VARCHAR 35 √ null
no_asset_reason VARCHAR 500 √ null
inventory_collateral_request BIT 1 √ null
asset_needed BIT 1 √ null
wbs_element VARCHAR 20 √ null
warm_transfer_notes VARCHAR 500 √ null
cpo_opt_in INT 10 √ null
apple_approval INT 10 √ null
letter_of_credit INT 10 √ null
security_cabinet_vendor INT 10 √ null
ucc_filing INT 10 √ null
from_closing_sap BIT 1 √ null
permit_type_id INT 10 √ null
c60_days_id INT 10 √ null
relo_question INT 10 √ null
temp_close_relo.question Implied Constraint R
hard_transfer INT 10 √ null
move_blue_dot VARCHAR 100 √ null
cpo_certified BIT 1 √ null
move_fire_king VARCHAR 100 √ null
gc_budget DECIMAL 15,2 √ null
design_notes VARCHAR 500 √ null
risk_reason INT 10 √ null
risk_responsibility INT 10 √ null
phase_status INT 10 √ null
co_owner_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
bank_supplies_track VARCHAR 20 √ null
treas_supplies_track VARCHAR 20 √ null
cour_serv_days VARCHAR 20 √ null
org_id INT 10 √ null
fixture_installer INT 10 √ null
ISWE_ticket VARCHAR 50 √ null
printer_ticket VARCHAR 35 √ null
items_move VARCHAR 100 √ null
mag_st_supp BIT 1 √ null
lead_positions INT 10 √ null
associate_pos INT 10 √ null
lead_supp_name VARCHAR 50 √ null
lead_supp_email VARCHAR 50 √ null
ops_supp_name VARCHAR 50 √ null
ops_supp_email VARCHAR 50 √ null
train_supp_name VARCHAR 50 √ null
train_supp_email VARCHAR 50 √ null
sales_supp_name VARCHAR 50 √ null
sales_supp_email VARCHAR 50 √ null
train_exp INT 10 √ null
announcement_status_id INT 10 √ 0
sign_option INT 10 √ null
check_required BIT 1 √ null
dep_slp_req BIT 1 √ null
cour_serv_time VARCHAR 20 √ null
covered_population INT 10 √ null
covered_population_5 INT 10 √ null
covered_population_10 INT 10 √ null
network_ready BIT 1 √ null
network_timing DATE 10 √ null
network_comments VARCHAR 255 √ null
meter_install INT 10 √ null
utility_install INT 10 √ null
sdm_notes VARCHAR 500 √ null
announcement_notes VARCHAR 2000 √ null
fv_date_confirmation BIT 1 √ null
payment_received BIT 1 √ null
fixture_delivery_time DATETIME 19 √ null
sign_vendor_notes VARCHAR 5000 √ null
network_equipment_order_num VARCHAR 255 √ null
front_boh_order_num VARCHAR 255 √ null
lv_vendor_order_num VARCHAR 255 √ null
brother_printer_order_num VARCHAR 255 √ null
tellermate_order_num VARCHAR 255 √ null
xerox_order_num VARCHAR 255 √ null
current_rent_psf DECIMAL 15,2 √ null
closest_mpcs_corp VARCHAR 50 √ null
lease_start DATE 10 √ null
low_volt_req BIT 1 √ null
Ext_Switch_SCN VARCHAR 35 √ null
netwrk_cash_drawer_scn VARCHAR 35 √ null
install_labor_scn VARCHAR 35 √ null
cabling_labor_scn VARCHAR 35 √ null
alternates DECIMAL 15,2 √ null
deal_comm VARCHAR 100 √ null
exercise_option BIT 1 √ null
base_rent_change LONGTEXT 2147483647 √ null
reimburse BIT 1 √ null
abatement BIT 1 √ null
reimburse_amt DECIMAL 15,2 √ null
option_rent VARCHAR 100 √ null
mva_range VARCHAR 50 √ null
vacancy_rate VARCHAR 50 √ null
add_base_rent_det VARCHAR 150 √ null
cell_order VARCHAR 355 √ null
dev_health_charge VARCHAR 255 √ null
tia_notes TEXT 65535 √ null
tia_follow TEXT 65535 √ null
rea_notes VARCHAR 2000 √ null
center_gla INT 10 √ null
nnn_psf_cur DECIMAL 15,2 √ null
nnn_psf_new DECIMAL 15,2 √ null
repaired BIT 1 √ null
tmus_repair BIT 1 √ null
remit_reimbursement BIT 1 √ null
check_received BIT 1 √ null
repair_completed BIT 1 √ null
new_hub VARCHAR 200 √ null
expire_date DATE 10 √ null
MediaPlayerInstalled VARCHAR 10 √ null
re_decision INT 10 √ null
sign_manu_loc VARCHAR 50 √ null
bb_serviceable BIT 1 √ null
bb_max_up_down VARCHAR 50 √ null
bb_construction_req INT 10 √ null
circuit_risk VARCHAR 2 √ null
circuit_risk_resp VARCHAR 2 √ null
bb_fulfill_cat INT 10 √ null
bb_audit INT 10 √ null
bb_build_timeline VARCHAR 50 √ null
bb_notes VARCHAR 500 √ null
Option_Base_Rent_PSF DECIMAL 15,2 √ null
Option_Base_Rent_Monthly DECIMAL 15,2 √ null
Option_Base_Rent_Annual DECIMAL 15,2 √ null
Non_Base_Rent_Saving DECIMAL 15,2 √ null
avg_daily_traffic VARCHAR 30 √ null
Prop_Class VARCHAR 5 √ null
Other_MVA_Notes TEXT 65535 √ null
rfi_cat VARCHAR 2 √ null
sub_cat VARCHAR 2 √ null
rfi_ci VARCHAR 2 √ null
sub_ci VARCHAR 2 √ null
sub_request BIT 1 √ null
bb_granite_cat INT 10 √ null
Remodel_Scenario VARCHAR 5 √ null
Skip_legal BIT 1 √ null
Closure_EBITDA_Benefit DECIMAL 15,2 √ null
ClosureNPV DECIMAL 15,2 √ null
TPR_Commissions DECIMAL 15,2 √ null
Annual_Opex_Savings DECIMAL 15,2 √ null
EarlyTermination DECIMAL 15,2 √ null
CD_Required VARCHAR 50 √ null
sub_lease_term VARCHAR 20 √ null
sl_current_rent_psf DECIMAL 15,2 √ null
sl_price_per_foot DECIMAL 15,2 √ null
sl_options VARCHAR 50 √ null
sl_option_rents VARCHAR 50 √ null
sublease_start DATE 10 √ null
sl_deal_comm VARCHAR 100 √ null
grade_prop_cond VARCHAR 10 √ null
grade_prop_loc VARCHAR 10 √ null
site_accessory_tier.loc Implied Constraint R
mkt_trend VARCHAR 10 √ null
comp1 VARCHAR 50 √ null
Comp2_rentpsf DECIMAL 15,2 √ null
Comp1_comparision VARCHAR 10 √ null
Comp_Vac1_rentpsf DECIMAL 15,2 √ null
Comp_Vac1_comparison VARCHAR 10 √ null
Comp_Vac2_comparison VARCHAR 10 √ null
Comp1_sqft INT 10 √ null
Comp_Vac1_sqft INT 10 √ null
Comp1_rentpsf DECIMAL 15,2 √ null
Comp_Vac1 VARCHAR 50 √ null
Comp2_comparision VARCHAR 10 √ null
Comp_Vac2 VARCHAR 50 √ null
Comp_Vac2_rentpsf DECIMAL 15,2 √ null
comp2 VARCHAR 50 √ null
Comp_Vac2_sqft INT 10 √ null
Comp2_sqft VARCHAR 6 √ null
comp1_zip VARCHAR 10 √ null
comp1_city VARCHAR 30 √ null
comp2_city VARCHAR 30 √ null
comp2_state VARCHAR 2 √ null
comp2_zip VARCHAR 10 √ null
comp1_state VARCHAR 2 √ null
Compvac1_city VARCHAR 30 √ null
Compvac1_state VARCHAR 2 √ null
Compvac1_zip VARCHAR 10 √ null
Compvac2_city VARCHAR 30 √ null
Compvac2_state VARCHAR 2 √ null
Compvac2_zip VARCHAR 10 √ null
lease_strat VARCHAR 50 √ null
char_type VARCHAR 50 √ null
fac_cost DECIMAL 15,2 √ null
Fin_Perf_KPI_Exception BIT 1 √ null
Fin_Perf_KPI_Exception_comment VARCHAR 1500 √ null
savings_start DATE 10 √ null
savings_end DATE 10 √ null
cost_avoid_charge DECIMAL 15,2 √ null
est_comm DECIMAL 15,2 √ null
cost_avoid_note VARCHAR 500 √ null
legal_request_type VARCHAR 50 √ null
expedite BIT 1 √ null
legal_default_type VARCHAR 50 √ null
change_legal_intake BIT 1 √ null
true_default BIT 1 √ null
default_delivery_method VARCHAR 50 √ null
days_cure_default VARCHAR 250 √ null
default_payment DECIMAL 15,2 √ null
default_payment_paid_by VARCHAR 50 √ null
default_payment_method VARCHAR 50 √ null
com_tracker_id VARCHAR 50 √ null
t_dma.ID Implied Constraint R
legal_rev_notes VARCHAR 2000 √ null
sign_permit_anticipated INT 10 √ null
fix_decision INT 10 √ null
sign_process_exception VARCHAR 250 √ null
dealer_opt_in BIT 1 √ null
request_note TEXT 65535 √ null
expedite_note VARCHAR 500 √ null
dealer_progress_note VARCHAR 500 √ null
till_fund_ref_num VARCHAR 20 √ null
cur_tax DECIMAL 15,2 √ null
cur_pro DECIMAL 15,2 √ null
cur_cam DECIMAL 15,2 √ null
cur_ins DECIMAL 15,2 √ null
cur_hvac DECIMAL 15,2 √ null
cur_sew DECIMAL 15,2 √ null
cur_uti DECIMAL 15,2 √ null
cur_tra DECIMAL 15,2 √ null
cur_med DECIMAL 15,2 √ null
cur_spr DECIMAL 15,2 √ null
cur_wat DECIMAL 15,2 √ null
cur_perc_rent BIT 1 √ null
cur_oth DECIMAL 15,2 √ null
cur_hvac_equi DECIMAL 15,2 √ null
cur_nat_fix VARCHAR 10 √ null
cur_perc_rent_rate INT 10 √ null
cur_perc_rent_break DECIMAL 15,2 √ null
cur_perc_rent_pay DECIMAL 15,2 √ null
cur_cam_ann_inc INT 10 √ null
cur_tax_ann_inc INT 10 √ null
cur_pro_ann_inc INT 10 √ null
cur_oth_ann_inc INT 10 √ null
ren_cam DECIMAL 15,2 √ null
ren_tax DECIMAL 15,2 √ null
ren_ins DECIMAL 15,2 √ null
ren_pro DECIMAL 15,2 √ null
ren_med DECIMAL 15,2 √ null
ren_uti DECIMAL 15,2 √ null
ren_hvac_equ DECIMAL 15,2 √ null
ren_hvac DECIMAL 15,2 √ null
ren_sew DECIMAL 15,2 √ null
ren_spr DECIMAL 15,2 √ null
ren_nat_fix VARCHAR 10 √ null
ren_perc_rent BIT 1 √ null
ren_oth DECIMAL 15,2 √ null
ren_tax_ann_inc INT 10 √ null
ren_wat DECIMAL 15,2 √ null
ren_perc_rent_rate INT 10 √ null
ren_perc_rent_bre DECIMAL 15,2 √ null
ren_pro_ann_inc INT 10 √ null
ren_cam_ann_inc INT 10 √ null
ren_oth_ann_inc INT 10 √ null
ren_tra DECIMAL 15,2 √ null
exp_lease_end DATE 10 √ null
request_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
default_unresolved BIT 1 √ null
event_date DATE 10 √ null
ll_communication BIT 1 √ null
work_order_num VARCHAR 50 √ null
escalation_num VARCHAR 50 √ null
legal_request_subtype VARCHAR 50 √ null
incident_report BIT 1 √ null
request_background VARCHAR 500 √ null
incident_num VARCHAR 50 √ null
issue_location VARCHAR 50 √ null
communication_approved BIT 1 √ null
ren_bmr_ann_inc INT 10 √ null
cur_bmr DECIMAL 15,2 √ null
ren_bmr DECIMAL 15,2 √ null
cur_bmr_ann_inc INT 10 √ null
sku_one VARCHAR 4 √ null
sku_three VARCHAR 4 √ null
fix_track VARCHAR 250 √ null
sku_two VARCHAR 4 √ null
sku_four VARCHAR 4 √ null
site_design_id INT 10 √ null
visibility_group_id INT 10 √ null
project_visibility_group.id FK_bftxes6m7wdalxc9u1mn6lb2l R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
design_code Performance Asc design_code
FK_bftxes6m7wdalxc9u1mn6lb2l Performance Asc visibility_group_id
FK_s5c7bvqqr2d4voh4sva3pjhla Performance Asc program_year
FKED904B193CE55FC6 Performance Asc fixture_template_id
FKED904B194245717 Performance Asc signage_program_id
FKED904B196284F41D Performance Asc contract_holder_id
FKED904B1978FAA95B Performance Asc asset_schedule_id
FKED904B1992D2B99F Performance Asc site_id
FKED904B199C0630F6 Performance Asc project_type_id
FKED904B19AB626C9C Performance Asc status_id
FKED904B19D8855999 Performance Asc prj_program_id
FKED904B19FC5C69C5 Performance Asc dead_reason_id
idx_project_complete_date Performance Asc complete_date
iteration Performance Asc/Asc/Asc site_id + iteration + project_type_id
prj_program_id Performance Asc prj_program_id
space_status_id Performance Asc space_status_id
turnover_condition_id Performance Asc turnover_condition_id
unique_iteration Must be unique Asc/Asc site_id + iteration

Relationships

Close relationships within degrees of separation