create table dbo.PUBACC_AN ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, antenna_action_performed char(1) null, antenna_number int null, location_number int null, receive_zone_code char(6) null, antenna_type_code char(1) null, height_to_tip numeric(5,1) null, height_to_center_raat numeric(5,1) null, antenna_make varchar(25) null, antenna_model varchar(25) null, tilt numeric(3,1) null, polarization_code char(5) null, beamwidth numeric(4,1) null, gain numeric(4,1) null, azimuth numeric(4,1) null, height_above_avg_terrain numeric(5,1) null, diversity_height numeric(5,1) null, diversity_gain numeric(4,1) null, diversity_beam numeric(4,1) null, reflector_height numeric(5,1) null, reflector_width numeric(4,1) null, reflector_separation numeric(5,1) null, repeater_seq_num int null, back_to_back_tx_dish_gain numeric(4,1) null, back_to_back_rx_dish_gain numeric(4,1) null, location_name varchar(20) null, passive_repeater_id int null, alternative_cgsa_method char(1) null, path_number int null, line_loss numeric(3,1) null, status_code char(1) null, status_date datetime null ) go create table dbo.PUBACC_EN ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, entity_type char(2) null, licensee_id char(9) null, entity_name varchar(200) null, first_name varchar(20) null, mi char(1) null, last_name varchar(20) null, suffix char(3) null, phone char(10) null, fax char(10) null, email varchar(50) null, street_address varchar(60) null, city varchar(20) null, state char(2) null, zip_code char(9) null, po_box varchar(20) null, attention_line varchar(35) null, sgin char(3) null, frn char(10) null, applicant_type_code char(1) null, applicant_type_other char(40) null, status_code char(1) null, status_date datetime null ) go create table dbo.PUBACC_FR ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, frequency_action_performed char(1) null, location_number int null, antenna_number int null, class_station_code char(4) null, op_altitude_code char(2) null, frequency_assigned numeric(16,8) null, frequency_upper_band numeric(16,8) null, frequency_carrier numeric(16,8) null, time_begin_operations int null, time_end_operations int null, power_output numeric(15,3) null, power_erp numeric(15,3) null, tolerance numeric(6,5) null, frequency_ind char(1) null, status char(1) null, eirp numeric(7,1) null, transmitter_make varchar(25) null, transmitter_model varchar(25) null, auto_transmitter_power_control char(1) null, cnt_mobile_units int null, cnt_mob_pagers int null, freq_seq_id int null, status_code char(1) null, status_date datetime null ) go create table dbo.PUBACC_HD ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, license_status char(1) null, radio_service_code char(2) null, grant_date char(10) null, expired_date char(10) null, cancellation_date char(10) null, eligibility_rule_num char(10) null, applicant_type_code_reserved char(1) null, alien char(1) null, alien_government char(1) null, alien_corporation char(1) null, alien_officer char(1) null, alien_control char(1) null, revoked char(1) null, convicted char(1) null, adjudged char(1) null, involved_reserved char(1) null, common_carrier char(1) null, non_common_carrier char(1) null, private_comm char(1) null, fixed char(1) null, mobile char(1) null, radiolocation char(1) null, satellite char(1) null, developmental_or_sta char(1) null, interconnected_service char(1) null, certifier_first_name varchar(20) null, certifier_mi char(1) null, certifier_last_name varchar(20) null, certifier_suffix char(3) null, certifier_title char(40) null, gender char(1) null, african_american char(1) null, native_american char(1) null, hawaiian char(1) null, asian char(1) null, white char(1) null, ethnicity char(1) null, effective_date char(10) null, last_action_date char(10) null, auction_id int null, reg_stat_broad_serv char(1) null, band_manager char(1) null, type_serv_broad_serv char(1) null, alien_ruling char(1) null, licensee_name_change char(1) null ) go create table dbo.PUBACC_LO ( record_type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, location_action_performed char(1) null, location_type_code char(1) null, location_class_code char(1) null, location_number int null, site_status char(1) null, corresponding_fixed_location int null, location_address varchar(80) null, location_city char(20) null, location_county varchar(60) null, location_state char(2) null, radius_of_operation numeric(5,1) null, area_of_operation_code char(1) null, clearance_indicator char(1) null, ground_elevation numeric(7,1) null, lat_degrees int null, lat_minutes int null, lat_seconds numeric(3,1) null, lat_direction char(1) null, long_degrees int null, long_minutes int null, long_seconds numeric(3,1) null, long_direction char(1) null, max_lat_degrees int null, max_lat_minutes int null, max_lat_seconds numeric(3,1) null, max_lat_direction char(1) null, max_long_degrees int null, max_long_minutes int null, max_long_seconds numeric(3,1) null, max_long_direction char(1) null, nepa char(1) null, quiet_zone_notification_date char(10) null, tower_registration_number char(10) null, height_of_support_structure numeric(7,1) null, overall_height_of_structure numeric(7,1) null, structure_type char(6) null, airport_id char(4) null, location_name char(20) null, units_hand_held int null, units_mobile int null, units_temp_fixed int null, units_aircraft int null, units_itinerant int null, status_code char(1) null, status_date datetime null, earth_agree char(1) null ) go create table dbo.PUBACC_MK ( record_type char(2) null, unique_system_identifier numeric(9,0) not null, uls_file_number char(14) null, ebf_number varchar(30) null, call_sign char(10) null, market_code char(6) null, channel_block char(4) null, submarket_code int null, market_name char(30) null, coverage_partitioning char(1) null, coverage_dissagregation char(1) null, cellular_phase_id smallint null, population numeric(9,0) null, tribal_credit_indicator char(1) null, tribal_credit_calculation money null, additional_credit_requested money null, tribal_credit_awarded money null, additiona_credit_awarded money null, bc_pct numeric(5,4) null, open_closed_bidding char(1) null ) go create table dbo.PUBACC_VS ( record_Type char(2) not null, unique_system_identifier numeric(9,0) not null, uls_file_number char(10) null, ebf_number varchar(30) null, callsign char(10) not null, public_safety_region integer not null, prioritization_wave integer not null, region_close_date datetime not null ) go