# `viw_mftproductparam` (view)

> VIEW


- **Updatable:** YES
- **Definer:** `xlyprint@%`

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sId` | `varchar(100)` | NO |
| 2 | `sBrandsId` | `varchar(100)` | NO |
| 3 | `sSubsidiaryId` | `varchar(100)` | NO |
| 4 | `tCreateDate` | `datetime` | NO |
| 5 | `sMakePerson` | `varchar(255)` | NO |
| 6 | `sFormId` | `varchar(100)` | NO |
| 7 | `iOrder` | `int` | NO |
| 8 | `sBillNo` | `varchar(255)` | NO |
| 9 | `sMemo` | `text` | YES |
| 10 | `bCheck` | `bit(1)` | NO |
| 11 | `tCheckDate` | `datetime` | YES |
| 12 | `sCheckPerson` | `varchar(255)` | YES |
| 13 | `bPrint` | `bit(1)` | NO |
| 14 | `bCopyLimit` | `bit(1)` | NO |
| 15 | `sStatus` | `varchar(255)` | YES |
| 16 | `bInvalid` | `bit(1)` | NO |
| 17 | `sType` | `varchar(255)` | NO |
| 18 | `iParamOrder` | `int` | NO |
| 19 | `sParamParam1` | `varchar(255)` | YES |
| 20 | `sParamParam2` | `varchar(255)` | YES |
| 21 | `sParamParam3` | `varchar(255)` | YES |
| 22 | `sParamParam4` | `varchar(255)` | YES |
| 23 | `sParamParam5` | `varchar(255)` | YES |
| 24 | `sParamParam6` | `varchar(255)` | YES |
| 25 | `sParamParam7` | `varchar(255)` | YES |
| 26 | `sParamParam8` | `varchar(255)` | YES |
| 27 | `sParamParam9` | `varchar(255)` | YES |
| 28 | `sParamParam10` | `varchar(255)` | YES |
| 29 | `sParamParam11` | `varchar(255)` | YES |
| 30 | `sParamParam12` | `varchar(255)` | YES |
| 31 | `sParamParam13` | `varchar(255)` | YES |
| 32 | `sParamParam14` | `varchar(255)` | YES |
| 33 | `sParamParam15` | `varchar(255)` | YES |
| 34 | `dParamParam1` | `decimal(18,6)` | YES |
| 35 | `dParamParam2` | `decimal(18,6)` | YES |
| 36 | `dParamParam3` | `decimal(18,6)` | YES |
| 37 | `dParamParam4` | `decimal(18,6)` | YES |
| 38 | `dParamParam5` | `decimal(18,6)` | YES |
| 39 | `dParamParam6` | `decimal(18,6)` | YES |
| 40 | `bNotColor` | `bit(1)` | NO |
| 41 | `tParamDate` | `datetime` | YES |
| 42 | `sKnifeMouldId` | `varchar(100)` | NO |
| 43 | `sMaterialsId` | `varchar(100)` | NO |

## Definition

```sql
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`sFormId` AS `sFormId`,`m`.`iOrder` AS `iOrder`,`m`.`sBillNo` AS `sBillNo`,`m`.`sMemo` AS `sMemo`,`m`.`bCheck` AS `bCheck`,`m`.`tCheckDate` AS `tCheckDate`,`m`.`sCheckPerson` AS `sCheckPerson`,`m`.`bPrint` AS `bPrint`,`m`.`bCopyLimit` AS `bCopyLimit`,`m`.`sStatus` AS `sStatus`,`m`.`bInvalid` AS `bInvalid`,`m`.`sType` AS `sType`,`p`.`iOrder` AS `iParamOrder`,`p`.`sParam1` AS `sParamParam1`,`p`.`sParam2` AS `sParamParam2`,`p`.`sParam3` AS `sParamParam3`,`p`.`sParam4` AS `sParamParam4`,`p`.`sParam5` AS `sParamParam5`,`p`.`sParam6` AS `sParamParam6`,`p`.`sParam7` AS `sParamParam7`,`p`.`sParam8` AS `sParamParam8`,`p`.`sParam9` AS `sParamParam9`,`p`.`sParam10` AS `sParamParam10`,`p`.`sParam11` AS `sParamParam11`,`p`.`sParam12` AS `sParamParam12`,`p`.`sParam13` AS `sParamParam13`,`p`.`sParam14` AS `sParamParam14`,`p`.`sParam15` AS `sParamParam15`,`p`.`dParam1` AS `dParamParam1`,`p`.`dParam2` AS `dParamParam2`,`p`.`dParam3` AS `dParamParam3`,`p`.`dParam4` AS `dParamParam4`,`p`.`dParam5` AS `dParamParam5`,`p`.`dParam6` AS `dParamParam6`,`p`.`bNotColor` AS `bNotColor`,`p`.`tParamDate` AS `tParamDate`,`p`.`sKnifeMouldId` AS `sKnifeMouldId`,`p`.`sMaterialsId` AS `sMaterialsId` from (`xlyweberp_saas_ai`.`mftproductmaster` `m` join `xlyweberp_saas_ai`.`mftproductparam` `p` on((`m`.`sId` = `p`.`sParentId`)))
```

## Narrative

_No human-written narrative yet._