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