bankbook, bankbookinfo 테이블 스키마

[GoogleCodeExporter]

CREATE TABLE `t_bankbook` (
  `bkbk_seqn` int(10) NOT NULL AUTO_INCREMENT,
  `bkbk_idid` int(11) NOT NULL,
  `incm_mony` bigint(20) NOT NULL,
  `exps_mony` bigint(20) NOT NULL,
  `tday_mony` bigint(20) NOT NULL,
  `reg_date` varchar(8) NOT NULL,
  `datetime` varchar(10) NOT NULL,
  PRIMARY KEY (`bkbk_seqn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `t_bankbookinfo` (
  `no` int(4) NOT NULL AUTO_INCREMENT,
  `bkbk_name` varchar(100) NOT NULL,
  `sort_numb` int(4) NOT NULL,
  `use_flag` varchar(2) NOT NULL,
  `bank` varchar(100) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Original issue reported on code.google.com by lispr...@gmail.com on 13 Dec 2013 at 1:48