# user_db

types: SQLite
group_name: Tadpole System
display_name: TadpoleSystem-SR11
create_time: 2013-02-07 17:45:26
delYn: NO
operation_type: REAL
is_profile: YES
question_dml: YES
url:
  jdbc:sqlite:/C:\Users\hangum\git\TadpoleForDBTools-sr11\targetProject\rap-gef\configuration\tadpole\db\tadpole-system.db

db:
  C:\Users\hangum\git\TadpoleForDBTools-sr11\targetProject\rap-gef\configuration\tadpole\db\tadpole-system.db


types: SQLite
group_name: Tadpole System
display_name: New Desing Tadpole
create_time: 2013-02-08 01:25:01
delYn: NO
operation_type: DEVELOP
is_profile: NO
question_dml: YES
url:
  jdbc:sqlite:/C:\Users\hangum\git\TadpoleForDBTools-sr11\targetProject\rap-gef\configuration\tadpole\db\SR11-tadpole-system.db

db:
  C:\Users\hangum\git\TadpoleForDBTools-sr11\targetProject\rap-gef\configuration\tadpole\db\SR11-tadpole-system.db


# user_db_resource_data

datas:
  <?xml version="1.0" encoding="UTF-8"?>
  <rdb:DB xmlns:rdb="http://com.hangum.tadpole.rdb.model.ERDInfo" dbType="SQLite (TadpoleSystem-SR11, jdbc:sqlite:/C:\Users\hangum\git\TadpoleForDBTools-sr11\targetProject\rap-gef\configuration\tadpole\db\tadpole-system.db)" url="jdbc:sqlite:/C:\Users\hangum\git\TadpoleForDBTools-sr11\targetProject\rap-gef\configuration\tadpole\db\tadpole-system.db" id="">
    <tables name="ext_account" constraints="1020,516,-1,-1" incomingLinks="//@references.3" outgoingLinks="//@references.1">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="user_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="types" type="VARCHAR(100)" null="NO" extra="" key=""/>
      <columns field="name" type="VARCHAR(1000)" null="NO" extra="" key=""/>
      <columns field="value0" type="VARCHAR(1000)" null="NO" extra="" key=""/>
      <columns field="value1" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value2" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value3" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value4" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value5" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value6" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value7" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value8" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value9" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="success" type="VARCHAR(10)" null="YES" extra="" key=""/>
      <columns field="message" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
    </tables>
    <tables name="ta


datas:
  dpole_system" constraints="66,382,-1,-1">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="name" type="VARCHAR(100)" null="NO" extra="" key=""/>
      <columns field="major_version" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="sub_version" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="information" type="VARCHAR(2000)" null="NO" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
    </tables>
    <tables name="user_db" constraints="881,41,-1,-1" incomingLinks="//@references.5 //@references.8" outgoingLinks="//@references.2 //@references.3">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="user_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="ext_seq" type="INTEGER" null="YES" extra="" key=""/>
      <columns field="types" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="url" type="VARCHAR(2000)" null="NO" extra="" key=""/>
      <columns field="db" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="group_name" type="VARCHAR(50)" null="YES" extra="" key=""/>
      <columns field="display_name" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="host" type="VARCHAR(50)" null="YES" extra="" key=""/>
      <columns field="port" type="VARCHAR(10)" null="YES" extra="" key=""/>
      <columns field="locale" type="VARCHAR(10)" null="YES" extra="" key=""/>
      <columns field="passwd" type="VARCHAR(100)" null="YES" extra="" key=""/>
      <columns field="users" type="VARCHAR(100)" null="YES" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
      <columns field="ext1" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="e


datas:
  xt2" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="ext3" type="VARCHAR(2000)" null="YES" extra="" key=""/>
    </tables>
    <tables name="user_db_resource" constraints="480,141,-1,-1" incomingLinks="//@references.6" outgoingLinks="//@references.4 //@references.5">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="types" type="VARCHAR(10)" null="NO" extra="" key=""/>
      <columns field="user_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="db_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="filename" type="VARCHAR(2000)" null="NO" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
    </tables>
    <tables name="user_db_resource_data" constraints="26,174,-1,-1" outgoingLinks="//@references.6">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="user_db_resource_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="datas" type="VARCHAR(2000)" null="NO" extra="" key=""/>
    </tables>
    <tables name="user_group" constraints="95,682,-1,-1" incomingLinks="//@references.0">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="name" type="VARCHAR(60)" null="NO" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
    </tables>
    <tables name="user_info_data" constraints="529,703,-1,-1" outgoingLinks="//@references.7 //@references.8">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="user_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="db_seq" type="INTEGER" null="NO" extra="" key=""/>


