v_sites


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 0
sap VARCHAR 4 √ null
status_code CHAR 4 √ null
site_status.status_code Implied Constraint R
status VARCHAR 50 √ null
name VARCHAR 50 √ null
address VARCHAR 70 √ null
address2 VARCHAR 35 √ null
city VARCHAR 30 √ null
state CHAR 2 √ null
zip VARCHAR 10 √ null
county VARCHAR 50 √ null
dma VARCHAR 50 √ null
dma_id INT 10 √ null
phone VARCHAR 10 √ null
fax VARCHAR 10 √ null
email VARCHAR 50 √ null
latitude DECIMAL 9,6 √ null
longitude DECIMAL 9,6 √ null
type_code CHAR 2 √ null
site_type.type_code Implied Constraint R
location_type VARCHAR 50 √ null
mall_id CHAR 6 √ null
channel_code VARCHAR 5 √ null
channel VARCHAR 50 √ null
contract_holder_id INT 10 √ null
transaction_type_id INT 10 √ null
transaction_type VARCHAR 50 √ null
sqft INT 10 √ null
relo_from INT 10 √ null
date_opened DATE 10 null
date_closed DATE 10 √ null
selling_point_name VARCHAR 60 √ null
dealer_code VARCHAR 7 √ null
selling_point_id VARCHAR 15 √ null
design_code CHAR 2 √ null
site_design_backup.design_code Implied Constraint R
design VARCHAR 50 √ null
retail_sqft INT 10 √ null
dimensions VARCHAR 10 √ null
sampson_code CHAR 3 √ null
site_sampson.sampson_code Implied Constraint R
copernicus_grade VARCHAR 3 √ null
copernicus_ramp INT 10 √ null
copernicus_status CHAR 1 √ null
center_name VARCHAR 50 √ null
org_id INT 10 √ null
company_code VARCHAR 7 √ null
cost_center_code VARCHAR 7 √ null
rem_code VARCHAR 50 √ null
watson_code VARCHAR 15 √ null
hours_sun INT 10 √ 0
hours_mon INT 10 √ 0
hours_tue INT 10 √ 0
hours_wed INT 10 √ 0
hours_thu INT 10 √ 0
hours_fri INT 10 √ 0
hours_sat INT 10 √ 0
last_modified DATETIME 19 √ null
target_area_id INT 10 √ null
bill_pay_kiosk INT 10 √ null
last_modified_project_id INT 10 √ null
timezone VARCHAR 50 √ null
blade INT 10 √ null
directional INT 10 √ null
directory INT 10 √ null
monument INT 10 √ null
pylon INT 10 √ null
sign_colors INT 10 √ null
sign_size INT 10 √ null
sign_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
window_wrap INT 10 √ null
legal_entity_id INT 10 √ null
version BIGINT 19 √ 1
close_reason_id INT 10 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views