import { generateTableSql } from '.';

generateTableSql([
  {
    tableName: 'user_whole',
    tableComment: '用户基础数据',
    primaryKey: 'user_id',
    columns: [
      {
        name: 'user_id', type: 'VARCHAR(32)', defaultValue: '', comment: '用户ID',
      },
      { name: 'create_time', type: 'VARCHAR(32)', comment: '创建时间' },
      { name: 'sex', type: 'VARCHAR(32)', comment: '性别' },
      { name: 'date_of_birth', type: 'VARCHAR(32)', comment: '生日' },
      { name: 'country', type: 'VARCHAR(32)', comment: '地域 - VN:越南，MY:马来西亚，TH:泰国，PH：菲律宾，ID:印度尼西亚' },
      { name: 'device', type: 'VARCHAR(32)', comment: '机型' },
    ],
  },
  {
    tableName: 'account_flow_record',
    tableComment: '用户付费流水',
    primaryKey: '',
    columns: [
      { name: 'user_id', type: 'VARCHAR(32)', comment: '用户ID' },
      { name: 'diamonds', type: 'INT', comment: '金额：钻石数量' },
      { name: 'create_time', type: 'VARCHAR(32)', comment: '时间' },
    ],
  },
  {
    tableName: 'chat',
    tableComment: '聊天数据',
    primaryKey: '',
    columns: [
      { name: 'user_a_id', type: 'VARCHAR(32)', comment: '用户A的ID' },
      { name: 'user_b_id', type: 'VARCHAR(32)', comment: '用户B的ID' },
      { name: 'chat_count', type: 'INT', comment: '条数' },
      { name: 'create_time', type: 'VARCHAR(32)', comment: '发起时间戳' },
    ],
  },
  {
    tableName: 'consume_diamonds',
    tableComment: '用户消费数据',
    primaryKey: '',
    columns: [
      { name: 'user_id', type: 'VARCHAR(32)', comment: '用户ID' },
      { name: 'action', type: 'VARCHAR(32)', comment: '消费动作' },
      { name: 'amount', type: 'INT', comment: '消费金额' },
      { name: 'create_time', type: 'VARCHAR(32)', comment: '消费时间' },
    ],
  },
  {
    tableName: 'feed',
    tableComment: '用户feed数据',
    primaryKey: '',
    columns: [
      { name: 'user_id', type: 'VARCHAR(32)', comment: '发起者' },
      { name: 'create_time', type: 'VARCHAR(32)', comment: '发起时间' },
      { name: 'feed_id', type: 'VARCHAR(32)', comment: 'feedId' },
    ],
  },
  {
    tableName: 'follow',
    tableComment: '用户关注数据',
    primaryKey: '',
    columns: [
      { name: 'user_a_id', type: 'VARCHAR(32)', comment: '用户A的ID' },
      { name: 'user_b_id', type: 'VARCHAR(32)', comment: '用户B的ID' },
      { name: 'create_time', type: 'VARCHAR(32)', comment: '时间戳' },
    ],
  },
  {
    tableName: 'match',
    tableComment: '用户匹配数据',
    primaryKey: '',
    columns: [
      { name: 'user_a_id', type: 'VARCHAR(32)', comment: '用户A的ID' },
      { name: 'user_b_id', type: 'VARCHAR(32)', comment: '用户B的ID' },
      { name: 'type', type: 'VARCHAR(32)', comment: '互动类型' },
      { name: 'create_time', type: 'VARCHAR(32)', comment: 'match的时间戳' },
      { name: 'like_other', type: 'VARCHAR(32)', comment: '给对方比心' },
      { name: 'other_like', type: 'VARCHAR(32)', comment: '被对方比心' },
      { name: 'chat_count', type: 'INT', comment: '消息聊天总数（voice的聊天总数都是0）' },
    ],
  },
  {
    tableName: 'user_action',
    tableComment: '用户行为数据',
    primaryKey: '',
    columns: [
      { name: 'user_id', type: 'VARCHAR(32)', comment: '用户ID' },
      { name: 'create_time', type: 'VARCHAR(32)', comment: '时间戳' },
    ],
  },
]);