<?xml version="1.0" encoding="utf-8"?>
|
<hibernate-mapping p1:Guid="8e63e51f-a14d-4100-a1ad-eaad021dffeb" xmlns:p1="http://devart.com/schemas/EntityDeveloper/1.0" xmlns="urn:nhibernate-mapping-2.2">
|
<class name="TaiPower.Dmm.Model.CONNECTIVITY" table="CONNECTIVITY" schema="BASEDB" p1:Guid="e6c586ea-eb11-407f-b15e-aa64ad19b54d">
|
<composite-id>
|
<key-property name="FSC" type="Int32" p1:ValidateRequired="true" p1:Guid="c13a4bf0-9754-443b-bf6b-4b2eafec4605">
|
<column name="FSC" not-null="true" precision="5" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</key-property>
|
<key-property name="UFID" type="Int64" p1:ValidateRequired="true" p1:Guid="d1176a72-3e0e-49bf-a320-afb1218adf5f">
|
<column name="UFID" not-null="true" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</key-property>
|
</composite-id>
|
<property name="N1" type="Int64" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="dcb4d341-860a-4edb-b760-dc7a2d62f5d7">
|
<column name="N1" not-null="false" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="N2" type="Int64" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="e72365cc-633d-4121-84c1-d973696c8c9f">
|
<column name="N2" not-null="false" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="FDR1" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="5ca55fe0-721b-4df4-b845-0252ff3076df">
|
<column name="FDR1" not-null="false" precision="5" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="FDR2" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="5d3dc55b-e548-4f61-93ba-2ab6dd1920eb">
|
<column name="FDR2" not-null="false" precision="5" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="DIR" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="ceb66227-1ae9-4917-a80a-45abf1feb50c">
|
<column name="DIR" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="OHUG" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="0e94923d-78c5-49a1-86db-5d9060cbdc8d">
|
<column name="OHUG" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="OSTATUS" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="93f7584e-7205-4025-9f70-7895bcf11e70">
|
<column name="OSTATUS" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="PHASE" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="3f175b85-37d1-4ee2-b6a8-49bf486b67d8">
|
<column name="PHASE" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="X" type="Double" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="20fab364-3b62-470c-94e1-0d4c65b23c5b">
|
<column name="X" not-null="false" precision="10" scale="3" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="Y" type="Double" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="e8458aa3-2b72-4c5b-aa20-29dee2debdbe">
|
<column name="Y" not-null="false" precision="10" scale="3" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="TaiPower.Dmm.Model.HICUSTOMER" table="HICUSTOMER" schema="BASEDB" p1:Guid="b0548db6-7d45-4597-a087-de40464eaae0">
|
<id name="UFID" type="Int64" p1:ValidateRequired="true" p1:Guid="9134d2df-1b16-4dc7-86a3-3e734582c7bd">
|
<column name="UFID" not-null="true" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</id>
|
<property name="OWNERFSC" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="37777a5f-518d-4978-9d4a-ae01ef0c63c7">
|
<column name="OWNERFSC" not-null="false" precision="5" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="OWNERUFID" type="Int64" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="a57676ae-6d5a-4be7-98f3-d07d0f723d0c">
|
<column name="OWNERUFID" not-null="false" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="OWNERTPCLID" type="String" p1:nullable="true" p1:ValidateMaxLength="11" p1:ValidateRequired="false" p1:Guid="3b46295a-e24c-4ac8-bfaf-627f9de9af65">
|
<column name="OWNERTPCLID" not-null="false" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="NAME1" type="String" p1:nullable="true" p1:ValidateMaxLength="40" p1:ValidateRequired="false" p1:Guid="db76aa5e-6905-436b-84ba-b5c08bf37b86">
|
<column name="NAME1" not-null="false" length="40" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="GROUP1" type="String" p1:nullable="true" p1:ValidateMaxLength="3" p1:ValidateRequired="false" p1:Guid="4f50933e-90bf-4dc7-bc87-2c2a83a7e98e">
|
<column name="GROUP1" not-null="false" length="3" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="HICUSCAPACITY" type="Double" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="9808b669-f3b3-47a7-af4b-a8a5239b5ca5">
|
<column name="HICUS_CAPACITY" not-null="false" precision="10" scale="3" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="METRNUMB" type="String" p1:nullable="true" p1:ValidateMaxLength="11" p1:ValidateRequired="false" p1:Guid="addafce8-f232-412f-a4d4-7320cc5eee80">
|
<column name="METR_NUMB" not-null="false" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="VLEVEL" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="3937324a-a95b-4c4d-b265-6eb050372110">
|
<column name="VLEVEL" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="CABTYPE" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="ff577b19-c477-4333-af52-91835c71e5a9">
|
<column name="CABTYPE" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="TaiPower.Dmm.Model.METER" table="METER" schema="BASEDB" p1:Guid="9b84a7b1-5547-4536-935c-9b5214d82627">
|
<id name="METRNUMB" type="String" p1:ValidateMaxLength="11" p1:ValidateRequired="true" p1:Guid="d0f0421e-ced2-4510-a37b-a03ce4b70d86">
|
<column name="METR_NUMB" not-null="true" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</id>
|
<property name="BILLCYCL" type="String" p1:nullable="true" p1:ValidateMaxLength="4" p1:ValidateRequired="false" p1:Guid="ef302618-79cc-4417-a771-3accb154d097">
|
<column name="BILL_CYCL" not-null="false" length="4" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="TRANCORD" type="String" p1:nullable="true" p1:ValidateMaxLength="34" p1:ValidateRequired="false" p1:Guid="4312b176-165c-4c34-a4dc-37a9c7d8c012">
|
<column name="TRAN_CORD" not-null="false" length="34" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="CUSTTYPE" type="String" p1:nullable="true" p1:ValidateMaxLength="2" p1:ValidateRequired="false" p1:Guid="7049028d-3fab-4a84-9a20-f9bfaca38c53">
|
<column name="CUST_TYPE" not-null="false" length="2" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="TELENUMB" type="String" p1:nullable="true" p1:ValidateMaxLength="24" p1:ValidateRequired="false" p1:Guid="b83bf9f6-c3e8-4267-b80e-243f9769e15c">
|
<column name="TELE_NUMB" not-null="false" length="24" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="VAIDDATE" type="String" p1:nullable="true" p1:ValidateMaxLength="7" p1:ValidateRequired="false" p1:Guid="d0db28df-baa6-4b59-b50c-9dc8074c8ceb">
|
<column name="VAID_DATE" not-null="false" length="7" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="ENTRDATE" type="String" p1:nullable="true" p1:ValidateMaxLength="7" p1:ValidateRequired="false" p1:Guid="44d29ebf-eaaa-4503-b64d-c0f4273e7ec6">
|
<column name="ENTR_DATE" not-null="false" length="7" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="TaiPower.Dmm.Model.MSTADDR" table="MSTADDR" schema="BASEDB" p1:Guid="4eefd017-d084-493a-8431-c3a91905c313">
|
<id name="MCUSTNO" type="String" p1:ValidateMaxLength="11" p1:ValidateRequired="true" p1:Guid="f0b85964-2603-41db-a819-1f1ebb16ef60">
|
<column name="M_CUST_NO" not-null="false" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</id>
|
<property name="MCYCLE" type="String" p1:nullable="true" p1:ValidateMaxLength="2" p1:ValidateRequired="false" p1:Guid="5799a75e-6af5-4b80-b4d2-fc2555dac842">
|
<column name="M_CYCLE" not-null="false" length="2" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="MNAME" type="String" p1:nullable="true" p1:ValidateMaxLength="50" p1:ValidateRequired="false" p1:Guid="c9cd988a-4a8d-4791-ad08-0e4eea356917">
|
<column name="M_NAME" not-null="false" length="50" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="MADDR" type="String" p1:nullable="true" p1:ValidateMaxLength="100" p1:ValidateRequired="false" p1:Guid="ac203d87-d2d5-4ca9-bfd8-23da2478eda6">
|
<column name="M_ADDR" not-null="false" length="100" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="MAZIP" type="String" p1:nullable="true" p1:ValidateMaxLength="5" p1:ValidateRequired="false" p1:Guid="e64909fc-bf44-452e-9e6f-f4882cff88c5">
|
<column name="M_AZIP" not-null="false" length="5" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="MMARK" type="String" p1:nullable="true" p1:ValidateMaxLength="1" p1:ValidateRequired="false" p1:Guid="3f6ab9c5-595c-44c5-8bed-796158ac6573">
|
<column name="M_MARK" not-null="false" length="1" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="MNAMEE" type="String" p1:nullable="true" p1:ValidateMaxLength="50" p1:ValidateRequired="false" p1:Guid="5720b6b5-4df1-4c0d-94f3-48bcd3b53547">
|
<column name="M_NAME_E" not-null="false" length="50" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="TaiPower.Dmm.Model.SXFMR" table="SXFMR" schema="BASEDB" p1:Guid="0708d8c2-2325-4106-8673-c5f82924130d">
|
<id name="UFID" type="Int64" p1:ValidateRequired="true" p1:Guid="5ba98ad5-bf72-467e-bad2-82114b0380c9">
|
<column name="UFID" not-null="true" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</id>
|
<property name="SXFMRTYPE" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="93a81047-f223-49f5-90a1-96a9d47ba974">
|
<column name="SXFMR_TYPE" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="OWNERFSC" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="15e9970f-0623-4bf2-a16b-94a43fce60d0">
|
<column name="OWNERFSC" not-null="false" precision="5" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="OWNERUFID" type="Int64" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="5cad0334-d4ea-4ad0-a17b-43de5582dce8">
|
<column name="OWNERUFID" not-null="false" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="OWNERTPCLID" type="String" p1:nullable="true" p1:ValidateMaxLength="11" p1:ValidateRequired="false" p1:Guid="26d2dadf-997f-41ae-9ec8-bd9d8ac24c51">
|
<column name="OWNERTPCLID" not-null="false" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="GROUP1" type="String" p1:nullable="true" p1:ValidateMaxLength="3" p1:ValidateRequired="false" p1:Guid="72bc4347-c6d1-449e-bc06-bde0e595145b">
|
<column name="GROUP1" not-null="false" length="3" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="SXFMRCAPACITY1" type="Double" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="de46472e-a550-4b16-8f46-ec32a99ccbf8">
|
<column name="SXFMR_CAPACITY1" not-null="false" precision="10" scale="3" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="SXFMRCAPACITY2" type="Double" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="6c2fca7e-3177-481e-8770-ab83358f04f3">
|
<column name="SXFMR_CAPACITY2" not-null="false" precision="10" scale="3" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="SXFMRCAPACITY3" type="Double" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="2451da16-f4ee-4312-b2a4-03fffa21b7cb">
|
<column name="SXFMR_CAPACITY3" not-null="false" precision="10" scale="3" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="SUPPLYTYPE" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="f4fcbeab-7880-40fd-86e9-26b619b45c87">
|
<column name="SUPPLYTYPE" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="LIGHTTYPE1" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="b2e9e09d-724b-46bc-bb66-8dff6f569bd9">
|
<column name="LIGHTTYPE1" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="LIGHTTYPE2" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="6ec7cfe8-1dd8-4b60-ae82-6cf263ea4c9d">
|
<column name="LIGHTTYPE2" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="LIGHTTYPE3" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="f9d79f4d-c2dd-40bd-9e51-cc34a9e72db3">
|
<column name="LIGHTTYPE3" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="PHASE1" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="8c882421-1f95-480a-a425-d9c7b2756980">
|
<column name="PHASE1" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="PHASE2" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="01969d3b-7687-4b4e-a9c5-012ae1d66401">
|
<column name="PHASE2" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="PHASE3" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="91f325e7-ecef-4392-b2a5-cdff9b8b0b3e">
|
<column name="PHASE3" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="TPCNO1" type="String" p1:nullable="true" p1:ValidateMaxLength="6" p1:ValidateRequired="false" p1:Guid="9f7108c0-ce52-4571-a408-0176785840b5">
|
<column name="TPCNO1" not-null="false" length="6" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="TPCNO2" type="String" p1:nullable="true" p1:ValidateMaxLength="6" p1:ValidateRequired="false" p1:Guid="556a7360-729a-49a0-8f7c-c7849c23bdc7">
|
<column name="TPCNO2" not-null="false" length="6" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="TPCNO3" type="String" p1:nullable="true" p1:ValidateMaxLength="6" p1:ValidateRequired="false" p1:Guid="dcce3277-c2b6-4b73-8b14-868661286c88">
|
<column name="TPCNO3" not-null="false" length="6" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="TCOUNT" type="Int64" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="0b71f011-0811-4428-b6d7-23c02a274bca">
|
<column name="TCOUNT" not-null="false" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="VLEVEL" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="87873e4d-d47c-4924-be92-7b1bde4c5b7d">
|
<column name="VLEVEL" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="CABTYPE" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="b0e05211-0274-4fda-98be-5894d51cb43e">
|
<column name="CABTYPE" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
</class>
|
</hibernate-mapping>
|
