ERD_psw

Tables (6)

t_ARCHLOGIN (Untitled6)

  • loginid — varchar2(20) — Primary key
  • pass — varchar2(20)

t_JOBHISTORY (Untitled5)

  • exec_date — date — Primary key — NOT NULL
  • schedname — varchar2(40) — Foreign key → t_SCHEDULE.schedname — NOT NULL
  • jobname — varchar2(40) — Foreign key → t_SCHEDULE.jobname — NOT NULL
  • srvname (src_srvname) — varchar2(20) — Foreign key → t_SCHEDULE.srvname — NOT NULL
  • userid (src_userid) — varchar2(20) — Foreign key → t_SCHEDULE.userid — NOT NULL
  • groupname (src_groupname) — varchar2(40) — Foreign key → t_SCHEDULE.groupname — NOT NULL
  • success — boolean
  • starttime — date
  • enddate — date

t_JOBPOLICY (Untitled3)

  • jobname — varchar2(40) — Primary key — NOT NULL
  • srvname (src_srvname) — varchar2(20) — Foreign key → t_SRC_CONNINFO.srvname — NOT NULL
  • userid (src_userid) — varchar2(20) — Foreign key → t_SRC_CONNINFO.userid — NOT NULL
  • groupname (src_groupname) — varchar2(40) — Foreign key → t_SRC_CONNINFO.groupname — NOT NULL
  • src_tablename — varchar2(100) — NOT NULL
  • tar_tablespace — varchar2(100) — NOT NULL
  • regdate — date
  • autopurge — boolean — NOT NULL
  • confirm — boolean — NOT NULL
  • script — varchar2(5000)
  • description — varchar2(100)

t_SCHEDULE (Untitled4)

  • schedname — varchar2(40) — Primary key — NOT NULL
  • jobname — varchar2(40) — Foreign key → t_JOBPOLICY.jobname — NOT NULL
  • srvname (src_srvname) — varchar2(20) — Foreign key → t_JOBPOLICY.srvname — NOT NULL
  • userid (src_userid) — varchar2(20) — Foreign key → t_JOBPOLICY.userid — NOT NULL
  • groupname (src_groupname) — varchar2(40) — Foreign key → t_JOBPOLICY.groupname — NOT NULL
  • specificdate — date
  • recursive — boolean
  • recur_cycle — varchar2(10)
  • schedtime — varchar2(30)

t_SRC_CONNINFO (Untitled)

  • srvname — varchar2(20) — Primary key — NOT NULL
  • userid — varchar2(20) — Primary key — NOT NULL
  • groupname — varchar2(40) — Foreign key → t_SRC_GROUP.groupname — NOT NULL
  • passwd — varchar2(20)
  • ipaddr — varchar2(20) — NOT NULL
  • port — varchar2(10) — NOT NULL
  • savepass — boolean — NOT NULL
  • type — varchar2(1)

t_SRC_GROUP (Untitled2)

  • groupname — varchar2(40) — Primary key — NOT NULL
  • parentlvl — number — NOT NULL
  • currentlvl — number — NOT NULL
  • type — varchar2(1) — NOT NULL