-- 
-- MosP - Mind Open Source Project    http://www.mosp.jp/
-- Copyright (C) MIND Co., Ltd.       http://www.e-mind.co.jp/
-- 
-- This program is free software; you can redistribute it and/or
-- modify it under the terms of the GNU General Public License
-- as published by the Free Software Foundation; either version 2
-- of the License, or (at your option) any later version.
-- 
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
-- 
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
-- 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES cp932 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `AM_ROUTE`
--

DROP TABLE IF EXISTS `AM_ROUTE`;
CREATE TABLE `AM_ROUTE` (
  `RTCODE` varchar(10) NOT NULL COMMENT 'ルートコード',
  `LAYER1` varchar(10) NOT NULL COMMENT '１次承認',
  `LAYER2` varchar(10) NOT NULL COMMENT '２次承認',
  `LAYER3` varchar(10) NOT NULL COMMENT '３次承認',
  `LAYER4` varchar(10) NOT NULL COMMENT '４次承認',
  `LAYER5` varchar(10) NOT NULL COMMENT '５次承認',
  `LASTLAYER` varchar(10) NOT NULL COMMENT '最終承認',
  `DELETEFLAG` int(11) NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`RTCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='承認ルートマスタ';

--
-- Dumping data for table `AM_ROUTE`
--

LOCK TABLES `AM_ROUTE` WRITE;
/*!40000 ALTER TABLE `AM_ROUTE` DISABLE KEYS */;
/*!40000 ALTER TABLE `AM_ROUTE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `AM_UNIT`
--

DROP TABLE IF EXISTS `AM_UNIT`;
CREATE TABLE `AM_UNIT` (
  `UNITCODE` varchar(10) NOT NULL COMMENT 'ユニットコード',
  `STARTDATE` date NOT NULL COMMENT '権限開始日',
  `MAIN` varchar(10) NOT NULL COMMENT '承認者',
  `AGENT` varchar(10) NOT NULL COMMENT '代理',
  `DELETEFLAG` int(11) NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`UNITCODE`,`STARTDATE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='承認ユニットマスタ';

--
-- Dumping data for table `AM_UNIT`
--

LOCK TABLES `AM_UNIT` WRITE;
/*!40000 ALTER TABLE `AM_UNIT` DISABLE KEYS */;
/*!40000 ALTER TABLE `AM_UNIT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_AGREEMENT_OVER_TIME`
--

DROP TABLE IF EXISTS `CM_AGREEMENT_OVER_TIME`;
CREATE TABLE `CM_AGREEMENT_OVER_TIME` (
  `OVER_TIME_ID` int(10) unsigned zerofill NOT NULL default '0000000000' COMMENT '時間外協定ID',
  `OVER_TIME_CODE` varchar(10) NOT NULL default '' COMMENT '時間外協定コード',
  `WORK_TYPE_NAME` varchar(50) NOT NULL COMMENT '業務の種類',
  `CAUSE` text NOT NULL COMMENT '具体的事由',
  `AGREE_TYPE` varchar(10) NOT NULL default '' COMMENT '協定種類',
  `LIMIT_CODE` varchar(10) NOT NULL default '' COMMENT '限度基準コード',
  `OVER_TIME_RATE` int(10) unsigned NOT NULL default '0' COMMENT '時間外割増賃金率',
  `CAUTION_MONTH` int(10) unsigned NOT NULL default '0' COMMENT '月60時間時間外警告時間',
  `MONTHLY_OVER_TIME_RATE` int(10) unsigned NOT NULL default '0' COMMENT '月60時間時間外割増賃金率',
  `SUB_ACQUIRE_RATE` int(10) unsigned NOT NULL default '0' COMMENT '代替休暇取得割増賃金率',
  `SUB_ACQUIRE_HOLIDAY_RATE` int(10) unsigned NOT NULL default '0' COMMENT '代替休暇取得休日割増賃金率',
  `SUB_QUIT_RATE` int(10) unsigned NOT NULL default '0' COMMENT '代替休暇放棄割増賃金率',
  `START_DATE` date NOT NULL COMMENT '開始年月日',
  `DELETE_FLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` datetime NOT NULL COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`OVER_TIME_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='時間外協定マスタ';

--
-- Dumping data for table `CM_AGREEMENT_OVER_TIME`
--

LOCK TABLES `CM_AGREEMENT_OVER_TIME` WRITE;
/*!40000 ALTER TABLE `CM_AGREEMENT_OVER_TIME` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_AGREEMENT_OVER_TIME` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_AGREEMENT_WORK_ON`
--

DROP TABLE IF EXISTS `CM_AGREEMENT_WORK_ON`;
CREATE TABLE `CM_AGREEMENT_WORK_ON` (
  `WORK_ON_ID` int(10) unsigned zerofill NOT NULL default '0000000000' COMMENT '休出協定ID',
  `WORK_ON_CODE` varchar(10) NOT NULL default '' COMMENT '休出協定コード',
  `WORK_TYPE_NAME` varchar(50) NOT NULL COMMENT '業務の種類',
  `CAUSE` text NOT NULL COMMENT '具体的事由',
  `STANDARD_WEEK_HOLIDAY` varchar(14) NOT NULL COMMENT '所定休日',
  `OFFICIAL_HOLIDAY` varchar(1) NOT NULL COMMENT '法定休日',
  `JAPANESE_HOLIDAY_FLAG` varchar(1) NOT NULL COMMENT '国民の祝日フラグ',
  `HOLIDAY_MASTER_FLAG` varchar(1) NOT NULL default '' COMMENT '祝祭日マスタフラグ',
  `STANDARD_HOLIDAY_RATE` int(10) unsigned NOT NULL default '0' COMMENT '所定休日割増賃金率',
  `OFFICIAL_HOLIDAY_RATE` int(10) unsigned NOT NULL default '0' COMMENT '法定休日割増賃金率',
  `NUMBER_OF_WORK_ON` int(10) unsigned NOT NULL default '0' COMMENT '休出日数',
  `START_TIME` int(10) unsigned NOT NULL default '0' COMMENT '開始時刻',
  `END_TIME` int(10) unsigned NOT NULL default '0' COMMENT '終了時刻',
  `START_DATE` date NOT NULL COMMENT '開始年月日',
  `DELETE_FLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` datetime NOT NULL COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`WORK_ON_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='休出協定マスタ';

--
-- Dumping data for table `CM_AGREEMENT_WORK_ON`
--

LOCK TABLES `CM_AGREEMENT_WORK_ON` WRITE;
/*!40000 ALTER TABLE `CM_AGREEMENT_WORK_ON` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_AGREEMENT_WORK_ON` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_AUTHORITY`
--

DROP TABLE IF EXISTS `CM_AUTHORITY`;
CREATE TABLE `CM_AUTHORITY` (
  `AUTHCODE` varchar(2) NOT NULL COMMENT '権限コード',
  `AUTHNAME` varchar(10) NOT NULL COMMENT '権限ネーム',
  `EMPLOYEE` varchar(10) NOT NULL COMMENT '従業員メニュー',
  `MANAGER` varchar(10) NOT NULL COMMENT 'マネージャーメニュー',
  `PAYROLL` varchar(10) NOT NULL COMMENT '給与メニュー',
  `HUMAN` varchar(10) NOT NULL COMMENT '人事メニュー',
  `INSURANCE` varchar(10) NOT NULL COMMENT '社会保険メニュー',
  `BONUS` varchar(10) NOT NULL COMMENT '賞与メニュー',
  `ADJUSTMENT` varchar(10) NOT NULL COMMENT '年末調整メニュー',
  `EXPENSE` varchar(10) NOT NULL COMMENT '経費メニュー',
  `SERVICE1` varchar(10) NOT NULL COMMENT 'サービス１メニュー',
  `SERVICE2` varchar(10) NOT NULL COMMENT 'サービス２メニュー',
  `SERVICE3` varchar(10) NOT NULL COMMENT 'サービス３メニュー',
  `SERVICE4` varchar(10) NOT NULL COMMENT 'サービス４メニュー',
  `SERVICE5` varchar(10) NOT NULL COMMENT 'サービス５メニュー',
  `DELETEFLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`AUTHCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='権限マスタ';

--
-- Dumping data for table `CM_AUTHORITY`
--

LOCK TABLES `CM_AUTHORITY` WRITE;
/*!40000 ALTER TABLE `CM_AUTHORITY` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_AUTHORITY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_CODE`
--

DROP TABLE IF EXISTS `CM_CODE`;
CREATE TABLE `CM_CODE` (
  `T_ID` varchar(10) NOT NULL default '' COMMENT 'コード区分',
  `T_CODE` varchar(8) NOT NULL default '' COMMENT 'コード',
  `T_NAME` varchar(16) NOT NULL default '' COMMENT 'コード名称',
  `VIEW_INDEX` int(3) NOT NULL default '0' COMMENT '勤怠表示順',
  `DELETE_FLAG` int(1) NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` timestamp NOT NULL default '1971-01-01 00:00:00' COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default '1971-01-01 00:00:00' COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`T_ID`,`T_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='コードマスタ';

--
-- Dumping data for table `CM_CODE`
--

LOCK TABLES `CM_CODE` WRITE;
/*!40000 ALTER TABLE `CM_CODE` DISABLE KEYS */;
INSERT INTO `CM_CODE` VALUES 
('AUTHORITY','10','従業員権限',10,0,'1971-01-01 09:00:00','','1971-01-01 09:00:00',''),
('AUTHORITY','20','勤怠管理権限',20,0,'1971-01-01 09:00:00','','1971-01-01 09:00:00',''),
('AUTHORITY','30','給与管理権限',30,0,'1971-01-01 09:00:00','','1971-01-01 09:00:00',''),
('AUTHORITY','40','人事管理権限',40,0,'1971-01-01 09:00:00','','1971-01-01 09:00:00',''),
('AUTHORITY','50','計算管理権限',50,0,'1971-01-01 09:00:00','','1971-01-01 09:00:00',''),
('AUTHORITY','60','人事給与管理権限',60,0,'1971-01-01 09:00:00','','1971-01-01 09:00:00',''),
('JAPANESE','JC_HEISE','平成',4,0,'1970-12-31 15:00:00','','1970-12-31 15:00:00',''),
('JAPANESE','JC_MEIJI','明治',1,0,'1970-12-31 15:00:00','','1970-12-31 15:00:00',''),
('JAPANESE','JC_SHOUW','昭和',3,0,'1970-12-31 15:00:00','','1970-12-31 15:00:00',''),
('JAPANESE','JC_TAISH','大正',2,0,'1970-12-31 15:00:00','','1970-12-31 15:00:00','');
/*!40000 ALTER TABLE `CM_CODE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_COMPONENT`
--

DROP TABLE IF EXISTS `CM_COMPONENT`;
CREATE TABLE `CM_COMPONENT` (
  `COMPCODE` varchar(10) NOT NULL COMMENT 'コマンドユニットコード',
  `DIVISION` varchar(10) NOT NULL COMMENT '分類',
  `COMPNAME` varchar(10) NOT NULL COMMENT 'コマンドユニットネーム',
  `COMPONENT` text NOT NULL COMMENT 'コマンド',
  `MANAGE` int(1) unsigned NOT NULL default '0' COMMENT '利用範囲',
  `DELETEFLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`COMPCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='メニューコマンドマスタ';

--
-- Dumping data for table `CM_COMPONENT`
--

LOCK TABLES `CM_COMPONENT` WRITE;
/*!40000 ALTER TABLE `CM_COMPONENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_COMPONENT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_CONF`
--

DROP TABLE IF EXISTS `CM_CONF`;
CREATE TABLE `CM_CONF` (
  `CONF_ID` varchar(8) NOT NULL default '' COMMENT '設定区分',
  `CONF_CODE` varchar(8) NOT NULL default '' COMMENT '設定コード',
  `CONF_VALUE` varchar(8) NOT NULL default '' COMMENT '設定値',
  `UPDATE_DATE` timestamp NOT NULL default '1970-12-30 21:00:00' COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`CONF_ID`,`CONF_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='設定マスタ';

--
-- Dumping data for table `CM_CONF`
--

LOCK TABLES `CM_CONF` WRITE;
/*!40000 ALTER TABLE `CM_CONF` DISABLE KEYS */;
INSERT INTO `CM_CONF` VALUES
('CALC','50','','1971-01-01 00:00:00','admin'),
('CALC','99','','1971-01-01 00:00:00','admin'),
('CLOSE','0','0','2008-07-10 03:41:17','admin'),
('HOLIDAY','6','12','1971-01-01 00:00:00',''),
('HUMAN','40','','1971-01-01 00:00:00','admin'),
('HUMAN','60','','1971-01-01 00:00:00','admin'),
('INITIAL','10','K1010','1971-01-01 00:00:00','admin'),
('INITIAL','20','K2910','1971-01-01 00:00:00','admin'),
('INITIAL','50','P1910','1971-01-01 00:00:00','admin'),
('INITIAL','99','S2910','1971-01-01 00:00:00','admin'),
('JC_HEISE','19890108','21001231','1970-12-31 15:00:00',''),
('JC_MEIJI','18680908','19120729','1970-12-31 15:00:00',''),
('JC_SHOUW','19261225','19890107','1970-12-31 15:00:00',''),
('JC_TAISH','19120730','19261224','1970-12-31 15:00:00',''),
('MANAGER','20','','1971-01-01 18:00:00',''),
('MANAGER','30','','1971-01-01 18:00:00',''),
('MANAGER','60','','1971-01-01 18:00:00',''),
('MISSING','3','-5000','1971-01-01 00:00:00',''),
('NIGHT','22:00','5:00','1971-01-01 00:00:00',''),
('PAYROLL','30','','1971-01-01 00:00:00','admin'),
('PAYROLL','50','','1971-01-01 00:00:00','admin'),
('PAYROLL','60','','1971-01-01 00:00:00','admin'),
('RATIO','1','80','1971-01-01 00:00:00',''),
('WORKHOUR','8','','1971-01-01 00:00:00','');
/*!40000 ALTER TABLE `CM_CONF` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_LABOR_AGREEMENT`
--

DROP TABLE IF EXISTS `CM_LABOR_AGREEMENT`;
CREATE TABLE `CM_LABOR_AGREEMENT` (
  `AGREE_CODE` varchar(10) NOT NULL default '' COMMENT '協定コード',
  `AGREE_TYPE` varchar(15) NOT NULL default '' COMMENT '協定種類',
  `OVER_TIME_CODE` varchar(10) NOT NULL default '' COMMENT '時間外協定コード',
  `WORK_ON_CODE` varchar(10) NOT NULL default '' COMMENT '休出協定コード',
  `DELETE_FLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` datetime NOT NULL COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`AGREE_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='労使協定マスタ';

--
-- Dumping data for table `CM_LABOR_AGREEMENT`
--

LOCK TABLES `CM_LABOR_AGREEMENT` WRITE;
/*!40000 ALTER TABLE `CM_LABOR_AGREEMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_LABOR_AGREEMENT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_LIMIT_STANDARD`
--

DROP TABLE IF EXISTS `CM_LIMIT_STANDARD`;
CREATE TABLE `CM_LIMIT_STANDARD` (
  `LIMIT_CODE` varchar(10) NOT NULL default '' COMMENT '限度基準コード',
  `LIMIT_NAME` varchar(50) NOT NULL default '' COMMENT '限度基準名称',
  `TERM_TYPE` varchar(10) NOT NULL default '' COMMENT '期間の種類',
  `PRESCRIBED_TIME` int(10) unsigned NOT NULL default '0' COMMENT '所定労働時間',
  `CAUTION_DAY` int(10) unsigned NOT NULL default '0' COMMENT '1日の警告時間',
  `CAUTION_TERM` int(10) unsigned NOT NULL default '0' COMMENT '指定期間の警告時間',
  `CAUTION_YEAR` int(10) unsigned NOT NULL default '0' COMMENT '1年の警告時間',
  `LIMIT_DAY` int(10) unsigned NOT NULL default '0' COMMENT '一日の限度時間',
  `LIMIT_TERM` int(10) unsigned NOT NULL default '0' COMMENT '指定期間の限度時間',
  `LIMIT_YEAR` int(10) unsigned NOT NULL default '0' COMMENT '1年の限度時間',
  `RATE_TERM` int(10) unsigned NOT NULL default '0' COMMENT '指定期間の割増率',
  `RATE_YEAR` int(10) unsigned NOT NULL default '0' COMMENT '1年の割増率',
  `DELETE_FLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` datetime NOT NULL COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`LIMIT_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='限度基準マスタ';

--
-- Dumping data for table `CM_LIMIT_STANDARD`
--

LOCK TABLES `CM_LIMIT_STANDARD` WRITE;
/*!40000 ALTER TABLE `CM_LIMIT_STANDARD` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_LIMIT_STANDARD` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_MENU`
--

DROP TABLE IF EXISTS `CM_MENU`;
CREATE TABLE `CM_MENU` (
  `AUTHORITY` varchar(2) NOT NULL default '' COMMENT '権限',
  `MENU_ID` varchar(8) NOT NULL default '' COMMENT 'メニューID',
  `UPDATE_DATE` timestamp NOT NULL default '1971-01-01 00:00:00' COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`AUTHORITY`,`MENU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='メニュー管理';

--
-- Dumping data for table `CM_MENU`
--

LOCK TABLES `CM_MENU` WRITE;
/*!40000 ALTER TABLE `CM_MENU` DISABLE KEYS */;
INSERT INTO `CM_MENU` VALUES
('10','INPUT','1971-01-02 03:00:00','admin'),
('20','INPUT','1971-01-02 03:00:00','admin'),
('20','MANAGE','1971-01-02 03:00:00','admin'),
('30','INPUT','1971-01-02 03:00:00','admin'),
('30','PAYROLL','1971-01-02 03:00:00','admin'),
('40','HUMAN','1971-01-02 03:00:00','admin'),
('40','INPUT','1971-01-02 03:00:00','admin'),
('50','INPUT','1971-01-02 03:00:00','admin'),
('50','PAYROLL','1971-01-01 18:00:00','admin'),
('50','SYSTEM','1971-01-01 18:00:00','admin'),
('60','HUMAN','1971-01-02 03:00:00','admin'),
('60','INPUT','1971-01-02 03:00:00','admin'),
('60','MANAGE','1971-01-02 03:00:00','admin'),
('60','PAYROLL','1971-01-02 03:00:00','admin'),
('99','SYSTEM','1971-01-02 03:00:00','admin'),
('99','SYSTEM2','1971-01-01 18:00:00','admin');
/*!40000 ALTER TABLE `CM_MENU` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_OUTPUT`
--

DROP TABLE IF EXISTS `CM_OUTPUT`;
CREATE TABLE `CM_OUTPUT` (
  `ID` int(11) unsigned zerofill NOT NULL default '00000000000' COMMENT 'ID',
  `CODE` varchar(10) NOT NULL COMMENT '出力コマンド番号',
  `NAME` varchar(100) NOT NULL COMMENT 'ボタン表示名称',
  `SCOPE` varchar(10) NOT NULL COMMENT '制限範囲',
  `ITEM` varchar(500) NOT NULL COMMENT '出力項目',
  `VIEWINDEX` int(10) unsigned NOT NULL default '0' COMMENT '表示順',
  `DELETEFLAG` int(11) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='CSV出力マスタ';

--
-- Dumping data for table `CM_OUTPUT`
--

LOCK TABLES `CM_OUTPUT` WRITE;
/*!40000 ALTER TABLE `CM_OUTPUT` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_OUTPUT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_ROTATION`
--

DROP TABLE IF EXISTS `CM_ROTATION`;
CREATE TABLE `CM_ROTATION` (
  `KCODE` varchar(10) NOT NULL COMMENT '社員コード',
  `RTCODE` varchar(10) NOT NULL COMMENT '輪番パターンコード',
  `RTNAME` varchar(100) NOT NULL COMMENT '輪番パターン名称',
  `HOLIDAYFLAG` int(11) NOT NULL default '0' COMMENT '祝祭日フラグ',
  `DAY1` varchar(10) NOT NULL COMMENT '1日目',
  `DAY2` varchar(10) NOT NULL COMMENT '2日目',
  `DAY3` varchar(10) NOT NULL COMMENT '3日目',
  `DAY4` varchar(10) NOT NULL COMMENT '4日目',
  `DAY5` varchar(10) NOT NULL COMMENT '5日目',
  `DAY6` varchar(10) NOT NULL COMMENT '6日目',
  `DAY7` varchar(10) NOT NULL COMMENT '7日目',
  `DAY8` varchar(10) NOT NULL COMMENT '8日目',
  `DAY9` varchar(10) NOT NULL COMMENT '9日目',
  `DAY10` varchar(10) NOT NULL COMMENT '10日目',
  `DELETEFLAG` int(11) NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL default '1970-12-31 15:00:00' COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default '1970-12-31 15:00:00' COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`KCODE`,`RTCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='輪番パターンマスタ';

--
-- Dumping data for table `CM_ROTATION`
--

LOCK TABLES `CM_ROTATION` WRITE;
/*!40000 ALTER TABLE `CM_ROTATION` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_ROTATION` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_USER`
--

DROP TABLE IF EXISTS `CM_USER`;
CREATE TABLE `CM_USER` (
  `USER_ID` varchar(10) NOT NULL default '' COMMENT 'ユーザーID',
  `PASSWORD` varchar(32) NOT NULL default '' COMMENT 'パスワード',
  `K_CODE` varchar(10) NOT NULL default '' COMMENT '社員コード',
  `USER_NAME` varchar(16) NOT NULL default '' COMMENT 'ユーザー名',
  `AUTHORITY` varchar(2) NOT NULL default '' COMMENT 'プログラム利用権限',
  `DATA_LEVEL` int(2) NOT NULL default '0' COMMENT 'データ参照レベル',
  `CHANGE_PASS` date NOT NULL default '1971-01-01' COMMENT 'パスワード変更日',
  `DELETE_FLAG` int(1) NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` timestamp NOT NULL default '1970-12-29 18:00:00' COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default '1970-12-29 18:00:00' COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`USER_ID`),
  KEY `IDX1_UM_USER` (`K_CODE`(6))
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='ユーザーマスタ';

--
-- Dumping data for table `CM_USER`
--

LOCK TABLES `CM_USER` WRITE;
/*!40000 ALTER TABLE `CM_USER` DISABLE KEYS */;
INSERT INTO `CM_USER` VALUES
('admin','c3284d0f94606de1fd2af172aba15bf3','','admin','99',99,'1971-01-01',0,'1970-12-31 06:00:00','','2008-03-01 03:35:33','admin');
/*!40000 ALTER TABLE `CM_USER` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CM_WORKTYPE`
--

DROP TABLE IF EXISTS `CM_WORKTYPE`;
CREATE TABLE `CM_WORKTYPE` (
  `SHIFTCODE` varchar(10) NOT NULL COMMENT '勤務形態コード',
  `SHIFTNAME` varchar(100) NOT NULL COMMENT '勤務形態名称',
  `STARTTIME` int(11) NOT NULL default '0' COMMENT '出勤時刻',
  `QUITTIME` int(11) NOT NULL default '0' COMMENT '退社時刻',
  `WORKTIME` int(11) NOT NULL default '0' COMMENT '勤務時間',
  `BREAKTIME` int(11) NOT NULL default '0' COMMENT '休憩時間',
  `OVERSTART` int(11) NOT NULL default '0' COMMENT '残業開始時間',
  `OVERBREAK` int(11) NOT NULL default '0' COMMENT '残業休憩時間',
  `OPTION1` varchar(100) NOT NULL COMMENT 'オプション1',
  `OPTION2` varchar(100) NOT NULL COMMENT 'オプション2',
  `OPTION3` varchar(100) NOT NULL COMMENT 'オプション3',
  `OPTION4` varchar(100) NOT NULL COMMENT 'オプション4',
  `OPTION5` varchar(100) NOT NULL COMMENT 'オプション5',
  `DELETEFLAG` int(11) NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL default '1970-12-31 15:00:00' COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default '1970-12-31 15:00:00' COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`SHIFTCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='勤務形態マスタ';

--
-- Dumping data for table `CM_WORKTYPE`
--

LOCK TABLES `CM_WORKTYPE` WRITE;
/*!40000 ALTER TABLE `CM_WORKTYPE` DISABLE KEYS */;
/*!40000 ALTER TABLE `CM_WORKTYPE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CT_ACCOUNT`
--

DROP TABLE IF EXISTS `CT_ACCOUNT`;
CREATE TABLE `CT_ACCOUNT` (
  `USER_ID` varchar(10) NOT NULL default '' COMMENT 'ユーザーID',
  `ATTEMPT` int(2) NOT NULL default '0' COMMENT '試行回数',
  `UPDATE_DATE` timestamp NOT NULL default '1971-01-01 00:00:00' COMMENT '更新日',
  PRIMARY KEY  (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='アカウント管理';

--
-- Dumping data for table `CT_ACCOUNT`
--

LOCK TABLES `CT_ACCOUNT` WRITE;
/*!40000 ALTER TABLE `CT_ACCOUNT` DISABLE KEYS */;
/*!40000 ALTER TABLE `CT_ACCOUNT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CT_OVERTIME_REQUEST`
--

DROP TABLE IF EXISTS `CT_OVERTIME_REQUEST`;
CREATE TABLE `CT_OVERTIME_REQUEST` (
  `VOUCHER` int(10) unsigned zerofill NOT NULL COMMENT '残業申請伝票番号',
  `WORKFLOW` bigint(20) unsigned zerofill NOT NULL COMMENT 'ワークフロー番号',
  `KCODE` varchar(10) NOT NULL COMMENT '社員コード',
  `REQUESTDATE` date NOT NULL COMMENT '申請日',
  `WORKDATE` date NOT NULL COMMENT '勤務日',
  `OVERTIME` int(11) NOT NULL COMMENT '申請時間',
  `REASON` text NOT NULL COMMENT '事由',
  `DELETEFLAG` int(1) NOT NULL COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`VOUCHER`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='残業申請テーブル';

--
-- Dumping data for table `CT_OVERTIME_REQUEST`
--

LOCK TABLES `CT_OVERTIME_REQUEST` WRITE;
/*!40000 ALTER TABLE `CT_OVERTIME_REQUEST` DISABLE KEYS */;
/*!40000 ALTER TABLE `CT_OVERTIME_REQUEST` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CT_WORKFLOW`
--

DROP TABLE IF EXISTS `CT_WORKFLOW`;
CREATE TABLE `CT_WORKFLOW` (
  `WORKFLOW` bigint(20) unsigned zerofill NOT NULL default '00000000000000000000' COMMENT 'ワークフロー番号',
  `LAYERNUMBER` int(11) NOT NULL default '0' COMMENT '階層番号',
  `CURRENTSTATUS` varchar(10) NOT NULL COMMENT '状態',
  `RTCODE` varchar(10) NOT NULL COMMENT 'ルートコード',
  `DELETEFLAG` int(11) NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`WORKFLOW`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='ワークフローテーブル';

--
-- Dumping data for table `CT_WORKFLOW`
--

LOCK TABLES `CT_WORKFLOW` WRITE;
/*!40000 ALTER TABLE `CT_WORKFLOW` DISABLE KEYS */;
/*!40000 ALTER TABLE `CT_WORKFLOW` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CT_WORKFLOW_COMMENT`
--

DROP TABLE IF EXISTS `CT_WORKFLOW_COMMENT`;
CREATE TABLE `CT_WORKFLOW_COMMENT` (
  `COMMENTID` bigint(20) unsigned zerofill NOT NULL default '00000000000000000000' COMMENT 'コメントID',
  `WORKFLOW` bigint(20) unsigned zerofill NOT NULL default '00000000000000000000' COMMENT 'ワークフロー番号',
  `KCODE` varchar(10) NOT NULL COMMENT '社員コード',
  `TARGET` varchar(10) NOT NULL COMMENT '対象者',
  `AUTHORCOMMENT` text NOT NULL COMMENT 'コメント',
  `DELETEFLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`COMMENTID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='ワークフローコメントテーブル';

--
-- Dumping data for table `CT_WORKFLOW_COMMENT`
--

LOCK TABLES `CT_WORKFLOW_COMMENT` WRITE;
/*!40000 ALTER TABLE `CT_WORKFLOW_COMMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `CT_WORKFLOW_COMMENT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `KD_PAID_HOLIDAY`
--

DROP TABLE IF EXISTS `KD_PAID_HOLIDAY`;
CREATE TABLE `KD_PAID_HOLIDAY` (
  `PAID_ID` bigint(20) unsigned zerofill NOT NULL default '00000000000000000000' COMMENT '有休ID',
  `K_CODE` varchar(10) NOT NULL default '' COMMENT '社員コード',
  `PROCESS_TYPE` varchar(10) NOT NULL default '' COMMENT '処理コード',
  `PROCESS_DATE` date NOT NULL COMMENT '支給日',
  `LAST_REMAIN_DAYS` double unsigned NOT NULL default '0' COMMENT '前年度残日数',
  `LAST_REMAIN_HOUR` int(10) unsigned NOT NULL default '0' COMMENT '前年度残時間',
  `REMAIN_DAYS` double unsigned NOT NULL default '0' COMMENT '今年度残日数',
  `REMAIN_HOUR` int(10) unsigned NOT NULL default '0' COMMENT '今年度残時間',
  `POSSIBLE` int(10) unsigned NOT NULL default '0' COMMENT '時間単位取得可能日数',
  `DELETE_FLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` datetime NOT NULL COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`PAID_ID`,`K_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='有休管理テーブル';

--
-- Dumping data for table `KD_PAID_HOLIDAY`
--

LOCK TABLES `KD_PAID_HOLIDAY` WRITE;
/*!40000 ALTER TABLE `KD_PAID_HOLIDAY` DISABLE KEYS */;
/*!40000 ALTER TABLE `KD_PAID_HOLIDAY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `KD_SUBSTITUTE_HOLIDAY`
--

DROP TABLE IF EXISTS `KD_SUBSTITUTE_HOLIDAY`;
CREATE TABLE `KD_SUBSTITUTE_HOLIDAY` (
  `SUBSTITUTE_ID` bigint(20) unsigned zerofill NOT NULL default '00000000000000000000' COMMENT '管理ID',
  `K_CODE` varchar(10) NOT NULL COMMENT '社員コード',
  `OCCUR_YEAR` int(10) unsigned NOT NULL default '0' COMMENT '発生年',
  `OCCUR_MONTH` int(10) unsigned NOT NULL default '0' COMMENT '発生月',
  `CLOSE_DATE` date NOT NULL COMMENT '締切日',
  `LIMIT_START_DATE` date NOT NULL COMMENT '期限開始日',
  `LIMIT_END_DATE` date NOT NULL COMMENT '期限終了日',
  `ATTITUDE_STATUS` varchar(10) NOT NULL COMMENT '意向状況',
  `PAYMENT_ACQUIRE_TIME` int(10) unsigned NOT NULL default '0' COMMENT '代替休暇取得時間外',
  `PAYMENT_ACQUIRE_HOLIDAY` int(10) unsigned NOT NULL default '0' COMMENT '代替休暇取得休日時間外',
  `PAYMENT_QUIT_TIME` int(10) unsigned NOT NULL default '0' COMMENT '代替休暇放棄時間外',
  `USE_HOLIDAY_TIME` int(10) unsigned NOT NULL default '0' COMMENT '利用時間',
  `ACQUISITION_STATUS` varchar(10) NOT NULL COMMENT '取得状況',
  `LIQUIDATION_OVER_TIME` int(11) NOT NULL default '0' COMMENT '代休決済による時間外清算時間',
  `LIQUIDATION_WEEK_HOLIDAY` int(11) NOT NULL default '0' COMMENT '代休決済による休日時間外清算時間',
  `DECISION_STATUS` varchar(10) NOT NULL COMMENT '決済状況',
  `DELETE_FLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` datetime NOT NULL COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`SUBSTITUTE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='代替休暇管理テーブル';

--
-- Dumping data for table `KD_SUBSTITUTE_HOLIDAY`
--

LOCK TABLES `KD_SUBSTITUTE_HOLIDAY` WRITE;
/*!40000 ALTER TABLE `KD_SUBSTITUTE_HOLIDAY` DISABLE KEYS */;
/*!40000 ALTER TABLE `KD_SUBSTITUTE_HOLIDAY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `KD_WORK`
--

DROP TABLE IF EXISTS `KD_WORK`;
CREATE TABLE `KD_WORK` (
  `K_CODE` varchar(10) NOT NULL COMMENT '社員コード',
  `SIKYU_YM` varchar(8) NOT NULL COMMENT '支給年月',
  `S_NEN` int(4) NOT NULL default '0' COMMENT '支給年',
  `S_TUKI` int(2) NOT NULL default '0' COMMENT '支給月',
  `S_HI` int(2) NOT NULL default '0' COMMENT '支給日',
  `S_NISSU` double NOT NULL default '0' COMMENT '出勤日数',
  `S_KAISU` int(4) NOT NULL default '0' COMMENT '出勤回数',
  `KINMU_JI` int(4) NOT NULL default '0' COMMENT '勤務時間',
  `KYUKEI_JI` int(4) NOT NULL default '0' COMMENT '休憩時間',
  `YUKYU` double NOT NULL default '0' COMMENT '有給',
  `TOKUKYU` double NOT NULL default '0' COMMENT '特別休暇',
  `KEKKIN` double NOT NULL default '0' COMMENT '一般欠勤日数',
  `S_KEKKIN` double NOT NULL default '0' COMMENT '傷病欠勤日数',
  `DAIKYU` double NOT NULL default '0' COMMENT '代替休暇',
  `FURIKAE` double NOT NULL default '0' COMMENT '振替休暇',
  `KK_RIYUU_6` double NOT NULL default '0' COMMENT '休暇理由6',
  `KK_RIYUU_7` double NOT NULL default '0' COMMENT '休暇理由7',
  `KK_RIYUU_8` double NOT NULL default '0' COMMENT '休暇理由8',
  `KK_RIYUU_9` double NOT NULL default '0' COMMENT '休暇理由9',
  `SONOTA` double NOT NULL default '0' COMMENT 'その他休暇',
  `TI_SO_KAI` int(4) NOT NULL default '0' COMMENT '遅刻早退回数',
  `TI_SO_JIKAN` int(4) NOT NULL default '0' COMMENT '遅刻早退時間',
  `ZA_JIKAN` int(4) NOT NULL default '0' COMMENT '普通残業時間',
  `KS_JIKAN` int(4) NOT NULL default '0' COMMENT '休日出勤時間',
  `SN_JIKAN` int(4) NOT NULL default '0' COMMENT '深夜勤務時間',
  `KAIKIN` int(1) NOT NULL default '0' COMMENT '精皆勤手当支給',
  `SYOKUJI_KAISU` int(4) NOT NULL default '0' COMMENT '食事手当支給回数',
  `CYOKU_KAISU_1` int(4) NOT NULL default '0' COMMENT '1直手当支給回数',
  `CYOKU_KAISU_2` int(4) NOT NULL default '0' COMMENT '2直手当支給回数',
  `CYOKU_KAISU_3` int(4) NOT NULL default '0' COMMENT '3直手当支給回数',
  `HOKA_KAISU_1` int(4) NOT NULL default '0' COMMENT 'その他支給回数1',
  `HOKA_KAISU_2` int(4) NOT NULL default '0' COMMENT 'その他支給回数2',
  `HOKA_KAISU_3` int(4) NOT NULL default '0' COMMENT 'その他支給回数3',
  `HOKA_KAISU_4` int(4) NOT NULL default '0' COMMENT 'その他支給回数4',
  `HOKA_KAISU_5` int(4) NOT NULL default '0' COMMENT 'その他支給回数5',
  `SINSEI_GAKU` int(8) NOT NULL default '0' COMMENT '支払申請額',
  `WARIMASI_1` int(11) NOT NULL default '0' COMMENT '1.00割増',
  `WEEK_DAY_OVER_TIME` int(11) NOT NULL default '0' COMMENT '平日時間外',
  `WEEK_HOLIDAY_OVER_TIME` int(11) NOT NULL default '0' COMMENT '所定休日時間外',
  `MONTHLY_OVER_TIME` int(11) NOT NULL default '0' COMMENT '月60時間超過平日時間外',
  `MONTHLY_WEEK_HOLIDAY` int(11) NOT NULL default '0' COMMENT '月60時間超過所定休日時間外',
  `HOUR_HOLIDAY` int(11) NOT NULL default '0' COMMENT '時間単位年休取得時間',
  `SUBSTITUTE_HOLIDAY` double NOT NULL default '0' COMMENT '時間外時間代替休暇取得日数',
  `AMEND_FLAG` int(11) NOT NULL default '0' COMMENT '修正フラグ',
  `INSERT_DATE` datetime NOT NULL COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`K_CODE`,`SIKYU_YM`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='勤怠集計';

--
-- Dumping data for table `KD_WORK`
--

LOCK TABLES `KD_WORK` WRITE;
/*!40000 ALTER TABLE `KD_WORK` DISABLE KEYS */;
/*!40000 ALTER TABLE `KD_WORK` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `KT_HOLIDAY_REQUEST`
--

DROP TABLE IF EXISTS `KT_HOLIDAY_REQUEST`;
CREATE TABLE `KT_HOLIDAY_REQUEST` (
  `VOUCHER` int(10) unsigned zerofill NOT NULL COMMENT '休暇申請伝票番号',
  `WORKFLOW` bigint(20) unsigned zerofill NOT NULL COMMENT 'ワークフロー番号',
  `K_CODE` varchar(10) NOT NULL COMMENT '社員コード',
  `HOLIDAY_DATE` date NOT NULL COMMENT '休暇日',
  `START_TIME` int(11) NOT NULL COMMENT '休暇開始時間',
  `END_TIME` int(11) NOT NULL COMMENT '休暇終了時間',
  `REASON` varchar(10) NOT NULL COMMENT '休暇理由',
  `HOLIDAY_TYPE` varchar(10) NOT NULL COMMENT '有給区分',
  `OCCUR_DATE_1` varchar(10) NOT NULL default '' COMMENT '発生年月日1',
  `USE_TIME_1` int(11) NOT NULL default '0' COMMENT '利用時間1',
  `OCCUR_DATE_2` varchar(10) NOT NULL default '' COMMENT '発生年月日2',
  `USE_TIME_2` int(11) NOT NULL default '0' COMMENT '利用時間2',
  `SUBSTITUTE_DATE` varchar(10) NOT NULL COMMENT '充当日',
  `CAUSE_COMMENT` text NOT NULL COMMENT '事由',
  `DELETE_FLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `INSERT_DATE` datetime NOT NULL COMMENT '作成日',
  `INSERT_USER` varchar(10) NOT NULL default '' COMMENT '作成者',
  `UPDATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDATE_USER` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`VOUCHER`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='休暇申請テーブル';

--
-- Dumping data for table `KT_HOLIDAY_REQUEST`
--

LOCK TABLES `KT_HOLIDAY_REQUEST` WRITE;
/*!40000 ALTER TABLE `KT_HOLIDAY_REQUEST` DISABLE KEYS */;
/*!40000 ALTER TABLE `KT_HOLIDAY_REQUEST` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_CODE`
--

DROP TABLE IF EXISTS `M_CODE`;
CREATE TABLE `M_CODE` (
  `TID` varchar(20) NOT NULL default '' COMMENT 'コード名',
  `TCODE` varchar(20) NOT NULL default '' COMMENT 'コード',
  `TNAME` varchar(100) NOT NULL default '' COMMENT 'コード名称',
  `TCHANGE` varchar(100) NOT NULL default '' COMMENT 'コード変換',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`TID`,`TCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='コード';

--
-- Dumping data for table `M_CODE`
--

LOCK TABLES `M_CODE` WRITE;
/*!40000 ALTER TABLE `M_CODE` DISABLE KEYS */;
INSERT INTO `M_CODE` VALUES
('mail.smtp.host','0','アカウントＲ','','2008-09-18 13:32:46','','2007-04-20 01:28:14','*'),
('mymail.address','0','発信者メールアドレス','','2008-09-18 13:34:20','','2007-06-25 20:11:39','*'),
('１日所定労働','時数','','8.0','2008-09-18 13:34:20','','2008-07-10 03:41:17','admin'),
('１日所定労働','日数','','1.0','2008-09-18 13:34:20','','2008-07-10 03:41:17','admin'),
('パート区分','1','正社員','','2004-10-02 01:47:06','','2007-06-26 18:38:34','*'),
('パート区分','2','パート','','2008-09-18 13:35:23','','2008-09-18 13:35:23',''),
('陰暦','1','睦月','','2006-11-17 01:54:18','','2006-11-17 01:54:18',''),
('陰暦','10','神無月','','2006-11-17 01:54:18','','2007-02-23 01:42:01','*'),
('陰暦','11','霜月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','12','師走','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','2','如月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','3','弥生','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','4','卯月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','5','皐月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','6','水無月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','7','文月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','8','葉月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('陰暦','9','長月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('介護保険有無','0','無','','2008-09-18 13:34:20','','2005-07-14 00:19:26',''),
('介護保険有無','1','有','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('学歴','100','中学','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('学歴','200','高校','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('学歴','300','専門学校','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('学歴','400','高専','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('学歴','500','大学','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('学歴','600','大学院','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('割増率','休日出勤','yyyyyyyyyy','0.10','2007-02-13 20:05:11','00001','2007-06-26 19:21:02','*'),
('割増率','欠勤','yyyyyyyyyy','1.50','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('割増率','深夜勤務','yyyyyyyyyy','0.25','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('割増率','遅刻早退','yyyyyyyyyy','1.50','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('割増率','普通残業','yyyyyyyyyy','1.25','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('休暇証明書','0','無し','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('休暇証明書','1','有り','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('休暇理由','0','有給休暇','','2008-09-18 13:34:20','','2008-06-27 02:28:37','admin'),
('休暇理由','1','特別休暇','','2008-09-18 13:34:20','','2008-06-27 02:28:37','admin'),
('休暇理由','2','欠勤','','2008-09-18 13:34:20','','2008-06-27 02:28:37','admin'),
('休暇理由','3','傷病欠勤','','2004-10-06 20:30:15','','2008-06-27 02:28:37','admin'),
('休暇理由','4','代休','','2005-04-04 23:23:25','','2008-06-27 02:28:37','admin'),
('休暇理由','5','振替','','2007-02-13 21:28:46','00001','2008-06-27 02:28:37','admin'),
('休暇理由','6','','','2007-06-26 02:19:27','*','2008-06-27 02:28:37','admin'),
('休暇理由','7','','','2007-06-26 02:19:27','*','2008-06-27 02:28:37','admin'),
('休暇理由','8','','','2007-06-26 02:19:27','*','2008-06-27 02:28:37','admin'),
('休暇理由','9','その他','','2008-09-18 13:34:20','','2008-06-27 02:28:37','admin'),
('休出区分','0','通常','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('休出区分','1','休出','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('休退職区分','1','勤務者','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('休退職区分','2','休職者','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('休退職区分','9','退職者','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('休日','01/02','年始休日','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('休日','01/03','年始休日','','2008-09-18 13:34:20','','2008-05-20 00:41:41','*'),
('休日','01/04','年始休日','','2008-07-10 03:39:05','admin','2008-07-10 03:39:05','admin'),
('休日','01/05','年始休日','','2008-07-10 03:39:18','admin','2008-08-22 23:29:12','admin'),
('休日','12/30','年末休日','','2008-09-18 13:34:20','','2008-08-22 23:29:31','admin'),
('休日','12/31','年末休日','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('給与区分','1','月給','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('給与区分','2','月給固定','','2008-09-18 13:34:20','','2004-10-18 23:26:10',''),
('給与区分','3','日給','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('給与区分','4','時給','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('給与支給日','月','プラスする月数','0','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('給与支給日','日','支給日','25','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('協定種類','0','１年単位の変形労働時間制に該当しない労働者','','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('協定種類','1','１年単位の変形労働時間制により労働する労働者','','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('協定種類','2','育児・介護休業法上の時間外労働の制限を請求した労働者','','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('勤怠管理','丸め処理','','0','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('勤怠管理','休暇時間','分の単位','08:00/04:00/','2008-06-03 21:34:15','10001','2008-07-10 03:41:17','admin'),
('勤怠管理','計算処理','','0','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('勤怠管理','月60時間時間外機能','','1','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('勤怠管理','自動計算','分の単位','0','2008-06-03 21:34:15','10001','2008-07-10 03:41:17','admin'),
('勤怠管理','深夜時間','分の単位','22:00/08:00/','2008-06-03 21:34:15','10001','2008-07-10 03:41:17','admin'),
('勤怠管理','代休情報修正','','1','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('勤怠管理','代替休暇機能','','1','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('勤怠締日','月','マイナスする月数','0','2005-04-11 00:01:56','','2008-06-25 23:25:50','admin'),
('勤怠締日','日','締日','0','2005-04-11 00:02:47','','2008-06-25 23:25:50','admin'),
('血液型','1','Ａ型','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('血液型','2','ＡＢ型','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('血液型','3','Ｂ型','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('血液型','4','Ｏ型','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('血液型','9','不明','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('月間所定労働','時数','','180.0','2008-09-18 13:34:20','','2008-07-10 03:41:17','admin'),
('月間所定労働','日数','','20.0','2008-09-18 13:34:20','','2008-07-10 03:41:17','admin'),
('限度基準期間','0','1週間','1,week','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('限度基準期間','1','2週間','2,week','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('限度基準期間','2','4週間','4,week','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('限度基準期間','3','1ヶ月','1,month','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('限度基準期間','4','2ヶ月','2,month','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('限度基準期間','5','3ヶ月','3,month','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('雇用保険有無','0','無','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('雇用保険有無','1','有','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('厚生年金基金三種','0','適用しない','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('厚生年金基金三種','1','適用する','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('厚生年金三種','0','適用しない','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('厚生年金三種','1','適用する','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('控除項目数','給与','','10','2004-10-05 00:48:35','','2005-03-22 22:31:35',''),
('控除項目数','賞与','','10','2004-10-05 00:48:50','','2005-03-22 22:04:57',''),
('支給計算基礎','賞与','yyynnnnnnn','1','2007-02-08 01:20:48','11111','2007-02-08 01:41:45','11111'),
('支給項目数','給与','','20','2004-10-05 00:47:37','','2005-03-22 22:31:58',''),
('支給項目数','賞与','','10','2004-10-05 00:48:00','','2005-03-22 22:05:52',''),
('支払区分','1','月払い','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払区分','2','日払い','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法1','0','無し','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法1','1','現金','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法1','2','振込','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法2','0','無し','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法2','1','現金','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法2','2','振込','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法3','0','無し','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法3','1','現金','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('支払方法3','2','振込','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('社会保険','固定的賃金','yyyyyyyyyy','','2007-02-08 00:51:18','11111','2007-04-21 01:04:57','*'),
('手当非課税額','01','皆勤手当','1000','2007-02-26 19:37:03','*','2007-06-26 19:21:02','*'),
('手当非課税額','02','食事手当','3500','2007-02-26 19:37:03','*','2007-06-26 19:21:02','*'),
('手当非課税額','11','1直手当','4000','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当非課税額','12','2直手当','4000','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当非課税額','13','3直手当','4300','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当非課税額','21','その他1手当','0','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当非課税額','22','その他2手当','0','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当非課税額','23','その他3手当','0','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当非課税額','24','その他4手当','0','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当非課税額','25','その他5手当','0','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','01','普通残業','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','02','休日出勤','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','03','深夜割増','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','04','特別欠勤','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','05','傷病欠勤','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','06','一般欠勤','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','07','遅刻早退','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','08','皆勤手当','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','09','食事手当','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','10','1直手当','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','11','2直手当','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','12','3直手当','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','13','その他手当1','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','14','その他手当2','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','15','その他手当3','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','16','その他手当4','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('手当名称','17','その他手当5','','2008-09-18 13:34:20','','2007-06-26 19:21:02','*'),
('承認理由','0','申請中','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('承認理由','1','一次済','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('承認理由','2','差戻','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('承認理由','3','二次済','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('承認理由','4','二次差戻','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('承認理由','5','下書き','','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('昇給','その他区分','','1','2004-10-25 21:17:37','','2007-02-22 23:20:45','*'),
('昇給','支給項目数','','10','2004-10-25 21:18:54','','2005-03-22 22:05:39',''),
('昇給','昇給区分','','2','2004-10-25 21:17:13','','2007-02-22 23:20:45','*'),
('昇給','昇給年月日','','20060525','2004-10-25 21:15:53','','2007-02-22 23:20:45','*'),
('昇給','遡及区分','','0','2004-10-25 21:18:18','','2007-02-22 23:20:45','*'),
('昇給','遡及年月日','','0','2004-10-25 21:16:26','','2007-02-22 23:20:45','*'),
('昇給','適用年月日','','20070925','2004-10-25 21:16:49','','2007-02-22 23:20:45','*'),
('昇給区分','1','定期昇給','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('昇給区分','2','臨時昇給','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('賞与支給月数','0','','2.30','2008-09-18 13:34:20','','2007-05-29 22:31:23','00001'),
('性別','1','男性','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('性別','2','女性','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('税区分','1','甲欄','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('税区分','2','乙欄','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('税区分','3','丙欄','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('組合区分','1','組合員','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('組合区分','2','非組合員','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('遡及区分','0','無し','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('遡及区分','1','遡及','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('早退証明書','0','無し','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('早退証明書','1','有り','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('早退理由','0','無し','','2005-04-23 23:19:01','','2008-07-10 03:41:17','admin'),
('早退理由','1','体調不良','','2005-04-23 23:19:20','','2008-07-10 03:41:17','admin'),
('早退理由','2','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('早退理由','3','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('早退理由','4','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('早退理由','5','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('早退理由','6','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('早退理由','7','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('早退理由','8','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('早退理由','9','その他','','2005-04-23 23:19:40','','2008-07-10 03:41:17','admin'),
('続柄','110','夫','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','120','妻','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','130','父母','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','140','子','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','210','祖父母','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','220','孫','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','250','兄弟姉妹','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','260','兄姉','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','270','弟妹','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','310','祖父母','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','320','孫','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','330','伯叔父母','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('続柄','350','甥姪','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('遅刻証明書','0','無し','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('遅刻証明書','1','有り','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('遅刻理由','0','無し','','2005-04-23 23:21:40','','2008-07-10 03:41:17','admin'),
('遅刻理由','1','電車遅延','','2005-04-23 23:21:25','','2008-07-10 03:41:17','admin'),
('遅刻理由','2','無断','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('遅刻理由','3','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('遅刻理由','4','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('遅刻理由','5','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('遅刻理由','6','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('遅刻理由','7','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('遅刻理由','8','','','2007-06-26 02:19:27','*','2008-07-10 03:41:17','admin'),
('遅刻理由','9','その他','','2005-04-23 23:21:00','','2008-07-10 03:41:17','admin'),
('通勤手当距離区分','0','無し','0','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当距離区分','1','45ｋmから','24500','2004-10-21 22:11:08','','2004-10-21 22:13:28',''),
('通勤手当距離区分','2','35ｋmから45ｋm未満','20900','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当距離区分','3','25ｋmから35ｋm未満','16100','2004-10-21 22:13:49','','2004-10-21 22:14:04',''),
('通勤手当距離区分','4','15ｋmから25ｋm未満','11300','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当距離区分','5','10ｋmから15ｋm未満','6500','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当距離区分','6','2ｋmから10ｋm未満','4100','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当距離区分','7','2ｋm未満','0','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当区分','1','交通機関又は有料道路','100000','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当区分','2','自転車や自動車','100000','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当区分','3','定期乗車券','100000','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当区分','4','その他定期乗車券','100000','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当支給サイクル','1','１ヶ月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当支給サイクル','2','2ヶ月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当支給サイクル','3','3ヶ月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当支給サイクル','6','6ヶ月','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当支給サイクル','9','日払い','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当支給方法','1','給与','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当支給方法','2','現金','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('通勤手当支給方法','3','現物','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('等級','0','無し','','2004-10-04 19:57:13','','2007-02-15 18:52:44','11111'),
('等級','1','1等級','','2008-09-18 13:34:20','','2007-05-16 20:38:38','*'),
('等級','2','2等級','','2008-09-18 13:34:20','','2005-05-01 21:43:00',''),
('等級','3','3等級','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('等級','4','4等級','','2008-09-18 13:34:20','','2005-05-01 21:38:30',''),
('等級','5','5等級','','2008-09-18 13:34:20','','2005-05-01 21:43:10',''),
('入力単位','分','分の単位','15','2008-09-18 13:34:20','','2008-07-10 03:41:17','admin'),
('年末調整限度額','小規模企業共済控除','','999999','2008-09-18 13:34:20','','2007-04-21 00:17:53','*'),
('年末調整限度額','生命保険料控除','','100000','2008-09-18 13:34:20','','2007-04-21 00:17:53','*'),
('年末調整限度額','損害保険料控除','','15000','2008-09-18 13:34:20','','2007-04-21 00:17:53','*'),
('半休区分','0','通常','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('半休区分','1','半休','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('被保険者種別','0','未定義()','','2008-09-18 13:36:06','11111','2008-09-18 13:36:06',''),
('被保険者種別','1','坑内員以外の男子(1)','','2006-11-30 01:12:58','','2006-11-30 01:12:58',''),
('被保険者種別','2','女子(2)','','2006-11-30 01:12:58','','2006-11-30 01:12:58',''),
('被保険者種別','3','坑内員(3)','','2006-11-30 01:12:58','','2006-11-30 01:12:58',''),
('被保険者種別','5','基金加入で坑内員以外の男子(5)','','2006-11-30 01:12:58','','2006-11-30 01:12:58',''),
('被保険者種別','6','基金加入で女子(6)','','2006-11-30 01:12:58','','2006-11-30 01:12:58',''),
('被保険者種別','7','基金加入で坑内員(7)','','2006-11-30 01:12:58','','2006-11-30 01:12:58',''),
('評価タイプ','1','点数','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('評価タイプ','2','金額','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('扶養形態','1','控除対象配偶者','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('扶養形態','2','老人控除対象配偶者','','2008-09-18 13:34:20','','2006-09-28 22:33:01',''),
('扶養形態','3','同居老親等','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('扶養形態','4','その他','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('扶養形態','5','特定扶養親族','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('扶養形態','9','無し','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('有給休暇','繰越区分','0=当年のみ、1=合計で繰越','1','2004-10-28 19:00:10','','2008-08-04 23:02:04','admin'),
('有給休暇','繰越月','','1','2004-10-28 19:01:25','','2008-08-04 23:02:04','admin'),
('有給休暇','繰越日数','','20','2004-10-28 19:00:49','','2008-08-04 23:02:04','admin'),
('有給休暇','時間単位年休','','1','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('有給休暇','年休単位時間','','','2010-03-02 18:01:55','admin','2010-03-02 09:01:55','admin'),
('有給休暇支給','','','','2008-06-26 20:10:42','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','00','0年','5','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','01','1年','7','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','02','2年','8','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','03','3年','9','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','04','4年','10','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','05','5年','15','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','06','6年','15','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','07','7年','15','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','08','8年','15','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','09','9年','15','2008-08-04 23:00:02','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','10','10年','20','2008-08-04 22:47:00','admin','2008-08-04 23:02:04','admin'),
('有給休暇支給','11','10年以上','20','2008-08-04 22:47:00','admin','2008-08-04 23:02:04','admin'),
('有無','0','無','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('有無','1','有','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('預金種別1','1','普通','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('預金種別1','2','当座','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('預金種別2','1','普通','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('預金種別2','2','当座','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('預金種別3','1','普通','','2008-09-18 13:36:06','','2008-09-18 13:36:06',''),
('預金種別3','2','当座','','2008-09-18 13:36:06','','2008-09-18 13:36:06','');
/*!40000 ALTER TABLE `M_CODE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_EMERGENCY`
--

DROP TABLE IF EXISTS `M_EMERGENCY`;
CREATE TABLE `M_EMERGENCY` (
  `EMCODE` int(11) unsigned zerofill NOT NULL default '00000000000' COMMENT '連番',
  `KCODE` varchar(10) NOT NULL COMMENT '社員コード',
  `NAME` varchar(100) NOT NULL COMMENT '連絡先氏名',
  `PHONE` varchar(20) NOT NULL COMMENT '電話番号',
  `CELL` varchar(20) NOT NULL COMMENT '携帯番号',
  `POSTALCODE` varchar(10) NOT NULL COMMENT '郵便番号',
  `PREFECTURES` int(11) NOT NULL default '0' COMMENT '都道府県コード',
  `JYUUSYO1` varchar(50) NOT NULL COMMENT '住所１',
  `JYUUSYO2` varchar(50) NOT NULL COMMENT '住所２',
  `JYUUSYO3` varchar(50) NOT NULL COMMENT '住所３',
  `DELETEFLAG` int(11) NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`EMCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='緊急連絡先';

--
-- Dumping data for table `M_EMERGENCY`
--

LOCK TABLES `M_EMERGENCY` WRITE;
/*!40000 ALTER TABLE `M_EMERGENCY` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_EMERGENCY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_EXPORT`
--

DROP TABLE IF EXISTS `M_EXPORT`;
CREATE TABLE `M_EXPORT` (
  `ENAME` varchar(20) NOT NULL default '' COMMENT '名称',
  `EFILE` varchar(20) NOT NULL default '' COMMENT 'ファイルID',
  `ELINE` int(5) NOT NULL default '0' COMMENT '行',
  `EFID` varchar(20) NOT NULL default '' COMMENT 'フィールドID',
  `EFTYPE` varchar(10) NOT NULL default '' COMMENT 'フィールドTYPE',
  `EFNAME` varchar(50) NOT NULL default '' COMMENT 'フィールド名称',
  `DELETEFLAG` int(11) NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`ENAME`,`EFILE`,`ELINE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='エキスポートマスタ';

--
-- Dumping data for table `M_EXPORT`
--

LOCK TABLES `M_EXPORT` WRITE;
/*!40000 ALTER TABLE `M_EXPORT` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_EXPORT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_KAISYA`
--

DROP TABLE IF EXISTS `M_KAISYA`;
CREATE TABLE `M_KAISYA` (
  `ID` varchar(4) NOT NULL default '' COMMENT '事業所コード',
  `KAIMEI` varchar(25) NOT NULL default '' COMMENT '会社名',
  `KAIFURI` varchar(50) NOT NULL default '' COMMENT 'ふりがな',
  `KJIGYONUSI` varchar(12) NOT NULL default '' COMMENT '事業主',
  `KAIYUBIN` varchar(8) NOT NULL default '' COMMENT '郵便番号',
  `KAIJYUSYO` varchar(37) NOT NULL default '' COMMENT '住所',
  `KAITEL` varchar(20) NOT NULL default '' COMMENT '電話番号',
  `KAIFAX` varchar(20) NOT NULL default '' COMMENT 'ファックス番号',
  `RODOUBI` int(4) NOT NULL default '0' COMMENT '月間所定労働日数',
  `ROUDOUJI` int(4) NOT NULL default '0' COMMENT '月間所定労働時間数',
  `ROUDOUJI1` int(4) NOT NULL default '0' COMMENT '一日所定労働時間数',
  `ZARITU` int(4) NOT NULL default '0' COMMENT '普通残業割増率',
  `KSRITU` int(4) NOT NULL default '0' COMMENT '休日残業割増率',
  `SNRITU` int(4) NOT NULL default '0' COMMENT '深夜残業割増率',
  `ZANTANKBN` varchar(1) NOT NULL default '' COMMENT '残業単価自動計算',
  `RITKOYOU` double NOT NULL default '0' COMMENT '雇用保険率',
  `RITKKOYOU` double NOT NULL default '0' COMMENT '雇用保険率会社',
  `RITKENPO` double NOT NULL default '0' COMMENT '健康保険料率',
  `RITKKENPO` double NOT NULL default '0' COMMENT '健康保険料率会社',
  `RITKAIGO` double NOT NULL default '0' COMMENT '介護保険料率',
  `RITKKAIGO` double NOT NULL default '0' COMMENT '介護保険料率会社',
  `RITKOSEI` double NOT NULL default '0' COMMENT '厚生年金料率',
  `RITKKOSEI` double NOT NULL default '0' COMMENT '厚生年金料率会社',
  `RITKOSEI3` double NOT NULL default '0' COMMENT '厚生年金三種料率',
  `RITKKOSEI3` double NOT NULL default '0' COMMENT '厚生年金三種料率',
  `KOSEI3KBN` varchar(1) NOT NULL default '' COMMENT '厚生年金第三種',
  `KIKINKBN` varchar(1) NOT NULL default '' COMMENT '厚生年金基金加入',
  `RITKIKIN` double NOT NULL default '0' COMMENT '厚生年金料率基金',
  `RITKKIKIN` double NOT NULL default '0' COMMENT '厚生年金料率基金',
  `RITKIKIN3` double NOT NULL default '0' COMMENT '厚生年金三種料率基金',
  `RITKKIKIN3` double NOT NULL default '0' COMMENT '厚生年金三種料率基金',
  `SYAHOFUGO` varchar(2) NOT NULL default '' COMMENT '郡市区符号',
  `SYAHOKIGO` varchar(4) NOT NULL default '' COMMENT '事業所記号',
  `SYAHOBANGO` varchar(5) NOT NULL default '' COMMENT '事業所',
  `KENPOJINO` varchar(4) NOT NULL default '' COMMENT '健康保険事業所番号',
  `KIKINJINO` varchar(19) NOT NULL default '' COMMENT '厚生年金基金事業所番号',
  `KAIBANK` varchar(50) NOT NULL default '' COMMENT '取引銀行名',
  `SERVER` varchar(200) NOT NULL default '' COMMENT 'サーバー名',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='会社基礎情報';

--
-- Dumping data for table `M_KAISYA`
--

LOCK TABLES `M_KAISYA` WRITE;
/*!40000 ALTER TABLE `M_KAISYA` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_KAISYA` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_KEISAN`
--

DROP TABLE IF EXISTS `M_KEISAN`;
CREATE TABLE `M_KEISAN` (
  `KTNEN` int(4) NOT NULL default '0' COMMENT '給与計算年',
  `KTTUKI` int(2) NOT NULL default '0' COMMENT '給与計算月',
  `KSNEN` int(4) NOT NULL default '0' COMMENT '給与支払年',
  `KSTUKI` int(2) NOT NULL default '0' COMMENT '給与支払月',
  `KSHI` int(2) NOT NULL default '0' COMMENT '給与支払日',
  `KKANRYOU` varchar(1) NOT NULL default '' COMMENT '給与完了',
  `STNEN` int(4) NOT NULL default '0' COMMENT '賞与計算年',
  `STTUKI` int(2) NOT NULL default '0' COMMENT '賞与計算月',
  `SSNEN` int(4) NOT NULL default '0' COMMENT '賞与支払年',
  `SSTUKI` int(2) NOT NULL default '0' COMMENT '賞与支払月',
  `SSHI` int(2) NOT NULL default '0' COMMENT '賞与支払日',
  `SKANRYOU` varchar(1) NOT NULL default '' COMMENT '賞与完了',
  `NTNEN` int(4) NOT NULL default '0' COMMENT '年調計算年',
  `NKANRYOU` varchar(1) NOT NULL default '' COMMENT '年調完了',
  `TTNEN` int(4) NOT NULL default '0' COMMENT '算定計算年',
  `TTTUKI` int(2) NOT NULL default '0' COMMENT '算定計算月',
  `TKANRYOU` varchar(1) NOT NULL default '' COMMENT '算定完了',
  `GTNEN` int(4) NOT NULL default '0' COMMENT '月変計算年',
  `GTTUKI` int(2) NOT NULL default '0' COMMENT '月変計算月',
  `GKANRYOU` varchar(1) NOT NULL default '' COMMENT '月変完了',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`KTNEN`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='計算情報';

--
-- Dumping data for table `M_KEISAN`
--

LOCK TABLES `M_KEISAN` WRITE;
/*!40000 ALTER TABLE `M_KEISAN` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_KEISAN` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_KIHON`
--

DROP TABLE IF EXISTS `M_KIHON`;
CREATE TABLE `M_KIHON` (
  `KCODE` varchar(10) NOT NULL default '' COMMENT '社員コード',
  `SIMEI` varchar(12) NOT NULL default '' COMMENT '氏名',
  `FURIGANA` varchar(25) NOT NULL default '' COMMENT 'ふりがな',
  `SCODE` varchar(6) NOT NULL default '' COMMENT '所属コード',
  `YCODE` varchar(5) NOT NULL default '' COMMENT '役職コード',
  `TOKYU` varchar(4) NOT NULL default '' COMMENT '等級',
  `JCODE` varchar(4) NOT NULL COMMENT '事業所コード',
  `NYDATE` int(8) NOT NULL default '0' COMMENT '入社日',
  `TSDATE` int(8) NOT NULL default '0' COMMENT '退職日',
  `KNKUBUN` varchar(1) NOT NULL default '' COMMENT '休退職区分',
  `KYKUBUN` varchar(1) NOT NULL default '' COMMENT '給与区分',
  `TXKUBUN` varchar(1) NOT NULL default '' COMMENT '税区分',
  `TXKUBUNX` varchar(1) NOT NULL default '' COMMENT 'その他税区分',
  `KMKUBUN` varchar(1) NOT NULL default '' COMMENT '組合区分',
  `PTKUBUN` varchar(1) NOT NULL default '' COMMENT 'パート区分',
  `SHKUBUN` varchar(1) NOT NULL default '' COMMENT '支払区分',
  `SIWAKECD` varchar(10) NOT NULL default '' COMMENT '仕訳集計コード',
  `HAIGUSYA` varchar(1) NOT NULL default '' COMMENT '扶養配偶者',
  `FUYOSU` int(2) NOT NULL default '0' COMMENT '扶養家族数',
  `YUKYU` double NOT NULL default '0' COMMENT '有給残',
  `NENREI` int(4) NOT NULL default '0' COMMENT '年齢',
  `KINZOKU` int(4) NOT NULL default '0' COMMENT '勤続年数',
  `KENPONO` varchar(12) NOT NULL default '' COMMENT '健保番号',
  `KOHONO` varchar(12) NOT NULL default '' COMMENT '厚保番号',
  `KUSER` varchar(10) NOT NULL default '' COMMENT 'ユーザ',
  `PASSW` varchar(10) NOT NULL default '' COMMENT 'パスワード',
  `EMAIL` varchar(50) NOT NULL default '' COMMENT 'email',
  `NINSYO` varchar(10) NOT NULL default '' COMMENT '認証者',
  `DATALVL` int(2) NOT NULL default '0' COMMENT 'データ権限レベル',
  `PROGLEVEL` int(2) NOT NULL default '0' COMMENT 'プログラム使用権限',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`KCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='社員マスター基本部';

--
-- Dumping data for table `M_KIHON`
--

LOCK TABLES `M_KIHON` WRITE;
/*!40000 ALTER TABLE `M_KIHON` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_KIHON` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_KINTAI`
--

DROP TABLE IF EXISTS `M_KINTAI`;
CREATE TABLE `M_KINTAI` (
  `KCODE` varchar(10) NOT NULL default '' COMMENT '社員コード',
  `SIKYUYM` varchar(8) NOT NULL default '' COMMENT '支給年月',
  `SNEN` int(4) NOT NULL default '0' COMMENT '支給年',
  `STUKI` int(2) NOT NULL default '0' COMMENT '支給月',
  `SHI` int(2) NOT NULL default '0' COMMENT '支給日',
  `SNISSU` double NOT NULL default '0' COMMENT '出勤日数',
  `SKAISU` int(4) NOT NULL default '0' COMMENT '出勤回数',
  `KINMUJI` int(4) NOT NULL default '0' COMMENT '勤務時間',
  `KYUKEIJI` int(4) NOT NULL default '0' COMMENT '休憩時間',
  `YUKYU` double NOT NULL default '0' COMMENT '有給',
  `TOKUKYU` double NOT NULL default '0' COMMENT '特別休暇',
  `KEKKIN` double NOT NULL default '0' COMMENT '一般欠勤日数',
  `SKEKKIN` double NOT NULL default '0' COMMENT '傷病欠勤日数',
  `DAIKYU` double NOT NULL default '0' COMMENT '代替休暇',
  `FURIKAE` double NOT NULL default '0' COMMENT '振替休暇',
  `SONOTA` int(4) NOT NULL default '0' COMMENT 'その他休暇',
  `TISOKAI` int(4) NOT NULL default '0' COMMENT '遅刻早退回数',
  `TIJIKAN` int(4) NOT NULL default '0' COMMENT '遅刻早退時間',
  `ZAJIKAN` int(4) NOT NULL default '0' COMMENT '普通残業時間',
  `KSJIKAN` int(4) NOT NULL default '0' COMMENT '休日出勤時間',
  `SNJIKAN` int(4) NOT NULL default '0' COMMENT '深夜勤務時間',
  `KAIKIN` int(1) NOT NULL default '0' COMMENT '精皆勤手当支給',
  `SYOKUJIKAISU` int(4) NOT NULL default '0' COMMENT '食事手当支給回数',
  `CYOKUKAISU1` int(4) NOT NULL default '0' COMMENT '1直手当支給回数',
  `CYOKUKAISU2` int(4) NOT NULL default '0' COMMENT '2直手当支給回数',
  `CYOKUKAISU3` int(4) NOT NULL default '0' COMMENT '3直手当支給回数',
  `HOKAKAISU1` int(4) NOT NULL default '0' COMMENT 'その他支給回数1',
  `HOKAKAISU2` int(4) NOT NULL default '0' COMMENT 'その他支給回数2',
  `HOKAKAISU3` int(4) NOT NULL default '0' COMMENT 'その他支給回数3',
  `HOKAKAISU4` int(4) NOT NULL default '0' COMMENT 'その他支給回数4',
  `HOKAKAISU5` int(4) NOT NULL default '0' COMMENT 'その他支給回数5',
  `SINSEIGAKU` int(8) NOT NULL default '0' COMMENT '支払申請額',
  `NIJIKYU` int(4) NOT NULL default '0' COMMENT '二時間年休',
  `WARIMASI1` int(11) NOT NULL default '0' COMMENT '1.00割増',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`KCODE`,`SIKYUYM`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='勤怠集計';

--
-- Dumping data for table `M_KINTAI`
--

LOCK TABLES `M_KINTAI` WRITE;
/*!40000 ALTER TABLE `M_KINTAI` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_KINTAI` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_KINTAIKEISAN`
--

DROP TABLE IF EXISTS `M_KINTAIKEISAN`;
CREATE TABLE `M_KINTAIKEISAN` (
  `KTNEN` int(4) NOT NULL default '0' COMMENT '給与計算年',
  `KTTUKI` int(2) NOT NULL default '0' COMMENT '給与計算月',
  `KSNEN` int(4) NOT NULL default '0' COMMENT '給与支払年',
  `KSTUKI` int(2) NOT NULL default '0' COMMENT '給与支払月',
  `KSHI` int(2) NOT NULL default '0' COMMENT '給与支払日',
  `KKANRYOU` varchar(1) NOT NULL default '' COMMENT '給与完了',
  `STNEN` int(4) NOT NULL default '0' COMMENT '賞与計算年',
  `STTUKI` int(2) NOT NULL default '0' COMMENT '賞与計算月',
  `SSNEN` int(4) NOT NULL default '0' COMMENT '賞与支払年',
  `SSTUKI` int(2) NOT NULL default '0' COMMENT '賞与支払月',
  `SSHI` int(2) NOT NULL default '0' COMMENT '賞与支払日',
  `SKANRYOU` varchar(1) NOT NULL default '' COMMENT '賞与完了',
  `NTNEN` int(4) NOT NULL default '0' COMMENT '年調計算年',
  `NKANRYOU` varchar(1) NOT NULL default '' COMMENT '年調完了',
  `TTNEN` int(4) NOT NULL default '0' COMMENT '算定計算年',
  `TTTUKI` int(2) NOT NULL default '0' COMMENT '算定計算月',
  `TKANRYOU` varchar(1) NOT NULL default '' COMMENT '算定完了',
  `GTNEN` int(4) NOT NULL default '0' COMMENT '月変計算年',
  `GTTUKI` int(2) NOT NULL default '0' COMMENT '月変計算月',
  `GKANRYOU` varchar(1) NOT NULL default '' COMMENT '月変完了',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`KTNEN`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='勤怠計算情報';

--
-- Dumping data for table `M_KINTAIKEISAN`
--

LOCK TABLES `M_KINTAIKEISAN` WRITE;
/*!40000 ALTER TABLE `M_KINTAIKEISAN` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_KINTAIKEISAN` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_KINTAIKINMU`
--

DROP TABLE IF EXISTS `M_KINTAIKINMU`;
CREATE TABLE `M_KINTAIKINMU` (
  `KCODE` varchar(10) NOT NULL COMMENT '社員コード',
  `SIKYUYM` varchar(8) NOT NULL COMMENT '支給年月',
  `KINMU` varchar(10) NOT NULL COMMENT '勤務形態',
  `SNISSU` double NOT NULL default '0' COMMENT '出勤日数',
  `ZAJIKAN` int(8) NOT NULL default '0' COMMENT '普通残業時間',
  `SZJIKAN` int(8) NOT NULL default '0' COMMENT '深夜残業時間',
  `HSJIKAN` int(8) NOT NULL default '0' COMMENT '法定休日出勤時間',
  `TSJIKAN` int(8) NOT NULL default '0' COMMENT '特別出勤時間',
  `SYOKUJI` int(8) NOT NULL default '0' COMMENT '食事手当支給',
  `CYOKU1` int(8) NOT NULL default '0' COMMENT '1直手当支給',
  `CYOKU2` int(8) NOT NULL default '0' COMMENT '2直手当支給',
  `CYOKU3` int(8) NOT NULL default '0' COMMENT '3直手当支給',
  `HOKA1` int(8) NOT NULL default '0' COMMENT 'その他支給1',
  `HOKA2` int(8) NOT NULL default '0' COMMENT 'その他支給2',
  `HOKA3` int(8) NOT NULL default '0' COMMENT 'その他支給3',
  `HOKA4` int(8) NOT NULL default '0' COMMENT 'その他支給4',
  `HOKA5` int(8) NOT NULL default '0' COMMENT 'その他支給5',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`KCODE`,`SIKYUYM`,`KINMU`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='勤怠勤務別集計';

--
-- Dumping data for table `M_KINTAIKINMU`
--

LOCK TABLES `M_KINTAIKINMU` WRITE;
/*!40000 ALTER TABLE `M_KINTAIKINMU` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_KINTAIKINMU` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_KOJIN`
--

DROP TABLE IF EXISTS `M_KOJIN`;
CREATE TABLE `M_KOJIN` (
  `KCODE` varchar(10) NOT NULL default '' COMMENT '社員コード',
  `SEINENBI` int(8) NOT NULL default '0' COMMENT '生年月日',
  `SEIBETU` varchar(1) NOT NULL default '' COMMENT '性別',
  `YUBINBAN` varchar(10) NOT NULL default '' COMMENT '郵便番号',
  `PREFECTURES` int(11) NOT NULL default '0' COMMENT '都道府県コード',
  `JYUUSYO1` varchar(50) NOT NULL default '' COMMENT '住所1',
  `JYUUSYO2` varchar(50) NOT NULL default '' COMMENT '住所2',
  `JYUUSYO3` varchar(50) NOT NULL default '' COMMENT '住所3',
  `TEL` varchar(15) NOT NULL default '' COMMENT '電話番号',
  `FAX` varchar(15) NOT NULL default '' COMMENT 'Fax番号',
  `KEITAI` varchar(15) NOT NULL default '' COMMENT '携帯番号',
  `KETUEKI` varchar(4) NOT NULL default '' COMMENT '血液型',
  `SIKAKU` varchar(255) NOT NULL default '' COMMENT '資格等',
  `KENKOU` varchar(255) NOT NULL default '' COMMENT '健康状態',
  `TEKIYOU` varchar(255) NOT NULL default '' COMMENT '摘要',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`KCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='社員マスター個人部';

--
-- Dumping data for table `M_KOJIN`
--

LOCK TABLES `M_KOJIN` WRITE;
/*!40000 ALTER TABLE `M_KOJIN` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_KOJIN` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_SCHEDULE`
--

DROP TABLE IF EXISTS `M_SCHEDULE`;
CREATE TABLE `M_SCHEDULE` (
  `KCODE` varchar(10) NOT NULL default '' COMMENT '社員コード',
  `HIZUKE` varchar(10) NOT NULL default '' COMMENT '日付',
  `NEN` int(4) NOT NULL default '0' COMMENT '年',
  `TUKI` int(2) NOT NULL default '0' COMMENT '月',
  `HI` int(2) NOT NULL default '0' COMMENT '日',
  `SYOZOKU` varchar(6) NOT NULL default '' COMMENT '所属コード',
  `NINSYO` varchar(10) NOT NULL default '' COMMENT '認証者',
  `SYJIKOKU` varchar(5) NOT NULL default '' COMMENT '出勤時刻',
  `KINMU` varchar(10) NOT NULL default '' COMMENT '勤務形態',
  `SHANKYUKB` varchar(1) NOT NULL default '' COMMENT '出勤半休区分',
  `KYUSYUKB` varchar(1) NOT NULL default '' COMMENT '休出区分',
  `TIRIYUU` varchar(10) NOT NULL default '' COMMENT '遅刻理由',
  `TICOMENT` varchar(50) NOT NULL default '' COMMENT '遅刻コメント',
  `TISYOUMEI` varchar(1) NOT NULL default '' COMMENT '遅刻証明書',
  `TIJIKAN` int(4) NOT NULL default '0' COMMENT '遅刻時間',
  `SYTIMES` varchar(20) NOT NULL default '' COMMENT '出勤入力日時',
  `TAJIKOKU` varchar(5) NOT NULL default '' COMMENT '退社時刻',
  `KINMUJI` int(4) NOT NULL default '0' COMMENT '勤務時間',
  `KYUKEIJI` int(4) NOT NULL default '0' COMMENT '休憩時間',
  `THANKYUKB` varchar(1) NOT NULL default '' COMMENT '退勤半休区分',
  `SORIYUU` varchar(10) NOT NULL default '' COMMENT '早退理由',
  `SOCOMENT` varchar(50) NOT NULL default '' COMMENT '早退コメント',
  `SOSYOUMEI` varchar(1) NOT NULL default '' COMMENT '早退証明書',
  `SOJIKAN` int(4) NOT NULL default '0' COMMENT '早退時間',
  `ZAJIKAN` int(4) NOT NULL default '0' COMMENT '残業時間',
  `KSJIKAN` int(4) NOT NULL default '0' COMMENT '休出時間',
  `SNJIKAN` int(4) NOT NULL default '0' COMMENT '深夜時間',
  `SYOKUJI` int(4) NOT NULL default '0' COMMENT '食事手当支給',
  `CYOKU1` int(4) NOT NULL default '0' COMMENT '1直手当支給',
  `CYOKU2` int(4) NOT NULL default '0' COMMENT '2直手当支給',
  `CYOKU3` int(4) NOT NULL default '0' COMMENT '3直手当支給',
  `HOKA1` int(4) NOT NULL default '0' COMMENT 'その他支給1',
  `HOKA2` int(4) NOT NULL default '0' COMMENT 'その他支給2',
  `HOKA3` int(4) NOT NULL default '0' COMMENT 'その他支給3',
  `HOKA4` int(4) NOT NULL default '0' COMMENT 'その他支給4',
  `HOKA5` int(4) NOT NULL default '0' COMMENT 'その他支給5',
  `TATIMES` varchar(20) NOT NULL default '' COMMENT '退社入力日時',
  `KKRIYUU` varchar(10) NOT NULL default '' COMMENT '休暇理由',
  `DAIKYUJYU` varchar(10) NOT NULL default '' COMMENT '代休充当日',
  `KKCOMENT` varchar(50) NOT NULL default '' COMMENT '休暇コメント',
  `KKSYOUMEI` varchar(1) NOT NULL default '' COMMENT '休暇証明書',
  `KKJIKAN` int(4) NOT NULL default '0' COMMENT '休暇時間',
  `KKTIMES` varchar(20) NOT NULL default '' COMMENT '休暇入力日時',
  `SNRIYUU` varchar(1) NOT NULL default '' COMMENT '承認理由',
  `SNCOMENT` varchar(50) NOT NULL default '' COMMENT '承認コメント',
  `SNTIMES` varchar(20) NOT NULL default '' COMMENT '承認入力日時',
  `UPDTTIMES` varchar(20) NOT NULL default '' COMMENT '更新日時',
  `NIJIKYU` int(11) NOT NULL default '0' COMMENT '二時間年休',
  `WARIMASI1` int(11) NOT NULL default '0' COMMENT '1.00割増',
  `ZKINMU` varchar(10) NOT NULL default '' COMMENT '前回勤務形態',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`KCODE`,`HIZUKE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='出勤予定簿';

--
-- Dumping data for table `M_SCHEDULE`
--

LOCK TABLES `M_SCHEDULE` WRITE;
/*!40000 ALTER TABLE `M_SCHEDULE` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_SCHEDULE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_SYOZOKU`
--

DROP TABLE IF EXISTS `M_SYOZOKU`;
CREATE TABLE `M_SYOZOKU` (
  `SCODE` varchar(6) NOT NULL default '' COMMENT '所属コード',
  `SNAME` varchar(20) NOT NULL default '' COMMENT '所属部課名',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`SCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='所属マスタ';

--
-- Dumping data for table `M_SYOZOKU`
--

LOCK TABLES `M_SYOZOKU` WRITE;
/*!40000 ALTER TABLE `M_SYOZOKU` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_SYOZOKU` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_SYUKKINBO`
--

DROP TABLE IF EXISTS `M_SYUKKINBO`;
CREATE TABLE `M_SYUKKINBO` (
  `KCODE` varchar(10) NOT NULL default '' COMMENT '社員コード',
  `HIZUKE` varchar(10) NOT NULL default '' COMMENT '日付',
  `NEN` int(4) NOT NULL default '0' COMMENT '年',
  `TUKI` int(2) NOT NULL default '0' COMMENT '月',
  `HI` int(2) NOT NULL default '0' COMMENT '日',
  `SYOZOKU` varchar(6) NOT NULL default '' COMMENT '所属コード',
  `NINSYO` varchar(10) NOT NULL default '' COMMENT '認証者',
  `SYJIKOKU` varchar(5) NOT NULL default '' COMMENT '出勤時刻',
  `KINMU` varchar(10) NOT NULL default '' COMMENT '勤務形態',
  `SHANKYUKB` varchar(1) NOT NULL default '' COMMENT '出勤半休区分',
  `KYUSYUKB` varchar(1) NOT NULL default '' COMMENT '休出区分',
  `TIRIYUU` varchar(10) NOT NULL default '' COMMENT '遅刻理由',
  `TICOMENT` varchar(50) NOT NULL default '' COMMENT '遅刻コメント',
  `TISYOUMEI` varchar(1) NOT NULL default '' COMMENT '遅刻証明書',
  `TIJIKAN` int(4) NOT NULL default '0' COMMENT '遅刻時間',
  `SYTIMES` varchar(20) NOT NULL default '' COMMENT '出勤入力日時',
  `TAJIKOKU` varchar(5) NOT NULL default '' COMMENT '退社時刻',
  `KINMUJI` int(4) NOT NULL default '0' COMMENT '勤務時間',
  `KYUKEIJI` int(4) NOT NULL default '0' COMMENT '休憩時間',
  `THANKYUKB` varchar(1) NOT NULL default '' COMMENT '退勤半休区分',
  `SORIYUU` varchar(10) NOT NULL default '' COMMENT '早退理由',
  `SOCOMENT` varchar(50) NOT NULL default '' COMMENT '早退コメント',
  `SOSYOUMEI` varchar(1) NOT NULL default '' COMMENT '早退証明書',
  `SOJIKAN` int(4) NOT NULL default '0' COMMENT '早退時間',
  `ZAJIKAN` int(4) NOT NULL default '0' COMMENT '残業時間',
  `KSJIKAN` int(4) NOT NULL default '0' COMMENT '休出時間',
  `SNJIKAN` int(4) NOT NULL default '0' COMMENT '深夜時間',
  `SYOKUJI` int(4) NOT NULL default '0' COMMENT '食事手当支給',
  `CYOKU1` int(4) NOT NULL default '0' COMMENT '1直手当支給',
  `CYOKU2` int(4) NOT NULL default '0' COMMENT '2直手当支給',
  `CYOKU3` int(4) NOT NULL default '0' COMMENT '3直手当支給',
  `HOKA1` int(4) NOT NULL default '0' COMMENT 'その他支給1',
  `HOKA2` int(4) NOT NULL default '0' COMMENT 'その他支給2',
  `HOKA3` int(4) NOT NULL default '0' COMMENT 'その他支給3',
  `HOKA4` int(4) NOT NULL default '0' COMMENT 'その他支給4',
  `HOKA5` int(4) NOT NULL default '0' COMMENT 'その他支給5',
  `TATIMES` varchar(20) NOT NULL default '' COMMENT '退社入力日時',
  `KKRIYUU` varchar(10) NOT NULL default '' COMMENT '休暇理由',
  `DAIKYUJYU` varchar(10) NOT NULL default '' COMMENT '代休充当日',
  `KKCOMENT` varchar(50) NOT NULL default '' COMMENT '休暇コメント',
  `KKSYOUMEI` varchar(1) NOT NULL default '' COMMENT '休暇証明書',
  `KKJIKAN` int(4) NOT NULL default '0' COMMENT '休暇時間',
  `KKTIMES` varchar(20) NOT NULL default '' COMMENT '休暇入力日時',
  `SNRIYUU` varchar(1) NOT NULL default '' COMMENT '承認理由',
  `SNCOMENT` varchar(50) NOT NULL default '' COMMENT '承認コメント',
  `SNTIMES` varchar(20) NOT NULL default '' COMMENT '承認入力日時',
  `UPDTTIMES` varchar(20) NOT NULL default '' COMMENT '更新日時',
  `NIJIKYU` int(11) NOT NULL default '0' COMMENT '二時間年休',
  `WARIMASI1` int(11) NOT NULL default '0' COMMENT '1.00割増',
  `ZKINMU` varchar(10) NOT NULL default '' COMMENT '前回勤務形態',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`KCODE`,`HIZUKE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='出勤簿';

--
-- Dumping data for table `M_SYUKKINBO`
--

LOCK TABLES `M_SYUKKINBO` WRITE;
/*!40000 ALTER TABLE `M_SYUKKINBO` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_SYUKKINBO` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_YAKUSYOKU`
--

DROP TABLE IF EXISTS `M_YAKUSYOKU`;
CREATE TABLE `M_YAKUSYOKU` (
  `YCODE` varchar(5) NOT NULL default '' COMMENT '役職コード',
  `YNAME` varchar(20) NOT NULL default '' COMMENT '役職名',
  `TOKYU` varchar(4) NOT NULL default '' COMMENT '等級',
  `TKEKKIN` varchar(1) NOT NULL default '' COMMENT '特別休暇控除有無',
  `KEKKIN` varchar(1) NOT NULL default '' COMMENT '一般欠勤控除有無',
  `SKEKKIN` varchar(1) NOT NULL default '' COMMENT '傷病欠勤控除有無',
  `TIJI` varchar(1) NOT NULL default '' COMMENT '遅刻早退控除有無',
  `ZAJI` varchar(1) NOT NULL default '' COMMENT '普通残業手当有無',
  `KSJI` varchar(1) NOT NULL default '' COMMENT '休日残業手当有無',
  `SNJI` varchar(1) NOT NULL default '' COMMENT '深夜残業手当有無',
  `KAIKIN` varchar(1) NOT NULL default '' COMMENT '精皆勤手当有無',
  `SYOKUJI` varchar(1) NOT NULL default '' COMMENT '食事手当有無',
  `CYOKU1` varchar(1) NOT NULL default '' COMMENT '1直手当有無',
  `CYOKU2` varchar(1) NOT NULL default '' COMMENT '2直手当有無',
  `CYOKU3` varchar(1) NOT NULL default '' COMMENT '3直手当有無',
  `HOKA1` varchar(1) NOT NULL default '' COMMENT 'その他支給1有無',
  `HOKA2` varchar(1) NOT NULL default '' COMMENT 'その他支給2有無',
  `HOKA3` varchar(1) NOT NULL default '' COMMENT 'その他支給3有無',
  `HOKA4` varchar(1) NOT NULL default '' COMMENT 'その他支給4有無',
  `HOKA5` varchar(1) NOT NULL default '' COMMENT 'その他支給5有無',
  `TKEKKINTAN` int(8) NOT NULL default '0' COMMENT '特別休暇控除単価',
  `KEKKINTAN` int(8) NOT NULL default '0' COMMENT '一般欠勤控除単価',
  `SKEKKINTAN` int(8) NOT NULL default '0' COMMENT '傷病欠勤控除単価',
  `TIJITAN` int(8) NOT NULL default '0' COMMENT '遅刻早退控除単価',
  `ZAJITAN` int(8) NOT NULL default '0' COMMENT '普通残業手当単価',
  `KSJITAN` int(8) NOT NULL default '0' COMMENT '休日残業手当単価',
  `SNJITAN` int(8) NOT NULL default '0' COMMENT '深夜残業手当単価',
  `KAIKINTAN` int(8) NOT NULL default '0' COMMENT '精皆勤手当単価',
  `SYOKUJITAN` int(8) NOT NULL default '0' COMMENT '食事手当単価',
  `CYOKU1TAN` int(8) NOT NULL default '0' COMMENT '1直手当単価',
  `CYOKU2TAN` int(8) NOT NULL default '0' COMMENT '2直手当単価',
  `CYOKU3TAN` int(8) NOT NULL default '0' COMMENT '3直手当単価',
  `HOKA1TAN` int(8) NOT NULL default '0' COMMENT 'その他支給1単価',
  `HOKA2TAN` int(8) NOT NULL default '0' COMMENT 'その他支給2単価',
  `HOKA3TAN` int(8) NOT NULL default '0' COMMENT 'その他支給3単価',
  `HOKA4TAN` int(8) NOT NULL default '0' COMMENT 'その他支給4単価',
  `HOKA5TAN` int(8) NOT NULL default '0' COMMENT 'その他支給5単価',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`YCODE`,`TOKYU`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='役職マスタ';

--
-- Dumping data for table `M_YAKUSYOKU`
--

LOCK TABLES `M_YAKUSYOKU` WRITE;
/*!40000 ALTER TABLE `M_YAKUSYOKU` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_YAKUSYOKU` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `M_YUKYU`
--

DROP TABLE IF EXISTS `M_YUKYU`;
CREATE TABLE `M_YUKYU` (
  `KCODE` varchar(10) NOT NULL default '' COMMENT '社員コード',
  `KYUYOYMD` int(8) NOT NULL default '0' COMMENT '給与計算年月日',
  `ZZANT` double NOT NULL default '0' COMMENT '前月残数（当年）',
  `ZZANZ` double NOT NULL default '0' COMMENT '前月残数（前年）',
  `SYOKA` double NOT NULL default '0' COMMENT '当月使用',
  `SYUTOKU` int(8) NOT NULL default '0' COMMENT '当月取得',
  `HAIKI` double NOT NULL default '0' COMMENT '当月廃棄',
  `TZANT` double NOT NULL default '0' COMMENT '当月残数（当年）',
  `TZANZ` double NOT NULL default '0' COMMENT '当月残数（前年）',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`KCODE`,`KYUYOYMD`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='有給休暇ファイル';

--
-- Dumping data for table `M_YUKYU`
--

LOCK TABLES `M_YUKYU` WRITE;
/*!40000 ALTER TABLE `M_YUKYU` DISABLE KEYS */;
/*!40000 ALTER TABLE `M_YUKYU` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `PM_ATTENDANCE`
--

DROP TABLE IF EXISTS `PM_ATTENDANCE`;
CREATE TABLE `PM_ATTENDANCE` (
  `ROUTEID` int(10) unsigned zerofill NOT NULL default '0000000000' COMMENT 'ルートID',
  `SCODE` varchar(10) NOT NULL COMMENT '所属コード',
  `KCODE` varchar(10) NOT NULL COMMENT '社員コード',
  `RTCODE` varchar(10) NOT NULL COMMENT 'ルートコード',
  `JCODE` varchar(4) NOT NULL COMMENT '事業所コード',
  `DELETEFLAG` int(10) unsigned NOT NULL default '0' COMMENT '削除フラグ',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL COMMENT '登録者',
  `UPDDT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL COMMENT '更新者',
  PRIMARY KEY  (`ROUTEID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='勤怠承認ルートマスタ';

--
-- Dumping data for table `PM_ATTENDANCE`
--

LOCK TABLES `PM_ATTENDANCE` WRITE;
/*!40000 ALTER TABLE `PM_ATTENDANCE` DISABLE KEYS */;
/*!40000 ALTER TABLE `PM_ATTENDANCE` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
