zc_invoice_address.sql 684 B

123456789101112
  1. CREATE TABLE `zc_invoice_address` (
  2. `zia_id` varchar(64) NOT NULL COMMENT 'ID',
  3. `zia_company_id` varchar(64) DEFAULT '' COMMENT '企业id(sys_company.scy_id)',
  4. `zia_address` varchar(100) NOT NULL COMMENT '收件地址',
  5. `zia_contacts` varchar(10) NOT NULL COMMENT '联系人',
  6. `zia_contacts_phone` varchar(11) NOT NULL COMMENT '联系人电话',
  7. `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  8. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  9. `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  10. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  11. PRIMARY KEY (`zia_id`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='发票地址表';