View ocum.inventoryscheduleview | Generated by SchemaSpy |
View Definition:
select `inventoryschedule`.`id` AS `id`,`inventoryschedule`.`name` AS `name`,`ocum`.`inventoryview`.`id` AS `viewId`,`ocum`.`inventoryview`.`name` AS `viewName`,`ocum`.`inventoryview`.`category` AS `viewType`,`ocum`.`inventoryview`.`style` AS `viewStyle`,`ocum`.`inventoryview`.`object` AS `objectType`,`inventoryschedule`.`recipients` AS `recipients`,`inventoryschedule`.`startTime` AS `startTime`,`inventoryschedule`.`intervalUnit` AS `intervalUnit`,`inventoryschedule`.`day` AS `day`,`inventoryschedule`.`format` AS `format`,`inventoryschedule`.`createdTimestamp` AS `createdTimestamp`,`inventoryschedule`.`createdBy` AS `createdBy` from (`ocum`.`inventoryviewschedule` `inventoryschedule` join `ocum`.`inventoryview` on((`inventoryschedule`.`viewId` = `ocum`.`inventoryview`.`id`)))
Possibly Referenced Tables/Views: