--
-- Table structure for table `condo_unit_bill`
--

CREATE TABLE IF NOT EXISTS `condo_unit_bill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_unit_id` int(11) NOT NULL,
  `condo_id` int(11) NOT NULL,
  `bill_type` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `year` varchar(4) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `condo_unit_bill_payment`
--

CREATE TABLE IF NOT EXISTS `condo_unit_bill_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_unit_bill_id` int(11) NOT NULL,
  `condo_id` int(11) NOT NULL,
  `condo_unit_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `processing_fee` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `molpay_status` varchar(20) DEFAULT NULL,
  `molpay_transaction_id` varchar(255) DEFAULT NULL,
  `molpay_order_id` varchar(255) DEFAULT NULL,
  `molpay_domain` varchar(255) DEFAULT NULL,
  `molpay_amount` varchar(255) DEFAULT NULL,
  `molpay_currency` varchar(255) DEFAULT NULL,
  `molpay_paydate` varchar(255) DEFAULT NULL,
  `molpay_appcode` varchar(255) DEFAULT NULL,
  `molpay_skey` varchar(255) DEFAULT NULL,
  `molpay_payment_method` varchar(255) DEFAULT NULL,
  `receipt` varchar(100) DEFAULT NULL,
  `offline_payment_date` date DEFAULT NULL,
  `offline_payment_receipt` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;