/****************************************************************************** ** Generated Script (CREATE): Tables ** ** ------------------------------------------------------------------------- ** ******************************************************************************/ create table dbo.ADDRESS ( address_id synthetic_key_id not null, address_one medium_description null, address_two medium_description null, po_box short_description null, city medium_description not null, state varchar(20) not null, zip_code varchar(20) not null, mail_id_extension int not null, address_search long_description null, fips_code smallint null ) create table dbo.AERONAUTICAL_COMMUNITY ( community_id synthetic_key_id not null, afp_id synthetic_key_id not null ) create table dbo.AERONAUTICAL_NOTIFICATION ( afp_id int not null, application_id int not null, latitude varchar(7) not null, afp_procedures text null, latitude_direction char(1) not null, cli_explanation text null, longitude varchar(7) not null, longitude_direction char(1) not null, datum char(1) not null, radius_of_operation decimal(10,4) null, standard_radius decimal(10,4) not null, peak_power decimal(10,4) not null, standard_peak_power decimal(10,4) null, peak_power_type char(1) not null, std_peak_power_type char(1) null, rad_measurement char(1) null ) create table dbo.ANNUAL_CABLE_REPORT ( report_id int not null, head_end_id int not null, fiber_plant_length int null, application_id int not null, number_optical_nodes int null, contact_id int null, mail_out_date datetime null, avg_subscribers_optical int null, cars_facilities_used char(1) null, cable_modems_provided char(1) null, telephone_subscribers int null, cable_modem_subscribers int null, number_of_subscribers int null, cable_modems_deployed int null, potential_subscribers int null, clustered_cable_system char(1) null, coaxial_plant_length int null, cluster_subscribers int null, settop_boxes_deployed int null, number_analog_boxes int null, number_digital_boxes int null, number_hybrid_boxes int null, lower_downstream_spectrum decimal(10,4) null, upper_downstream_spectrum decimal(10,4) null, lower_active_downstream decimal(10,4) null, upper_active_downstream decimal(10,4) null, analog_channel_capacity int null, analog_channels_used int null, digital_channel_capacity int null, digital_channels_used int null, digital_modulation_method varchar(10) null, largest_digital_channels int null, lower_upstream_spectrum decimal(10,4) null, upper_upstream_spectrum decimal(10,4) null, lower_active_upstream decimal(10,4) null, upper_active_upstream decimal(10,4) null, number_clustered_systems int null, other_mod_method varchar(255) null ) create table dbo.ANTENNA_LOCATION ( antenna_id int not null, site_id int not null, callsign_am_station varchar(25) null, manufacturer varchar(50) not null, model_number varchar(25) null, antenna_height_feet decimal(11,7) null, antenna_height_meters decimal(11,7) null, reflect_size_length_ft decimal(11,7) null, reflect_size_length_meters decimal(11,7) null, reflect_size_width_ft decimal(11,7) null, antenna_type char(1) null, reflector_height_meters decimal(11,7) null, reflect_size_width_meters decimal(11,7) null, antenna_diameter decimal(11,7) null ) create table dbo.APPLICATION ( application_id synthetic_key_id not null, user_id int null, application_type char(2) not null, application_source char(1) not null, date_entered datetime null, receipt_date datetime null, application_status char(2) not null, status_date datetime null, application_signature long_description null, signor_type char(1) null, signor_title medium_description null, signor_phone short_description null, acceptance_pn_date datetime null, fee_control_number short_description null, grant_pn_date datetime null, filing_year datetime null, reference_number numeric(15,0) not null, confirmation_number numeric(15,0) null, signor_date datetime null, user_lock_id int null ) create table dbo.APPLICATION_CONTACT ( seq_num synthetic_key_id not null, application_id synthetic_key_id null, contact_id synthetic_key_id null ) create table dbo.APPLICATION_MODIFICATION ( modification_id synthetic_key_id not null, application_id synthetic_key_id not null, modification_type_id numeric(10,0) not null ) create table dbo.CABLE_OPERATOR ( operator_id synthetic_key_id not null, contact_id synthetic_key_id null, legal_name long_description not null, date_last_name_change datetime null, tax_id_number short_description not null, legal_first_name long_description null ) create table dbo.CABLE_OPERATOR_ADDRESS ( cable_addr_id synthetic_key_id not null, operator_id synthetic_key_id null, address_id synthetic_key_id null ) create table dbo.CABLE_OPERATOR_SUBSIDIARY ( subsidiary_id synthetic_key_id not null, operator_id synthetic_key_id not null, address_id synthetic_key_id null, contact_id synthetic_key_id null, assumed_name long_description not null, subsidiary_type char(1) not null, soundex varchar(25) null ) create table dbo.CALLSIGN ( callsign_id int not null, callsign varchar(25) null, cops_signal_source int null, status char(2) not null, license_type char(1) null, community_of_license varchar(50) null, state_of_license char(2) null, head_end_id int null, display_for_cars char(1) not null, status_date datetime null, comments text null, signon_id int null ) create table dbo.CHANNEL_GROUP ( channel_grp_id int not null, callsign_id int null, channel_record_number smallint not null, channel_notation varchar(255) null, license_id int null ) create table dbo.COMMUNITY_UNIT ( community_id synthetic_key_id not null, community_name long_description not null, subsidiary_id synthetic_key_id not null, county_code varchar(5) null, county_name medium_description not null, state char(2) not null, status small_number not null, community_unit_id short_description null, fips_indicator varchar(20) null, community_population int null, number_of_subscribers int null, potential_subscribers int null, cable_plant_length int null, service_started_date datetime null, municipality_type small_number not null, municipality long_description null, date_operational datetime null, head_end_id synthetic_key_id null, market_id synthetic_key_id null, merged_cuid synthetic_key_id null, last_cli_date datetime null, fips_code int null, signon_id int null ) create table dbo.COMMUNITY_UNIT_CALLSIGN ( community_id synthetic_key_id not null, callsign_id synthetic_key_id not null, cops_signal_source synthetic_key_id null ) create table dbo.CONTROLLER_HEADER ( header_id int not null, subsidiary_id int null, license_id int null, sub_partner_filed_325 char(1) null, cooperative_enterprise char(1) not null, applicant_filed_325 char(1) not null, partners_filed_325 char(1) null ) create table dbo.CUID_OWNERS ( owner_id synthetic_key_id not null, subsidiary_id synthetic_key_id null, community_id synthetic_key_id not null, change_date datetime not null ) create table dbo.FREQUENCY ( frequency_id int not null, callsign_id int null, cli_id int null, signal_type smallint null, signal_source smallint null, lower_frequency decimal(10,4) not null, upper_frequency decimal(10,4) not null, tolerance decimal(10,4) null, antenna_input_power decimal(10,4) null, emission_code varchar(255) null, frequency_type char(1) not null, channel varchar(10) null, band_type varchar(5) null, action_type char(1) not null, nonstandard_group_num smallint null, polorization char(1) null, afp_id int null, modulation char(2) null, channel_record_number smallint null, callsign_file_number varchar(25) null, license_id int null, aeronautical_freq_type char(1) null ) create table dbo.HEADEND ( head_end_id int not null, physical_system_id varchar(25) not null ) create table dbo.HEADEND_CARS_FACILITY ( report_id int not null, callsign_id int not null ) create table dbo.HEADEND_PROGRAMMING ( program_id int not null, transmission_type char(1) not null, report_id int null, callsign_id int null, program_type int not null, tier char(1) not null ) create table dbo.LICENSE ( license_id int not null, address_id int null, callsign_id int null, subsidiary_id int null, records_address_id int null, application_id int not null, contact_id int null, existing_station char(1) null, file_number varchar(25) null, status char(1) not null, expiration_date datetime null, serve_other_systems char(1) null, control_station_equipment char(1) null, unlimited_equip_access char(1) null, unauthorized_use_measures char(1) null, license_ever_revoked char(1) null, foreign_vernment char(1) null ) create table dbo.LICENSE_CONDITION ( condition_id int not null, license_id int not null, description char(255) null, condition_text text null ) create table dbo.LICENSE_CONTROLLER ( controller_id synthetic_key_id not null, header_id synthetic_key_id null, last_name long_description not null, first_name varchar(255) null, controller_type char(2) not null, tax_id_number short_description not null, state_incorporated varchar(20) null, subordinate_to int null ) create table dbo.REGISTRATION ( registration_id synthetic_key_id not null, application_id synthetic_key_id not null, community_id synthetic_key_id not null, registration_date datetime not null ) create table dbo.SIGNAL_LEAKAGE_AIR ( cli_id synthetic_key_id not null, contact_id synthetic_key_id null, test_start_date datetime null, test_end_date datetime null, test_frequency decimal(10,4) null, peak_values float null, percent_lt_10 decimal(10,4) null, airspace_test_result char(1) null ) create table dbo.SIGNAL_LEAKAGE_COMMUNITY ( cli_id synthetic_key_id not null, community_id synthetic_key_id not null ) create table dbo.SIGNAL_LEAKAGE_GROUND ( cli_id int not null, contact_id int null, plant_miles_test int null, percent_plant_tested decimal(10,4) null, test_start_date datetime null, test_end_date datetime null, test_result_10logioo float null, test_result_10logi3000 float null, test_equipment_make varchar(50) null, test_equipment_model varchar(50) null, test_frequency decimal(10,4) null ) create table dbo.SIGNAL_LEAKAGE_INFO ( cli_id synthetic_key_id not null, application_id synthetic_key_id null, subsidiary_id synthetic_key_id null, contact_id synthetic_key_id null, aero_frequencies_used yes_no_question null, reference_subsidiary_id synthetic_key_id null, mail_out_date datetime null, contact_phone_number varchar(20) null ) create table dbo.SIGNAL_LEAKAGE_VIOLATION ( violation_id int not null, cli_id int not null, location varchar(255) not null, date_repaired datetime null, date_found datetime not null, location_in_test char(1) not null, uV_m_measurement decimal(10,4) not null, radius decimal(10,4) null ) create table dbo.SITE ( site_id int not null, license_id int null, site_type char(2) not null, registration_number varchar(50) null, site_sequence smallint not null, antenna_sketch_type char(2) null, channel_record_number smallint not null, path_number smallint not null, station_class char(1) null, path_sequence int null, operation_mode char(1) null, primary_site char(1) not null, structure_height_feet decimal(11,7) null, site_community varchar(255) null, structure_height_meters decimal(11,7) not null, county_code varchar(20) null, elevation_feet decimal(11,7) null, location varchar(255) null, state char(2) null, elevation_meters decimal(11,7) null, path_distance_miles decimal(7,2) null, latitude char(7) null, path_distance_kilometers decimal(11,7) not null, latitude_direction char(1) null, longitude char(7) null, asimuth decimal(6,3) null, community_id int null, longitude_direction char(1) null, faa_markings varchar(255) null, datum char(1) null, building_height_meters decimal(11,7) null, mobile_svc_area varchar(255) null, input_site_id int null, emission_code varchar(20) null, fips_code int null, o_degrees smallint null, o_minutes smallint null, o_seconds decimal(3,1) null, a_degrees smallint null, a_minutes smallint null, a_seconds decimal(3,1) null, tower_config varchar(25) null, manner_of_compliance text null, receiver_community_name varchar(255) null, receiver_cable_operator varchar(255) null ) create table dbo.SITE_ANTENNA_PATH ( path_id int not null, path_number int not null, site_id int null, antenna_id int null, channel_grp_id int null ) create table dbo.SUBSIDIARY_COMMUNITY_ADDRESS ( subsidiary_address_id int not null, subsidiary_id int not null, community_id int not null, address_id int not null, update_date datetime null, tin_id int null ) create table dbo.SUBSIDIARY_CONTACT ( subsidiary_contact_id int not null, contact_id int not null, subsidiary_id int not null ) create table dbo.SUBSIDIARY_SIGNON ( subsidiary_id synthetic_key_id not null, signon_id synthetic_key_id not null )