datas:
      <columns field="name" type="VARCHAR(40)" null="NO" extra="" key=""/>
      <columns field="value0" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value1" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value2" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value3" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value4" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value5" type="VARCHAR(2000)" null="YES" extra="" key=""/>
    </tables>
    <tables name="users" constraints="445,394,-1,-1" incomingLinks="//@references.1 //@references.2 //@references.4 //@references.7" outgoingLinks="//@references.0">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="group_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="email" type="VARCHAR(60)" null="NO" extra="" key=""/>
      <columns field="passwd" type="VARCHAR(60)" null="NO" extra="" key=""/>
      <columns field="name" type="VARCHAR(60)" null="NO" extra="" key=""/>
      <columns field="user_type" type="VARCHAR(20)" null="NO" default="'user'" extra="" key=""/>
      <columns field="approval_yn" type="VARCHAR(3)" null="NO" default="'NO'" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
    </tables>
    <references source="//@tables.7" target="//@tables.5" source_kind="ONE_MANY" column_name="group_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=users, column_name=group_seq, referenced_table_name=user_group, referenced_column_name=seq]"/>
    <references source="//@tables.0" target="//@tables.7" source_kind="ONE_MANY" column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_


datas:
  name=ext_account, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references source="//@tables.2" target="//@tables.7" source_kind="ONE_MANY" column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references source="//@tables.2" target="//@tables.0" source_kind="ZERO_MANY" target_kind="ZERO_ONE" column_name="ext_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=ext_seq, referenced_table_name=ext_account, referenced_column_name=seq]"/>
    <references source="//@tables.3" target="//@tables.7" source_kind="ONE_MANY" column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references source="//@tables.3" target="//@tables.2" source_kind="ONE_MANY" column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references source="//@tables.4" target="//@tables.3" source_kind="ONE_MANY" column_name="user_db_resource_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource_data, column_name=user_db_resource_seq, referenced_table_name=user_db_resource, referenced_column_name=seq]"/>
    <references source="//@tables.6" target="//@tables.7" source_kind="ONE_MANY" column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_info_data, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references source="//@tables.6" targ


datas:
  et="//@tables.2" source_kind="ONE_MANY" column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_info_data, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
  </rdb:DB>


datas:
  <?xml version="1.0" encoding="UTF-8"?>
  <rdb:DB xmlns:rdb="http://com.hangum.tadpole.rdb.model.ERDInfo" dbType="SQLite (New Desing Tadpole, jdbc:sqlite:/C:\Users\hangum\git\TadpoleForDBTools-sr11\targetProject\rap-gef\configuration\tadpole\db\SR11-tadpole-system.db)" url="jdbc:sqlite:/C:\Users\hangum\git\TadpoleForDBTools-sr11\targetProject\rap-gef\configuration\tadpole\db\SR11-tadpole-system.db" id="">
    <tables name="ext_account" constraints="583,571,-1,-1" incomingLinks="//@references.27" outgoingLinks="//@references.1">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="user_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="types" type="VARCHAR(100)" null="NO" extra="" key=""/>
      <columns field="name" type="VARCHAR(1000)" null="NO" extra="" key=""/>
      <columns field="value0" type="VARCHAR(1000)" null="NO" extra="" key=""/>
      <columns field="value1" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value2" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value3" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value4" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value5" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value6" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value7" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value8" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="value9" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="success" type="VARCHAR(10)" null="YES" extra="" key=""/>
      <columns field="message" type="VARCHAR(1000)" null="YES" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
    </tables>
    <table


datas:
  s name="sqlite_sequence" constraints="16,16,-1,-1">
      <columns field="name" type="" null="YES" extra="" key=""/>
      <columns field="seq" type="" null="YES" extra="" key=""/>
    </tables>
    <tables name="tadpole_system" constraints="166,16,-1,-1">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="name" type="VARCHAR(100)" null="NO" extra="" key=""/>
      <columns field="major_version" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="sub_version" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="information" type="VARCHAR(2000)" null="NO" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
    </tables>
    <tables name="user_db_resource_data" constraints="114,212,-1,-1" outgoingLinks="//@references.15">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="user_db_resource_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="datas" type="VARCHAR(2000)" null="NO" extra="" key=""/>
    </tables>
    <tables name="user_group" constraints="200,353,-1,-1" incomingLinks="//@references.0">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="name" type="VARCHAR(60)" null="NO" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
    </tables>
    <tables name="user_info_data" constraints="1032,34,-1,-1" outgoingLinks="//@references.7 //@references.25">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="user_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="db_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="name" type="VARCHAR(40)" null="NO" extra="" key=""/>
      <columns field="va


