asset


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
asset_warranty.asset_id FKC17E956BE6BD1E7A R
version INT 10 √ 0
quantity INT 10 √ null
schedule_id BIGINT 19 null
asset_schedule.id FK_asset_asset_schedule R
type_id BIGINT 19 null
asset_type.id FK_asset_asset_type R
sign_primary INT 10 √ null
sign_north_size INT 10 √ null
sign_north_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sign_north_backer_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sign_north_backer_color INT 10 √ null
sign_north_color INT 10 √ null
sign_south_size INT 10 √ null
sign_south_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sign_south_backer_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sign_south_backer_color INT 10 √ null
sign_south_color INT 10 √ null
sign_west_size INT 10 √ null
sign_west_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sign_west_backer_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sign_west_backer_color INT 10 √ null
sign_west_color INT 10 √ null
sign_east_size INT 10 √ null
sign_east_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sign_east_backer_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sign_east_backer_color INT 10 √ null
sign_east_color INT 10 √ null
awning_color INT 10 √ null
entry1_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
entry1_glass VARCHAR 50 √ null
entry1_dimension VARCHAR 50 √ null
entry2_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
entry2_glass VARCHAR 50 √ null
entry2_dimension VARCHAR 50 √ null
entry3_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
entry3_glass VARCHAR 50 √ null
entry3_dimension VARCHAR 50 √ null
hurricane_glass BIT 1 √ null
hurricane_covers INT 10 √ null
hurricane_covers_storage VARCHAR 100 √ null
tint BIT 1 √ null
floor_carpet_color INT 10 √ null
floor_vinyl_color INT 10 √ null
floor_wood_color INT 10 √ null
floor_mat INT 10 √ null
floor_tile_color INT 10 √ null
cloud_color INT 10 √ null
cloud_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
cloud_obstruction BIT 1 √ null
non_standard BIT 1 √ null
door_thumblock BIT 1 √ null
grill_thumblock BIT 1 √ null
floor_base_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
floor_base_color INT 10 √ null
base_height INT 10 √ null
grill_shutter INT 10 √ null
grill_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
grill_mount INT 10 √ null
grill_manufacturer INT 10 √ null
grill_partial BIT 1 √ null
safe_location INT 10 √ null
safe_brand INT 10 √ null
ttl_size INT 10 √ null
bracket_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
thermostat_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
thermostat_lock BIT 1 √ null
gfloor_boh_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
floor_rr_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
timer INT 10 √ null
timer_control INT 10 √ null
fluor_boh BIT 1 √ null
door_location INT 10 √ null
door_alarm INT 10 √ null
dvr_brand INT 10 √ null
inventory_area INT 10 √ null
inventory_lock1 INT 10 √ null
inventory_lock2 INT 10 √ null
inventory_volume VARCHAR 50 √ null
hot_water_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
sink_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
fire_alarm BIT 1 √ null
fire_horn_strobes BIT 1 √ null
fire_alarm_panel BIT 1 √ null
fire_alarm_brand VARCHAR 30 √ null
floor_drain1 BIT 1 √ null
toilet_auto_flush1 BIT 1 √ null
toilet_power_assist1 BIT 1 √ null
hand_dryer1 INT 10 √ null
toilet_tank1 INT 10 √ null
floor_drain2 BIT 1 √ null
toilet_auto_flush2 BIT 1 √ null
toilet_power_assist2 BIT 1 √ null
hand_dryer2 INT 10 √ null
toilet_tank2 INT 10 √ null
floor_drain3 BIT 1 √ null
toilet_auto_flush3 BIT 1 √ null
toilet_power_assist3 BIT 1 √ null
hand_dryer3 INT 10 √ null
toilet_tank3 INT 10 √ null
lamp_type VARCHAR 11 √ null
lamp_type2 VARCHAR 11 √ null
lamp_type5 VARCHAR 11 √ null
lamp_type9 VARCHAR 11 √ null
lamp_type6 VARCHAR 11 √ null
lamp_type7 VARCHAR 11 √ null
lamp_type8 VARCHAR 11 √ null
lamp_type3 VARCHAR 11 √ null
lamp_type11 VARCHAR 11 √ null
lamp_type10 VARCHAR 11 √ null
lamp_type4 VARCHAR 11 √ null
owner INT 10 √ null
note VARCHAR 500 √ null
lamp_type12 VARCHAR 4 √ null
lamp_type13 VARCHAR 4 √ null
lamp_type14 VARCHAR 4 √ null
lamp_type15 VARCHAR 4 √ null
lamp_type16 VARCHAR 4 √ null
creative INT 10 √ null
dvr_mount BIT 1 √ null
time_delay INT 10 √ null
mount_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
film_full_cvg BIT 1 √ null
safe_mfr INT 10 √ null
motion INT 10 √ null
wireless BIT 1 √ null
gps_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
symbol1 VARCHAR 25 √ null
symbol2 VARCHAR 25 √ null
symbol3 VARCHAR 25 √ null
symbol4 VARCHAR 25 √ null
solar_shade BIT 1 √ null
telco_location INT 10 √ null
symbol5 VARCHAR 50 √ null
swing INT 10 √ null
monument_color INT 10 √ null
pylon_color INT 10 √ null
symbol6 VARCHAR 25 √ null
sign_version INT 10 √ null
metro_sign1_size INT 10 √ null
metro_sign1_style INT 10 √ null
metro_sign1_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
metro_pylon_color INT 10 √ null
metro_monument_color INT 10 √ null
metro_sign2_size INT 10 √ null
metro_sign2_style INT 10 √ null
metro_sign2_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
metro_sign3_size INT 10 √ null
metro_sign3_style INT 10 √ null
metro_sign3_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
metro_sign4_size INT 10 √ null
metro_sign4_style INT 10 √ null
metro_sign4_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
metro_awning_color INT 10 √ null
metro_sign_version INT 10 √ null
metro_wr_creative INT 10 √ null
sign_south_version INT 10 √ null
sign_north_version INT 10 √ null
sign_east_version INT 10 √ null
sign_west_version INT 10 √ null
symbol7 VARCHAR 50 √ null
cashdrawer_bundle BIT 1 √ null
brackets_type_table INT 10 √ null
gps_model INT 10 √ null
gps_model_2 INT 10 √ null
alarm_sys_co INT 10 √ null
gps_cash_vendor INT 10 √ null
instakey_vendor INT 10 √ null
camera_POS_display INT 10 √ null
cameras_inv_safe INT 10 √ null
cameras_back_door INT 10 √ null
cameras_cash_safe INT 10 √ null
cameras_360 INT 10 √ null
cameras_PVM INT 10 √ null
cameras_exit INT 10 √ null
cameras_facial_rec INT 10 √ null
cameras_exterior INT 10 √ null
cameras_other INT 10 √ null
win_shield_mfr INT 10 √ null
inv_safe_bluedot INT 10 √ null
inv_room_dedicated BIT 1 √ null
inv_room_lock BIT 1 √ null
inv_room_cage BIT 1 √ null
back_door_trident BIT 1 √ null
back_door_viewfinder BIT 1 √ null
back_door_pushbar BIT 1 √ null
inv_cage_instore BIT 1 √ null
inv_cage_mfr INT 10 √ null
inv_safe_fireking INT 10 √ null
inv_safe_pacific INT 10 √ null
inv_safe_other INT 10 √ null
cash_safe_type INT 10 √ null
sys_monitor_types.type Implied Constraint R
demo_sec_brand INT 10 √ null
shutter_mfr INT 10 √ null
win_film_mfr INT 10 √ null
door_to_boh_lock INT 10 √ null
cash_safe_mfr INT 10 √ null
tint_mfr VARCHAR 50 √ null
tint_wrty VARCHAR 50 √ null
demo_sec_tetherless BIT 1 √ null
monument_orientation INT 10 √ null
pylon_orientation INT 10 √ null
sign_east_orientation INT 10 √ null
sign_west_orientation INT 10 √ null
sign_north_orientation INT 10 √ null
sign_south_orientation INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK58CEAF02BBA482A Performance Asc schedule_id
FK58CEAF045D4494A Performance Asc type_id
type_id Must be unique Asc/Asc type_id + schedule_id
unique_schedule_id Must be unique Asc/Asc type_id + schedule_id

Relationships

Close relationships within degrees of separation