# hft_dw_data_generator

**Repository Path**: javacaoyu/hft_dw_data_generator

## Basic Information

- **Project Name**: hft_dw_data_generator
- **Description**: HFT数仓大学实训项目，数据生成器
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-03-20
- **Last Updated**: 2024-03-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# HFT新零售大数据数仓（实训项目）数据模拟器


## 业务表建表语句备份
### 店主信息表
```sql
create table store_owner(
    id int primary key auto_increment,
    name varchar(10),
    tel varchar(20),
    addr varchar(255),
    id_num varchar(20),
    birthday date,
    gender tinyint comment '1男 0女',
    province varchar(20),
    city varchar(20),
    district varchar(20),
    create_ts timestamp default current_timestamp,
    update_ts timestamp default current_timestamp,
    index(update_ts)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
```


### 店铺信息表
```sql
create table hft.store_info(
    id int primary key auto_increment,
    name varchar(100),
    addr varchar(255),
    province varchar(15),
    city varchar(15),
    district varchar(15),
    lng decimal(10, 6)  default 0,
    lat decimal(10, 6)  default 0,
    owner_id int,
    store_type tinyint,
    supplier_id tinyint,
    netpay_status tinyint comment '在线支付是否签约 1签约 0未签约',
    create_ts timestamp default current_timestamp,
    update_ts timestamp default current_timestamp,
    index(update_ts)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
```

### 会员信息表
```sql
create table member_info(
    id int primary key auto_increment,
    name varchar(10),
    gender tinyint comment '1男 0女',
    tel varchar(15),
    addr varchar(100),
    birthday date,
    province varchar(15),
    city varchar(15),
    district varchar(15),
    create_ts timestamp default current_timestamp,
    update_ts timestamp default current_timestamp,
    index(update_ts)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
```

### 订单和订单详情表
```sql
create table orders
(
    order_id                    varchar(255)   not null,
    store_id                    int            null comment '店铺ID',
    member_id                   varchar(255)   null comment '顾客会员ID',
    origin                      varchar(255)   null comment '原始信息(无用)',
    day_order_seq               int            null comment '本订单是当日第几单',
    discount_rate               decimal(30, 5) null comment '折扣率',
    discount_type               tinyint        null comment '折扣类型',
    discount                    decimal(30, 5) null comment '折扣金额',
    money_before_whole_discount decimal(30, 5) null comment '折扣前总金额',
    receivable                  decimal(30, 5) null comment '应收金额',
    erase                       decimal(30, 5) null comment '抹零金额',
    small_change                decimal(30, 5) null comment '找零金额',
    total_no_discount           decimal(30, 5) null comment '总价格(无折扣)',
    pay_total                   decimal(30, 5) null comment '付款金额',
    pay_type                    varchar(10)    null comment '付款类型',
    payment_channel             tinyint        null comment '付款通道',
    payment_scenarios           varchar(15)    null comment '付款描述(无用)',
    product_count               int            null comment '本单卖出多少商品',
    date_ts                     varchar(255)   null comment '订单时间'
);


create table orders_detail
(
    order_id     varchar(255)   not null comment '订单ID',
    barcode      varchar(255)   not null comment '商品条码',
    name         varchar(255)   null comment '商品名称',
    count        int            null comment '本单此商品卖出数量',
    price_per    decimal(30, 5) null comment '实际售卖单价',
    retail_price decimal(30, 5) null comment '零售建议价',
    trade_price  decimal(30, 5) null comment '贸易价格(进货价)',
    category_id  int            null comment '商品类别ID',
    unit_id      int            null comment '商品单位ID(包、袋、箱、等)'
);
```