datas:
  lue0" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value1" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value2" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value3" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value4" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="value5" type="VARCHAR(2000)" null="YES" extra="" key=""/>
    </tables>
    <tables name="users" constraints="581,312,-1,-1" incomingLinks="//@references.1 //@references.7 //@references.13 //@references.26" outgoingLinks="//@references.0">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="group_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="email" type="VARCHAR(60)" null="NO" extra="" key=""/>
      <columns field="passwd" type="VARCHAR(60)" null="NO" extra="" key=""/>
      <columns field="name" type="VARCHAR(60)" null="NO" extra="" key=""/>
      <columns field="user_type" type="VARCHAR(20)" null="NO" default="'user'" extra="" key=""/>
      <columns field="approval_yn" type="VARCHAR(3)" null="NO" default="'NO'" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
    </tables>
    <tables name="user_db_resource" constraints="543,30,-1,-1" incomingLinks="//@references.15" outgoingLinks="//@references.13 //@references.24">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="types" type="VARCHAR(10)" null="NO" extra="" key=""/>
      <columns field="user_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="db_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="filename" type="VARCHAR(2000)" null="NO" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="dateti


datas:
  me('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
      <columns field="duration_mill" type="INTEGER" null="YES" extra="" key=""/>
      <columns field="execution_result" type="CHAR(3)" null="YES" default="'YES'" extra="" key=""/>
    </tables>
    <tables name="user_db" constraints="1022,362,-1,-1" incomingLinks="//@references.24 //@references.25" outgoingLinks="//@references.26 //@references.27">
      <columns field="seq" type="INTEGER" null="NO" extra="" key="PRI"/>
      <columns field="user_seq" type="INTEGER" null="NO" extra="" key=""/>
      <columns field="ext_seq" type="INTEGER" null="YES" extra="" key=""/>
      <columns field="operation_type" type="VARCHAR(3)" null="NO" default="'001'" extra="" key=""/>
      <columns field="types" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="url" type="VARCHAR(2000)" null="NO" extra="" key=""/>
      <columns field="db" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="group_name" type="VARCHAR(50)" null="YES" extra="" key=""/>
      <columns field="display_name" type="VARCHAR(50)" null="NO" extra="" key=""/>
      <columns field="host" type="VARCHAR(50)" null="YES" extra="" key=""/>
      <columns field="port" type="VARCHAR(10)" null="YES" extra="" key=""/>
      <columns field="locale" type="VARCHAR(10)" null="YES" extra="" key=""/>
      <columns field="passwd" type="VARCHAR(100)" null="YES" extra="" key=""/>
      <columns field="users" type="VARCHAR(100)" null="YES" extra="" key=""/>
      <columns field="create_time" type="DATE" null="YES" default="datetime('now','localtime')" extra="" key=""/>
      <columns field="delYn" type="CHAR(3)" null="YES" default="'NO'" extra="" key=""/>
      <columns field="ext1" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="ext2" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      <columns field="ext3" type="VARCHAR(2000)" null="YES" extra="" key=""/>
      


datas:
  <columns field="is_profile" type="VARCHAR(3)" null="NO" default="'NO'" extra="" key=""/>
      <columns field="profile_select_mill" type="INTEGER(3)" null="NO" default="-1" extra="" key=""/>
      <columns field="question_dml" type="VARCHAR(3)" null="NO" default="'YES'" extra="" key=""/>
    </tables>
    <references source="//@tables.6" target="//@tables.4" source_kind="ONE_MANY" column_name="group_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=users, column_name=group_seq, referenced_table_name=user_group, referenced_column_name=seq]"/>
    <references source="//@tables.0" target="//@tables.6" source_kind="ONE_MANY" column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=ext_account, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references column_name="ext_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=ext_seq, referenced_table_name=ext_account, referenced_column_name=seq]"/>
    <references column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references column_name="user_db_resource_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource_data,


datas:
   column_name=user_db_resource_seq, referenced_table_name=user_db_resource, referenced_column_name=seq]"/>
    <references source="//@tables.5" target="//@tables.6" source_kind="ONE_MANY" column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_info_data, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_info_data, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references column_name="ext_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=ext_seq, referenced_table_name=ext_account, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_info_data, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references source="//@tables.7" target="//@tables.6" source_kind="ONE_MANY" column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table


datas:
  _name=user_db_resource, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references source="//@tables.3" target="//@tables.7" source_kind="ONE_MANY" column_name="user_db_resource_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource_data, column_name=user_db_resource_seq, referenced_table_name=user_db_resource, referenced_column_name=seq]"/>
    <references column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references column_name="ext_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=ext_seq, referenced_table_name=ext_account, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_info_data, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_info_data, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_n


