@Data @TableName("pms_category") public class CategoryEntity implements Serializable { private static final long serialVersionUID = 1L; /** * 分类id */ @TableId private Long catId; /** * 分类名称 */ private String name; /** * 父分类id */ private Long parentCid; /** * 层级 */ p...
{pc:get sql="SELECT `n`.`inputtime`,`n`.`url`,`n`.`title`,`c`.`catname`,`c`.`url` as `c_url` FROM `v9_news` as `n` left join `v9_category` as `c` on `n`.`catid` = `c`.`catid` where `c`.`catid` in (6,7,8,9,10) order by `n`.`id` desc" num="10" ...
select * from hr_operating_units hou where hou.organization_id=204 --fnd select * from fnd_application select * from fnd_application_tl where application_id=101 select * from fnd_application_vl where application_id = 101 ---值集 select * from fnd_flex_value_sets select * from fnd_flex_...
{pc:get sql="SELECT `n`.`inputtime`,`n`.`url`,`n`.`title`,`c`.`catname`,`c`.`url` as `c_url` FROM `v9_news` as `n` left join `v9_category` as `c` on `n`.`catid` = `c`.`catid` where `c`.`catid` in (6,7,8,9,10) order by `n`.`id` desc" num="10" ...
select * from fnd_application_tl where application_id=101 select * from fnd_application_vl where application_id = 101 ---值集 select * from fnd_flex_value_sets select * from fnd_flex_values select * from fnd_flex_values_vl ---弹性域 select...
create table pms_category ( id bigint unsigned auto_increment comment '记录id', name varchar(50) default null comment '类别名称', parent_id bigint unsigned default 0 comment '父级类别id,如果无父级,则为0', depth tinyint unsigned default 1 comment '深度,最顶级类别的深度为1,次级为...
```sql create table pms_product_category ( id bigint not null auto_increment, parent_id bigint comment '上级分类的编号:0表示一级分类', name varchar(64) comment '名称', level int(1) comment '分类级别:0->1级;1->2级', product_count int comment '商品数量', product_unit varchar(64)...
Job Category Shoreside Operations Description Technical Planned Maintenance Builder (CMMS/PMS), populating clients software of choice with Equipment, Spare Parts, Maintenance, Scheduling and general upkeep of current vessel sites. Skills JOT ERP 1 years by 2019 Aurora PMS 3 years by 2018 ...
-- Dumping data for table `product_category` -- LOCK TABLES `product_category` WRITE; /*!40000 ALTER TABLE `product_category` DISABLE KEYS */; INSERT INTO `product_category` VALUES (1,'狗狗'),(2,'宠物用品'); /*!40000 ALTER TABLE `product_category` ENABLE KEYS */; UNLOCK ...
步骤2大类经理审批(Category Manager) 描述: 内容:无 操作:同意、拒绝、退回发起人重填 步骤3财务总账会计审批(Finance Accountant) 描述: 内容:改Accounts Code 操作:同意、拒绝、退回发起人重填 步骤4 Cost Center经理审批(Cost Center Manager) 描述: ...