<?xml version="1.0" encoding="utf-8"?>
|
<hibernate-mapping namespace="TaiPower.Dmm.Model.CCS" p1:name="BASEDBModel" p1:Guid="55e82743-0000-46a7-98fe-5b741c2ff0f7" xmlns:p1="http://devart.com/schemas/EntityDeveloper/1.0" xmlns="urn:nhibernate-mapping-2.2">
|
<class name="ADDRCONTRAST" table="ADDR_CONTRAST" schema="CCS" p1:Guid="3ae9e7ab-6cb5-48a6-835a-32410ab2fb11">
|
<composite-id>
|
<key-property name="DEPTID" type="Int32" p1:ValidateRequired="true" p1:Guid="1553195b-60a7-48ba-8e67-72fadc4ae217">
|
<column name="DEPTID" not-null="true" precision="5" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</key-property>
|
<key-property name="CITY" type="String" p1:ValidateMaxLength="20" p1:ValidateRequired="true" p1:Guid="cf33f99e-f0d6-4010-9446-a985ae22f867">
|
<column name="CITY" not-null="true" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</key-property>
|
<key-property name="ROAD" type="String" p1:ValidateMaxLength="20" p1:ValidateRequired="true" p1:Guid="c59cb7c8-7267-4d86-a06a-ca60ea9a7ec9">
|
<column name="ROAD" not-null="true" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</key-property>
|
</composite-id>
|
<property name="TOWN" type="String" p1:nullable="true" p1:ValidateMaxLength="20" p1:ValidateRequired="false" p1:Guid="569edd0b-ee9d-4bb0-b84e-1337e3422237">
|
<column name="TOWN" not-null="false" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="ALARMIP" table="ALARM_IP" schema="CCS" p1:Guid="dd759833-ca23-4ce9-acdf-377534db1c18">
|
<id name="DEPTID" type="Int32" p1:ValidateRequired="true" p1:Guid="78d6e8b9-24e4-476b-9545-c0122f1a9897">
|
<column name="DEPTID" not-null="true" precision="5" scale="0" sql-type="NUMBER" unique="true" p1:unicode="false" />
|
</id>
|
<property name="IP1" type="String" p1:ValidateMaxLength="20" p1:ValidateRequired="true" p1:Guid="c009f732-106f-4e8c-8e24-1336f0f8336b">
|
<column name="IP1" not-null="true" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="IP2" type="String" p1:nullable="true" p1:ValidateMaxLength="20" p1:ValidateRequired="false" p1:Guid="8bedbe5d-0ac5-452b-a7e4-0d63db15c280">
|
<column name="IP2" not-null="false" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="IPPATROL" type="String" p1:ValidateMaxLength="20" p1:ValidateRequired="true" p1:Guid="254c7035-fac1-46d0-8595-314d795bb598">
|
<column name="IP_PATROL" not-null="true" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="CODELIST" table="CODELIST" schema="CCS" p1:Guid="f917c34b-3546-4a02-b157-face97ab7b8e">
|
<composite-id>
|
<key-property name="INDEXID" type="Int32" p1:ValidateRequired="true" p1:Guid="63eae86e-bf8e-4fef-8311-d440dd0d0394">
|
<column name="INDEXID" not-null="false" precision="5" scale="0" sql-type="NUMBER" unique-key="KEY1" p1:unicode="false" />
|
</key-property>
|
<key-property name="KEYID" type="Int32" p1:ValidateRequired="true" p1:Guid="2138968e-d8ae-4583-8a75-3fe0696224ea">
|
<column name="KEYID" not-null="false" precision="4" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</key-property>
|
</composite-id>
|
<property name="ITEM" type="String" p1:nullable="true" p1:ValidateMaxLength="20" p1:ValidateRequired="false" p1:Guid="2ff060bf-8f60-4d9b-a1d3-94599308b242">
|
<column name="ITEM" not-null="false" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="CONTENT" type="String" p1:nullable="true" p1:ValidateMaxLength="255" p1:ValidateRequired="false" p1:Guid="8270869f-608d-4854-af7c-123f0298cf99">
|
<column name="CONTENT" not-null="false" length="255" sql-type="VARCHAR2" unique-key="KEY1" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="DEPTCONTRAST" table="DEPT_CONTRAST" schema="CCS" p1:Guid="901477dc-42d0-4cce-921b-e16c7d5d4bf7">
|
<composite-id>
|
<key-property name="SCCODE" type="String" p1:ValidateMaxLength="5" p1:ValidateRequired="true" p1:Guid="ded87e20-b670-43d1-bde2-98450d136b27">
|
<column name="SC_CODE" not-null="true" length="5" sql-type="VARCHAR2" p1:unicode="false" />
|
</key-property>
|
<key-property name="DEPTCODE" type="String" p1:ValidateMaxLength="5" p1:ValidateRequired="true" p1:Guid="3f2555cc-b8e4-4dcb-b5b2-b6da8b2f450c">
|
<column name="DEPT_CODE" not-null="true" length="5" sql-type="VARCHAR2" p1:unicode="false" />
|
</key-property>
|
</composite-id>
|
<property name="MAXMETER" type="String" p1:nullable="true" p1:ValidateMaxLength="11" p1:ValidateRequired="false" p1:Guid="8b019785-9d42-4806-af22-c5692e481f90">
|
<column name="MAX_METER" not-null="false" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="MINMETER" type="String" p1:nullable="true" p1:ValidateMaxLength="11" p1:ValidateRequired="false" p1:Guid="60eba512-7d0e-44e7-8aed-b0e2c061dbf3">
|
<column name="MIN_METER" not-null="false" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="EVENTQUERY" table="EVENTQUERY" schema="CCS" p1:Guid="b4e10259-e54e-4534-8fcc-b0f77b76c76f">
|
<id name="CCSID" type="String" p1:ValidateMaxLength="11" p1:ValidateRequired="true" p1:Guid="95ce058b-0693-40f7-ad83-8dac904e07e8">
|
<column name="CCSID" not-null="true" length="11" sql-type="VARCHAR2" unique="true" p1:unicode="false" />
|
</id>
|
<property name="METER" type="String" p1:nullable="true" p1:ValidateMaxLength="11" p1:ValidateRequired="false" p1:Guid="9f9ef924-57c3-43fc-911f-93bf401717b4">
|
<column name="METER" not-null="false" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="CASESTATUS" type="Int32" p1:ValidateRequired="true" p1:Guid="23d91413-307d-486f-ad4e-fa11eea9f771">
|
<column name="CASESTATUS" not-null="true" precision="5" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="CHANGETIME" type="DateTime" p1:ValidateRequired="true" p1:Guid="3096e5c3-dbc7-4527-944f-d47dbd9a9626">
|
<column name="CHANGETIME" not-null="true" sql-type="DATE" p1:unicode="false" />
|
</property>
|
<property name="HANDLINGSUMMARY" type="String" p1:nullable="true" p1:ValidateMaxLength="600" p1:ValidateRequired="false" p1:Guid="9d270db0-ef7c-4072-81b6-fdb021d6c297">
|
<column name="HANDLINGSUMMARY" not-null="false" length="600" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="ASSUMEDTIME" type="DateTime" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="564f42b9-9315-4ca0-bbb6-0f4c14e2e6ee">
|
<column name="ASSUMEDTIME" not-null="false" sql-type="DATE" p1:unicode="false" />
|
</property>
|
<property name="ASSUMEDTIMENTH" type="DateTime" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="b96b2a8b-a23d-45d9-9b09-8710849ca424">
|
<column name="ASSUMEDTIME_NTH" not-null="false" sql-type="DATE" p1:unicode="false" />
|
</property>
|
<property name="DELAYTIMES" type="Boolean" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="18e22d1e-02a4-442c-aacb-03aea7cb4793">
|
<column name="DELAYTIMES" not-null="false" precision="1" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="REASON" type="String" p1:nullable="true" p1:ValidateMaxLength="255" p1:ValidateRequired="false" p1:Guid="dd069840-7e36-47e9-95b9-11270603b8fc">
|
<column name="REASON" not-null="false" length="255" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="EVENTLOCATION" type="String" p1:nullable="true" p1:ValidateMaxLength="255" p1:ValidateRequired="false" p1:Guid="1f67beaf-1f05-4373-b7fc-242089696332">
|
<column name="EVENTLOCATION" not-null="false" length="255" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="ERRORCAUSE" type="String" p1:nullable="true" p1:ValidateMaxLength="800" p1:ValidateRequired="false" p1:Guid="6311d799-befc-4ebc-9474-6fd984c5eca0">
|
<column name="ERRORCAUSE" not-null="false" length="800" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="INPUTTIME" type="DateTime" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="928f4102-77d2-486c-bd73-d85b109cf6e4">
|
<column name="INPUTTIME" not-null="false" sql-type="DATE" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="EVENTRECORD" table="EVENTRECORD" schema="CCS" p1:Guid="3624b3da-ecaf-494e-a7e1-93c62b2f44d4">
|
<id name="CCSID" type="String" p1:ValidateMaxLength="11" p1:ValidateRequired="true" p1:Guid="1cb5ab30-64a6-4f0d-afea-8bb064de08cc">
|
<column name="CCSID" not-null="true" length="11" sql-type="VARCHAR2" unique="true" p1:unicode="false" />
|
</id>
|
<property name="METER" type="String" p1:nullable="true" p1:ValidateMaxLength="11" p1:ValidateRequired="false" p1:Guid="83ef2250-a63b-48a9-8737-ca434a1fc26a">
|
<column name="METER" not-null="false" length="11" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="CUSTOMERNAME" type="String" p1:nullable="true" p1:ValidateMaxLength="50" p1:ValidateRequired="false" p1:Guid="ad687bcd-bae6-4746-b907-812f4b3a7089">
|
<column name="CUSTOMERNAME" not-null="false" length="50" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="CUSTOMERTEL" type="String" p1:nullable="true" p1:ValidateMaxLength="24" p1:ValidateRequired="false" p1:Guid="bab7c163-2aa8-479b-87dd-fdf29b8b81d7">
|
<column name="CUSTOMERTEL" not-null="false" length="24" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="ADDRCITY" type="String" p1:ValidateMaxLength="6" p1:ValidateRequired="true" p1:Guid="f9b18d05-9764-4300-a48d-72866739d6bc">
|
<column name="ADDR_CITY" not-null="true" length="6" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="ADDRTOWN" type="String" p1:nullable="true" p1:ValidateMaxLength="10" p1:ValidateRequired="false" p1:Guid="03480822-2f3d-49a2-9347-37854e77a821">
|
<column name="ADDR_TOWN" not-null="false" length="10" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="ADDRROAD" type="String" p1:ValidateMaxLength="20" p1:ValidateRequired="true" p1:Guid="70c0b450-5da3-4769-9425-7c439f5b34a8">
|
<column name="ADDR_ROAD" not-null="true" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="ADDROTHER" type="String" p1:nullable="true" p1:ValidateMaxLength="66" p1:ValidateRequired="false" p1:Guid="c97a9eb0-928d-470b-a9da-8b265830163e">
|
<column name="ADDR_OTHER" not-null="false" length="66" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="RECALLNAME" type="String" p1:nullable="true" p1:ValidateMaxLength="20" p1:ValidateRequired="false" p1:Guid="f28ae4ec-65f8-46ea-8a85-a3d73bca17a8">
|
<column name="RECALLNAME" not-null="false" length="20" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="RECALLTEL" type="String" p1:nullable="true" p1:ValidateMaxLength="24" p1:ValidateRequired="false" p1:Guid="2d8c3f99-fc7e-4381-be8a-fedbf6c29f05">
|
<column name="RECALLTEL" not-null="false" length="24" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="EVENTBRIEF" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="e5b3f0b6-bd74-4194-a28e-c06a5acd8d75">
|
<column name="EVENTBRIEF" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="ACCEPTTIME" type="DateTime" p1:ValidateRequired="true" p1:Guid="7d6fd376-b83e-45b2-a469-9c9f8d5ee15c">
|
<column name="ACCEPTTIME" not-null="true" sql-type="DATE" p1:unicode="false" />
|
</property>
|
<property name="IMPORTCASE" type="Boolean" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="136c559c-0c94-4a8a-9fee-1a80171ef06b">
|
<column name="IMPORTCASE" not-null="false" precision="1" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="DEPT" type="String" p1:ValidateMaxLength="2" p1:ValidateRequired="true" p1:Guid="424a1dd4-acd4-4973-88e6-490371d36089">
|
<column name="DEPT" not-null="true" length="2" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="PARTHICUSTOMER" type="Int32" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="1be3f5b6-0b8e-4479-b0b7-26ca660029c6">
|
<column name="PARTHICUSTOMER" not-null="false" precision="3" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="NOTE" type="String" p1:nullable="true" p1:ValidateMaxLength="255" p1:ValidateRequired="false" p1:Guid="3a0fac23-d2fd-4210-98fd-ebf78e73350b">
|
<column name="NOTE" not-null="false" length="255" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="NUMCONTRAST" table="NUM_CONTRAST" schema="CCS" p1:Guid="0a0a9bb4-f3ff-4e45-a082-f6b813522c2e">
|
<composite-id>
|
<key-property name="CCSID" type="String" p1:ValidateMaxLength="11" p1:ValidateRequired="true" p1:Guid="aad384dd-523c-46ea-9ce6-ef9f70211c17">
|
<column name="CCSID" not-null="true" length="11" sql-type="VARCHAR2" unique="true" p1:unicode="false" />
|
</key-property>
|
<key-property name="ACCEPTNUM" type="String" p1:ValidateMaxLength="10" p1:ValidateRequired="true" p1:Guid="13fd3577-630e-497f-890a-aef358e22d48">
|
<column name="ACCEPTNUM" not-null="true" length="10" sql-type="VARCHAR2" p1:unicode="false" />
|
</key-property>
|
<key-property name="CASEID" type="Int64" p1:ValidateRequired="true" p1:Guid="5c6851f5-9274-4939-84fb-56a5c0348920">
|
<column name="CASEID" not-null="true" precision="10" scale="0" sql-type="NUMBER" p1:unicode="false" />
|
</key-property>
|
</composite-id>
|
</class>
|
<class name="SCGROUP" table="SCGROUP" schema="CCS" p1:Guid="44b90e65-430c-47de-a4a2-3da5bdfb07a6">
|
<id name="GROUPID" type="Decimal" p1:ValidateRequired="true" p1:Guid="4e69791b-6720-4f0c-9c33-bb9f2dd126c5">
|
<column name="GROUPID" not-null="true" sql-type="NUMBER" p1:unicode="false" />
|
</id>
|
<property name="SCCODE" type="String" p1:nullable="true" p1:ValidateMaxLength="5" p1:ValidateRequired="false" p1:Guid="8e591627-84f6-412a-a59e-2dc7c5eab264">
|
<column name="SC_CODE" not-null="false" length="5" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="SSCCODE" type="String" p1:nullable="true" p1:ValidateMaxLength="5" p1:ValidateRequired="false" p1:Guid="219cdec1-1985-4831-8470-2a243615150d">
|
<column name="SSC_CODE" not-null="false" length="5" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="SCGROUPTIME" table="SCGROUPTIME" schema="CCS" p1:Guid="584e6fb7-e44d-40b6-b521-20bffabaa868">
|
<id name="GROUPID" type="Decimal" p1:ValidateRequired="true" p1:Guid="85cfb814-4ec8-4209-bfe1-7eeb2945fcc8">
|
<column name="GROUPID" not-null="true" sql-type="NUMBER" unique-key="KEY1" p1:unicode="false" />
|
</id>
|
<property name="WEEK" type="Decimal" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="2d374a4d-c438-416a-988c-b15ad53f6ae2">
|
<column name="WEEK" not-null="false" sql-type="NUMBER" unique-key="KEY1" p1:unicode="false" />
|
</property>
|
<property name="BEGINTIME" type="Decimal" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="d5b5aa69-4d71-4c80-b1a3-f4454f389ef2">
|
<column name="BEGINTIME" not-null="false" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
<property name="ENDTIME" type="Decimal" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="e9ccfb93-1bb3-48c2-a635-40c407c83845">
|
<column name="ENDTIME" not-null="false" sql-type="NUMBER" p1:unicode="false" />
|
</property>
|
</class>
|
<class name="TMP" table="TMP" schema="CCS" p1:Guid="84138ca0-4dd3-4130-9480-7c52e0fc4105">
|
<id name="CCSID" type="String" p1:ValidateMaxLength="10" p1:ValidateRequired="true" p1:Guid="965b5bbc-576c-44c6-bf68-04b842b49601">
|
<column name="CCSID" not-null="false" length="10" sql-type="VARCHAR2" p1:unicode="false" />
|
</id>
|
<property name="USERNAME" type="String" p1:nullable="true" p1:ValidateMaxLength="100" p1:ValidateRequired="false" p1:Guid="d46740de-4137-44e6-b174-a35a3dbfc365">
|
<column name="USERNAME" not-null="false" length="100" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
<property name="ACCEPTTIME" type="DateTime" p1:nullable="true" p1:ValidateRequired="false" p1:Guid="e30ce78f-9d20-4513-9948-3f908652ddd2">
|
<column name="ACCEPTTIME" not-null="false" sql-type="DATE" p1:unicode="false" />
|
</property>
|
<property name="ACTION" type="String" p1:nullable="true" p1:ValidateMaxLength="100" p1:ValidateRequired="false" p1:Guid="97068ccd-ae40-470e-bf11-534bd7862f15">
|
<column name="ACTION" not-null="false" length="100" sql-type="VARCHAR2" p1:unicode="false" />
|
</property>
|
</class>
|
</hibernate-mapping>
|