datas:
  ame=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references column_name="ext_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=ext_seq, referenced_table_name=ext_account, referenced_column_name=seq]"/>
    <references source="//@tables.7" target="//@tables.8" source_kind="ONE_MANY" column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db_resource, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references source="//@tables.5" target="//@tables.8" source_kind="ONE_MANY" column_name="db_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_info_data, column_name=db_seq, referenced_table_name=user_db, referenced_column_name=seq]"/>
    <references source="//@tables.8" target="//@tables.6" source_kind="ONE_MANY" column_name="user_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=user_seq, referenced_table_name=users, referenced_column_name=seq]"/>
    <references source="//@tables.8" target="//@tables.0" source_kind="ZERO_MANY" target_kind="ZERO_ONE" column_name="ext_seq" referenced_column_name="seq" constraint_name="ReferencedTableDAO [constraint_name=null, table_name=user_db, column_name=ext_seq, referenced_table_name=ext_account, referenced_column_name=seq]"/>
  </rdb:DB>


datas:
  CREATE TABLE user_db (
       seq INTEGER PRIMARY KEY AUTOINCREMENT ,
       user_seq INTEGER  NOT NULL,
       ext_seq INTEGER,
       operation_type VARCHAR(10) NOT NULL DEFAULT 'DEVELOP',
       types     	VARCHAR(50)  	NOT NULL,
       url			VARCHAR(2000)  	NOT NULL,
       db	VARCHAR(50)  	NOT NULL,
       group_name VARCHAR(50),
       display_name VARCHAR(50)  	NOT NULL,
       host		 VARCHAR(50) 	,
       port		 VARCHAR(10) ,
       locale	VARCHAR(10)		,
       passwd		 VARCHAR(100)  	,
       users		 VARCHAR(100) 	,
       is_profile VARCHAR(3) NOT NULL DEFAULT 'NO',
       profile_select_mill INTEGER(3) NOT NULL DEFAULT -1,
       questionDML VARCHAR(3) NOT NULL DEFAULT 'YES',
       create_time DATE DEFAULT (datetime('now','localtime')),
       delYn CHAR(3) DEFAULT 'NO',
       ext1 VARCHAR(2000),
       ext2 VARCHAR(2000), 
       ext3 VARCHAR(2000),
       FOREIGN KEY (user_seq) REFERENCES users (seq) ON DELETE NO ACTION ON UPDATE NO ACTION,
       FOREIGN KEY (ext_seq) REFERENCES ext_account (seq) ON DELETE NO ACTION ON UPDATE NO ACTION
  );

  /*
  * 000 : 운영‌
  * 001 : ‌개발‌
  * 002 : 기타‌
  */
  ALTER TABLE user_db ADD COLUMN operation_type VARCHAR(10) NOT NULL DEFAULT 'DEVELOP';

  /**
  기‌본값으로 설정하며‌
  	디비 당 프로파일을‌ 설정‌ : DDL‌, ‌DCL, DML‌ 모두‌ 남길‌ 유무‌.  ‌SELECT‌ 문의‌ 경우‌ 몇분‌ 이상‌ 걸리는‌ 쿼리‌ 남길것‌.
  	디비‌ 당‌ 운영서버의‌ 경우‌ : INSERT,UPDATE, DELTE, 문등을‌ 실행할때‌ 묻는‌ 다이얼로그‌ 나올것인지‌???

  	데이터는 user_db_resource‌ 테이블에‌ 남길 것‌.
  	‌select‌ 문은‌ 실행시간‌ 5초‌, 실행성공유무‌를‌ 기록한다‌.
  	
  유‌저 당 설정은‌ ‌user_info_data‌ 값을‌ 이용하여‌ 설정합니다‌.
  */
  ALTER TABLE user_db ADD COLUMN is_profile VARCHAR(3) NOT NULL DEFAULT 'YES';

  // select문일‌ 경우‌ 몇‌ ‌mill‌ 이상이면‌ 


