| 1234567891011121314151617181920212223242526272829303132 |
- CREATE TABLE
- IF NOT EXISTS t_enterprise (
- id int(10) NOT NULL auto_increment COMMENT '主键',
- spaceuu bigint(20) NOT NULL COMMENT '企业UU号',
- adminuu bigint(20) NOT NULL COMMENT '管理员UU号',
- bank VARCHAR(30) NOT NULL DEFAULT '' COMMENT '银行',
- bank_account VARCHAR(30) NOT NULL DEFAULT '' COMMENT '银行账户',
- business_code VARCHAR(30) NOT NULL DEFAULT '' COMMENT '营业执照号',
- business_code_image VARCHAR(255) NOT NULL DEFAULT '' COMMENT '营业执照',
- company_address VARCHAR(50) NOT NULL DEFAULT '' COMMENT '公司地址',
- company_city VARCHAR(30) NOT NULL DEFAULT '' COMMENT '城市',
- company_country VARCHAR(30) NOT NULL DEFAULT '' COMMENT '国家',
- company_province VARCHAR(30) NOT NULL DEFAULT '' COMMENT '省份',
- corporation VARCHAR(25) NOT NULL DEFAULT '' COMMENT '法定代表人',
- invite_space_uu BIGINT(20) NOT NULL DEFAULT '0' COMMENT '邀请企业UU号',
- invite_user_uu BIGINT(20) NOT NULL DEFAULT '0' COMMENT '邀请人UU号',
- main_business VARCHAR(50) NOT NULL DEFAULT '' COMMENT '主营业务',
- profession VARCHAR(50) NOT NULL DEFAULT '' COMMENT '行业',
- space_name VARCHAR(60) NOT NULL DEFAULT '' COMMENT '企业名称',
- tags VARCHAR(120) NOT NULL DEFAULT '' COMMENT '经营范围',
- telephone VARCHAR(20) NOT NULL DEFAULT '' COMMENT '公司联系电话',
- valid_code smallint(2) NOT NULL DEFAULT '0' COMMENT '企业认证状态',
- access_secret VARCHAR(50) NOT NULL DEFAULT '' COMMENT '企业秘钥',
- website VARCHAR(120) NOT NULL DEFAULT '' COMMENT 'ERP外网地址',
- invite_time VARCHAR(23) NOT NULL DEFAULT '' COMMENT '邀请时间',
- create_time TIMESTAMP DEFAULT current_timestamp COMMENT '创建时间',
- update_time TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp COMMENT '修改时间',
- PRIMARY KEY (id) USING BTREE,
- UNIQUE KEY space_name (space_name) USING BTREE,
- UNIQUE KEY business_code (business_code) USING BTREE,
- INDEX `FKfbavsugp68mxbewk6cuxklwfw`(`adminuu`) USING BTREE
- ) ENGINE = INNODB auto_increment = 1 DEFAULT charset = utf8mb4 COMMENT '企业信息表';
|
