manager

Tables (3)

manager

  • manager_id — int — Primary key — NOT NULL
  • manager_name — varchar(20)
  • manager_create_dt — datetime
  • manager_update_dt — datetime
  • manager_delete_dt — datetime

manager_exec

  • manager_exec_id — int — Primary key — NOT NULL
  • manager_exec_name — varchar(20)
  • manager_exec_create_dt — datetime
  • manager_exec_update_dt — datetime
  • manager_exec_delete_dt — datetime

manager_plan

  • manager_plan_id — int — Primary key — NOT NULL
  • manager_id — int — Foreign key → manager.manager_id — NOT NULL
  • manager_exec_id — int — Foreign key → manager_exec.manager_exec_id — NOT NULL
  • execute_order — int
  • manager_status — tinyint
  • manager_plan_rows — int