datas:
  ���‌ 것인지‌ -1이면‌ 모두남긴다‌.
  ALTER TABLE user_db ADD COLUMN profile_select_mill INTEGER(3) NOT NULL DEFAULT -1;

  // DML 문‌ 실행시‌ ‌YES‌, ‌NO 묻기‌
  ALTER TABLE user_db ADD COLUMN question_dml VARCHAR(3) NOT NULL DEFAULT 'NO';

  /**
  * ‌user_info_data ‌에‌ 다음데이터를‌ 추가합니다‌.
  *    ‌USER_AUTHORITY , 
  *		VALUE0 컬럼에는 
  				SELECT, INSERT, UPDATE, DELETE, DCL
  *				1이면‌ 가능‌ 0이면‌ 불가능으로‌ 입력한다‌. 예를들 들어‌ 11111 이면‌ 모두‌ 가능하다‌.
  *				디폴트‌ ‌값은‌ 
  *				일반인‌ 경우‌ 운영디비는‌ 모두‌ ‌SELECT만‌ 가능하도록‌ 합니다‌.				
  				메니저‌ 는‌ 모두‌ 가능‌하도록‌ 합니다‌.
  * 
  *		VALUE1 컬럼에는‌ ‌SELECT 불가능한‌ 테이블‌ 명을‌ 입력합니다‌.
  *		‌VALUE2 컬럼에는‌ ‌실행‌ 쿼리‌ 프로파일‌ 유무‌ ‌YES, NO
  *
  * 	‌USER_QUERY_PROFILE
  *		VALUE0 컬럼은‌ ‌프로파일‌ 할것인지‌ '‌YES', 'NO'
  *		VALUE1 컬럼‌ 프로파일‌ 최소시간‌ -1이면‌ 모두‌ 이고‌ ‌MILLS‌ 단위로‌ 입력‌
  *		‌VALUE2 컬럼은 ‌SELECT‌ 문‌ 이외에‌ 실행할때‌ ‌사용자에게‌ 물을것인지‌ '‌YES', 'NO'
  **/
  CREATE TABLE user_db_resource (
       seq INTEGER PRIMARY KEY AUTOINCREMENT ,
       types VARCHAR(10) NOT NULL,
       user_seq INTEGER NOT NULL,
       db_seq INTEGER  NOT NULL,
       filename VARCHAR(2000)  NOT NULL,
       duration_mill INTEGER DEFAULT -1,
       execution_result CHAR(3) DEFAULT 'YES',
       create_time DATE DEFAULT (datetime('now','localtime')),
       delYn CHAR(3) DEFAULT 'NO',
       UNIQUE(types, user_seq, db_seq, filename),
       FOREIGN KEY (user_seq) REFERENCES users (seq) ON DELETE NO ACTION ON UPDATE NO ACTION,
       FOREIGN KEY (db_seq) REFERENCES user_db (seq) ON DELETE NO ACTION ON UPDATE NO ACTION
  );

  ALTER T


datas:
  ABLE user_db_resource ADD COLUMN duration_mill INTEGER DEFAULT -1;

  ALTER TABLE user_db_resource ADD COLUMN execution_result CHAR(3) DEFAULT 'YES';


datas:
  SELECT seq, user_seq, ext_seq, types, url, db, group_name, display_name, host, port, locale, passwd, users, create_time, delYn, ext1, ext2, ext3, operation_type, is_profile, profile_select_mill, question_dml 
   FROM user_db limit 0,1000;


datas:
  SELECT * FROM user_db_resource
  	WHERE
  		user_seq = #user_seq# and
  		db_seq = #seq#  AND
  		delYn = 'NO'		
  	ORDER BY filename limit 0,1000;


datas:
  SELECT * FROM user_db_resource
  	WHERE
  		user_seq = #user_seq# and
  		db_seq = 10  AND
  		delYn = 'NO'		
  	ORDER BY filename limit 0,1000;


datas:
  SELECT * FROM user_db_resource
  	WHERE
  		db_seq = 10  AND 
  		types in ('ERD', 'SQ')
  		delYn = 'NO'		
  	ORDER BY filename limit 0,1000;


datas:
  SELECT * FROM user_db_resource
  	WHERE
  		db_seq = 10  AND 
  		types in ('ERD', 'SQ') AND
  		delYn = 'NO'		
  	ORDER BY filename limit 0,1000;


datas:
  SELECT * FROM user_db_resource
  	WHERE
  		db_seq = 10  AND 
  		types in ('ERD', 'SQL') AND
  		delYn = 'NO'		
  	ORDER BY filename limit 0,1000;


datas:
  SELECT * FROM user_db_resource
  	WHERE
  		db_seq = 10  AND 
  		
  		delYn = 'NO'		
  	ORDER BY filename limit 0,1000;


datas:
   SELECT seq, user_seq, types, name, value0, value1, value2, value3, value4, value5, value6, value7, value8, value9, success, message, create_time, delYn 
   FROM ext_account;


datas:
   SELECT seq, types, user_seq, db_seq, filename, duration_mill, execution_result, create_time, delYn 
   FROM user_db_resource;


