毕设ER2018

A.MAINTENA_FACTORY_INFO_ID=F.MAINTENA_FACTORY_INFO_ID

CP_BS_ELEC_AUDIT（H）

CP_BS_ELEC_AUDIT_ID POLITICAL_AREA_ID POLITICAL_AREA_NAME MAINTAIN_AREA_ID MAINTAIN_AREA_NAME BASE_STATION_ID BASE_STATION_NAME BASE_STATION_CODE BASE_STATION_TYPE_NAME STATION_CLASS STATION_CLASS_NAME ELEC_CONTRACT_ID CONTRACT_NO MAINTENA_FACTORY_INFO_ID MAINTENA_FACTORY_INFO_NAME UNIQUE_CODE ELEC_MONEY_COUNT TOLL_CYCLE PAY_WAY CHECK_NUMBER RECIPIENT_SIGN INVOICE_RETURN INVOICE_RETURN_DATE LAST_RECIPIENT_UNIT REMARKS AUDIT_GRADE AUDIT_STATUS DATA_SOURCE PAY_YEAR PAY_MONTH IS_METER METER_COMPARE BATCH_NO STATE STATE_DATE METER_DATE CP_BS_PRICE_ARISE_APPLY_ID ARISE_APPLY_NAME INVOICE_TYPE IS_INVOICE STATION_STATUS BASE_STATION_STATUS RIGHT_BELONG BASE_STATION_RIGHT_BELONG BACK_INVOICE_REASON IS_PAUSE PAUSE_TIME PAUSED_TIME SUPPLIER_NAME SUPPLIER_CODE ACCOUNT_TYPE IS_STAFF_PAY_MENT INPUT_VAT TELECOM_PAYMENT_AMOUNT UNICOM_PAYMENT_AMOUNT MOBILE_PAYMENT_AMOUNT TOWER_PAYMENT_AMOUNT IS_DAIWEI_PAY_MENT IS_CHANGE_NAME CHANGE_REASON YEAR_RENT FIRST_PART BEGIN_DATE END_DATE STATION_TYPE STATION_PROPERTY_TYPE STATION_LEVEL PAY_WAYS ELEC_USE_TYPE SUPPLY_ELEC_WAYS PRODUCTION ELEC_SURE IS_AIR_CONDITIONER SITE_ID SITE_NAME TOWER_NAME TOWER_CODE

A.BASE_STATION_ID=B.BASE_STATION_ID

CP_BASE_STATION_AREA(D)

BASE_STATION_AREA_ID BASE_STATION_AREA_NAME BASE_STATION_AREA_CODE PARENT_ID DISPLAY_INDEX PATH_NAME PATH_CODE STATE STATE_DATE

CP_COMMON_DATA(C)

DATA_NAME DATA_VALUE DATA_TYPE EXTRA_DATA

CP_BASE_STATION_TYPE（E）

BASE_STATION_TYPE_ID BASE_STATION_TYPE_NAME BASE_STATION_TYPE_CODE STATE STATE_DATE

A.BASE_STATION_ID=H.BASE_STATION_ID

CP_ELEC_CONTRACT（G）

BASE_STATION_CODE CONTRACT_CODE RAW_BASE_STATION_NAME STD_BASE_STATION_NAME FEEPAY_BASE_STATION_NAME RES_BASE_STATION_NAME ABHEAP CONTRACT_PROP RING_AREA_NAME POLITICAL_AREA_NAME MAINTAIN_AREA_NAME BASE_STATION_ADDR MAINTENA_FACTORY_INFO_NAME RAW_CONTRACT_NO RENEWAL_CONTRACT_NO CONTRACT_NO SUPPLY_CONTRACT_NO FIRST_PART FEE_UNIT BEGIN_DATE END_DATE YEAR_LIMIT YEAR_RENT TOTAL_AMOUNT DESCRIPTION PAY_DATE PAY_CYCLE PAY_WAY AGENT MEMO RING_AREA_ID POLITICAL_AREA_ID MAINTAIN_AREA_ID BASE_STATION_ID STATE STATE_DATE ELEC_CONTRACT_ID STATUS BASE_STATION_TYPE_ID QUERY_SERIALNO TERMINATED CONTRACT_CLASS ELEC_PRICE TOLL_CYCLE BASE_STATION_AREA_ID BASE_STATION_AREA_NAME FP_SIGN_PERSON ADD_CONTRACT_NO RENEW_CONTRACT_NO RENEW_CONTRACT_NO2 RENEW_CONTRACT_NO3 INIT_CONTRACT_NO NPAY_DATE RPAY_DATE PATH_CODE ROOM_ADDR STATION_ORDER CLASSIFY REQUIRE_NUMBER TOWER_ADDRESS

CP_BASE_STATION (A)

BASE_STATION_ID BASE_STATION_AREA_ID BASE_STATION_NAME BASE_STATION_CODE STATION_STATUS BASE_STATION_TYPE_ID MAINTENA_FACTORY_INFO_ID MAINTENA_FACTORY_INFO_NAME ROOM_SYSTEM_NAME START_USE_DATE RIGHT_BELONG EQUIP_NUM STATION_ADDR CONTRACT_ID CONTRACT_NO STATE STATE_DATE STATION_CLASS UNIQUE_CODE SHOW_ORDER IS_USE STATION_USE_TRACK BUILD_SHARE_JOIN BUILD_STRUCTURE IS_PICKET SITE_ID SITE_NAME STATION_TYPE STATION_PROPERTY_TYPE STATION_LEVEL PAY_WAYS ELEC_USE_TYPE SUPPLY_ELEC_WAYS PRODUCTION ELEC_SURE IS_AIR_CONDITIONER SITE_TYPE WEBMASTER_SITE_NAME WEBMASTER_SITE_CODE SITE_LEVEL TOWER_CODE TOWER_NAME ORDER_ID POWER_USE_ID

A.CONTRACT_ID=G.ELEC_CONTRACT_ID

MAINTENA_FACTORY_INFO（F）

MAINTENA_FACTORY_INFO_ID MAINTENA_FACTORY_INFO_NAME STATE STATE_DATE

CP_STATION_POWER_INFO(B)

CP_STATION_POWER_INFO_ID BASE_STATION_ID G2_ELECTRICITY G3_ELECTRICITY OTHER_ELECTRICITY UNICOM_ELECTRICITY MOBILE_ELECTRICITY EQUIPMENT_POWER RENT_SHARE CREATE_STAFF_ID CREATE_STAFF_NAME CREATE_DATE TOTAL_ELECTRICITY LOGIC_STATION_NUM FAN_NUM BASE_LENGTH BASE_WIDE BASE_HEIGHT BASE_TOTAL_AREA STATE STATE_DATE TOTAL_AIR_POWER STATION_ELEC_CLASS CARRIER_NUMBER TELE_FAN_NUM TELE_CARRIER_NUMBER IS_COMPLETE

A.BASE_STATION_AREA_ID=D.BASE_STATION_AREA_ID

A.STATION_ELEC_CLASS=C.DATA_VALUE

A.BASE_STATION_TYPE_ID=E.BASE_STATION_TYPE_ID