qimall/console/migrations/M250711025432CreateMedicationRecipientTable.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Handles the creation of table `{{%medication_recipient}}`.
 */
class M250711025432CreateMedicationRecipientTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
CREATE TABLE `qimall_medication_recipient` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(20) NOT NULL DEFAULT '',
  `mobile` char(11) NOT NULL DEFAULT '',
  `id_card` varchar(18) NOT NULL DEFAULT '',
  `sex` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性别（1:男 2:女）',
  `age` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '年龄',
  `is_allergy_history` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否有过敏史（0:无 1:有）',
  `allergy_history_details` varchar(100) NOT NULL DEFAULT '' COMMENT '过敏史详情',
  `is_medical_history` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否有疾病史（0:无 1:有）',
  `sickness_detail` varchar(100) NOT NULL DEFAULT '' COMMENT '疾病史详情',
  `liver_function_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '肝功能（0:正常 1:异常）',
  `kidney_function_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '肾功能（0:正常 1:异常）',
  `pregnancy_breastfeeding_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '妊娠哺乳状态 （0:否 1:备孕中 2:怀孕中 3:正在哺乳 男性传0 默认0）',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) unsigned NOT NULL DEFAULT '0',
  `updated_at` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用药人表（药品类型的商品使用）';
SQL;

        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        return false;
    }
}