t_user_enterprise.sql 634 B

1234567891011
  1. CREATE TABLE
  2. IF NOT EXISTS t_user_enterprise (
  3. id int(10) NOT NULL auto_increment COMMENT '主键',
  4. spaceuu bigint(20) NOT NULL COMMENT '企业UU号',
  5. useruu bigint(20) NOT NULL COMMENT '用户UU号',
  6. create_time TIMESTAMP DEFAULT current_timestamp COMMENT '创建时间',
  7. update_time TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp COMMENT '修改时间',
  8. PRIMARY KEY (id) USING BTREE,
  9. INDEX `FKl4n5kbxma68mjnws8w6d409wv`(`useruu`) USING BTREE,
  10. INDEX `FKaawxsh58ir9u8r6pp2h55puqe`(`spaceuu`) USING BTREE
  11. ) ENGINE = INNODB auto_increment = 1 DEFAULT charset = utf8mb4 COMMENT '关联用户和企业信息表';