viw_salsalesdesign.md
2.7 KB
viw_salsalesdesign (view)
- Updatable: YES
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 | iOrder |
int |
NO |
| 7 | sFormId |
varchar(255) |
YES |
| 8 | sBillNo |
varchar(50) |
YES |
| 9 | sSrcId |
varchar(255) |
YES |
| 10 | sSrcSlaveId |
varchar(255) |
YES |
| 11 | sSrcNo |
varchar(255) |
YES |
| 12 | sGrade |
varchar(255) |
YES |
| 13 | sDesignName |
varchar(255) |
YES |
| 14 | sStates |
varchar(255) |
YES |
| 15 | tCompleteDate |
datetime |
YES |
| 16 | sProgressMemo |
longtext |
YES |
| 17 | sCustomerId |
varchar(255) |
YES |
| 18 | sCustomerName |
varchar(255) |
YES |
| 19 | sMemo |
text |
YES |
| 20 | tCheckDate |
datetime |
YES |
| 21 | sCheckPerson |
varchar(255) |
YES |
| 22 | bInvalid |
bit(1) |
YES |
| 23 | bCheck |
bit(1) |
YES |
| 24 | sStatus |
varchar(50) |
YES |
| 25 | sSlaveMemo |
text |
YES |
| 26 | sParentId |
varchar(100) |
NO |
| 27 | sSlaveId |
varchar(100) |
NO |
Definition
select `salsalesdesignmaster`.`sId` AS `sId`,`salsalesdesignmaster`.`sBrandsId` AS `sBrandsId`,`salsalesdesignmaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`salsalesdesignmaster`.`tCreateDate` AS `tCreateDate`,`salsalesdesignmaster`.`sMakePerson` AS `sMakePerson`,`salsalesdesignmaster`.`iOrder` AS `iOrder`,`salsalesdesignmaster`.`sFormId` AS `sFormId`,`salsalesdesignmaster`.`sBillNo` AS `sBillNo`,`salsalesdesignmaster`.`sSrcId` AS `sSrcId`,`salsalesdesignmaster`.`sSrcSlaveId` AS `sSrcSlaveId`,`salsalesdesignmaster`.`sSrcNo` AS `sSrcNo`,`salsalesdesignmaster`.`sGrade` AS `sGrade`,`salsalesdesignmaster`.`sDesignName` AS `sDesignName`,`salsalesdesignmaster`.`sStates` AS `sStates`,`salsalesdesignmaster`.`tCompleteDate` AS `tCompleteDate`,`salsalesdesignmaster`.`sProgressMemo` AS `sProgressMemo`,`salsalesdesignmaster`.`sCustomerId` AS `sCustomerId`,`salsalesdesignmaster`.`sCustomerName` AS `sCustomerName`,`salsalesdesignmaster`.`sMemo` AS `sMemo`,`salsalesdesignmaster`.`tCheckDate` AS `tCheckDate`,`salsalesdesignmaster`.`sCheckPerson` AS `sCheckPerson`,`salsalesdesignslave`.`bInvalid` AS `bInvalid`,`salsalesdesignslave`.`bCheck` AS `bCheck`,`salsalesdesignslave`.`sStatus` AS `sStatus`,`salsalesdesignslave`.`sMemo` AS `sSlaveMemo`,`salsalesdesignslave`.`sParentId` AS `sParentId`,`salsalesdesignslave`.`sId` AS `sSlaveId` from (`salsalesdesignmaster` join `salsalesdesignslave` on((`salsalesdesignmaster`.`sId` = `salsalesdesignslave`.`sParentId`)))
Narrative
No human-written narrative yet.