#采购申请单表
drop table if exists purchase_application;
create table purchase_application
(
    id                    bigint auto_increment primary key,
    application_no        varchar(50)    not null comment '申请单号',
    supplier_id           bigint         null comment '供应商id',
    supplier_name         varchar(100)   null comment '供应商名称',
    project_name          varchar(100)   null comment '项目名称',
    sales_contract_no     varchar(50)    null comment '销售合同号',
    sales_ledger_id       int            null comment '关联销售台账主表主键',
    applicant_id          bigint         null comment '申请人id',
    applicant_name        varchar(50)    null comment '申请人姓名',
    apply_date            date           null comment '申请日期',
    expected_arrival_date date           null comment '期望到货日期',
    contract_amount       decimal(10, 2) null comment '申请金额（含税总价）',
    payment_method        varchar(255)   null comment '付款方式',
    remarks               text           null comment '备注',
    status                tinyint        not null default 0 comment '状态 0草稿 1已生成订单',
    purchase_ledger_id    bigint         null comment '转订单后生成的采购台账id',
    convert_time          datetime       null comment '转订单时间',
    tenant_id             bigint         null comment '租户ID',
    dept_id               bigint         null comment '部门ID',
    create_user           bigint         null comment '创建人ID',
    create_time           datetime       null comment '创建时间',
    update_time           datetime       null comment '更新时间',
    index idx_application_no (application_no),
    index idx_supplier_id (supplier_id),
    index idx_purchase_ledger_id (purchase_ledger_id)
);

#采购申请产品明细表
drop table if exists purchase_application_product;
create table purchase_application_product
(
    id                        bigint auto_increment primary key,
    purchase_application_id   bigint         not null comment '采购申请单id',
    product_id                bigint         null comment '产品id',
    product_model_id          bigint         null comment '产品规格id',
    product_category          varchar(100)   null comment '产品大类',
    specification_model       varchar(100)   null comment '规格型号',
    unit                      varchar(20)    null comment '单位',
    quantity                  decimal(18, 2) not null default 0 comment '数量',
    tax_rate                  decimal(5, 0)  null comment '税率',
    tax_inclusive_unit_price  decimal(18, 2) null comment '含税单价',
    tax_inclusive_total_price decimal(18, 2) null comment '含税总价',
    tax_exclusive_total_price decimal(18, 2) null comment '不含税总价',
    invoice_type              varchar(50)    null comment '发票类型',
    is_checked                tinyint(1)     not null default 1 comment '是否推送质检',
    remark                    varchar(255)   null comment '备注',
    tenant_id                 bigint         null comment '租户ID',
    dept_id                   bigint         null comment '部门ID',
    create_user               bigint         null comment '创建人ID',
    create_time               datetime       null comment '创建时间',
    update_time               datetime       null comment '更新时间',
    index idx_purchase_application_id (purchase_application_id)
);